rastermanden

brew install postgres --use-gcc --no-perl

rastermanden

curl --dump-header - -H "Content-Type: application/json" -X POST --data '{
   "extent":{
      "name":"Randers kommune",
      "x_max":123.0,
      "x_min":123.0,
      "y_max":123.0,
      "y_min":23.0
   },
   "layer":[
      {

rastermanden

POLYGON((640956.61 6178006.09,640956.61 6210602.82,675346.65 6210602.82,675346.65 6178006.09,640956.61 6178006.09),(658193.37 6196275.01,658247 6196257.05,658248.95 6196336.88,658214.7 6196324.19,658193.37 6196275.01),(658122.06 6196318.71,658127.57 6196302.24,658167.67 6196323,658158.34 6196327.12,658122.06 6196318.71),(647936.76 6182615.63,647806.94 6182557.71,647807.1 6182552.84,647931.9 6182595.38,647936.76 6182615.63),(649053.21 6184057.1,649067.36 6184069.69,649064.8 6184081.59,649051.68 6184062.23,649053.21 6184057.1),(670006.74 6192760.16,670027.39 6192758.96,670034.54 6192779.23,670016.14 6192782.61,670006.74 6192760.16),(669911.52 6193008.62,669925.73 6193015.18,669903.74 6193053.69,669900.79 6193045.49,669911.52 6193008.62),(651047.15 6179406.56,651519.07 6179006.09,651885.01 6179175.96,652304.99 6179468.55,652889.08 6179559.84,653264.01 6179318.71,653685.56 6179248.44,654126.92 6179266.9,654422.83 6179324.28,654482.29 6179456.64,654459.49 6179333.58,654841.1 6179572.52,655136.09 6179708.41,655404.

rastermanden

"{"type":"Polygon","coordinates":[[[640956.61,6178006.09],[640956.61,6210602.82],[675346.65,6210602.82],[675346.65,6178006.09],[640956.61,6178006.09]],[[658193.37,6196275.01],[658247,6196257.05],[658248.95,6196336.88],[658214.7,6196324.19],[658193.37,6196275.01]],[[658122.06,6196318.71],[658127.57,6196302.24],[658167.67,6196323],[658158.34,6196327.12],[658122.06,6196318.71]],[[647936.76,6182615.63],[647806.94,6182557.71],[647807.1,6182552.84],[647931.9,6182595.38],[647936.76,6182615.63]],[[649053.21,6184057.1],[649067.36,6184069.69],[649064.8,6184081.59],[649051.68,6184062.23],[649053.21,6184057.1]],[[670006.74,6192760.16],[670027.39,6192758.96],[670034.54,6192779.23],[670016.14,6192782.61],[670006.74,6192760.16]],[[669911.52,6193008.62],[669925.73,6193015.18],[669903.74,6193053.69],[669900.79,6193045.49],[669911.52,6193008.62]],[[651047.15,6179406.56],[651519.07,6179006.09],[651885.01,6179175.96],[652304.99,6179468.55],[652889.08,6179559.84],[653264.01,6179318.71],[653685.56,6179248.44],[654126.92,6179266.9]

rastermanden

/******************************************************************************
 * $Id$
 *
 * Project:  ElasticSearch Translator
 * Purpose:
 * Author:
 *
 ******************************************************************************
 * Copyright (c) 2011, Adam Estrada
 *

rastermanden

Martins-MacBook-Pro:happymap mbj$ jitsu deploy 
info:    Welcome to Nodejitsu kukka
info:    jitsu v0.12.11, node v0.10.9
info:    It worked if it ends with Nodejitsu ok
info:    Executing command deploy
info:    Analyzing application dependencies in node app.js
info:    Checking app availability happymap
info:    Creating app happymap
info:    Creating snapshot 0.0.1-1
info   Uploading: [=============================] 100%

rastermanden

rastermanden

COPY
(SELECT beliggenhedsadresse_kommune_kode, count(*) as antal
 FROM cvr.virksomheder 
  WHERE beliggenhedsadresse_kommune_kode <> ''
   GROUP BY beliggenhedsadresse_kommune_kode
   ORDER BY antal DESC)
 TO PROGRAM 'cat <&0 > /tmp/data.csv; curl -F "file=@/tmp/data.csv;filename=cartodbtablename.csv" "https://{CARTODB_USER}.cartodb.com/api/v1/imports/?api_key={APIKEY}"'
   DELIMITER ',' 
   CSV HEADER; 

rastermanden

�PNG

���
IHDR������������j.>���tRNS��v��8���IDATx���[r� �T�e��66H<��Ni�Rv��4�$ ��(�������k[�l��+g�YgZ""��E6`KdGg�z��
s(�,�� 0[̒{5+�?����ć̺ٚ��n��I�jZY�7�]�A�́�m��]JSP[W
sCdj��
�1,�e^瞘�vg���:�i�%".�M�p����k�S�x��:�*��3f��:L��5a�v�1c�i��(�
0��t�17��a��"�ô~s?7���9�0[sScn�/u��ie�a����?�]���U������<�a���:+���9���]Q'��VU���m%hߢڪ��Nk��hW��� +�`ӂ��)�8hZP[4�U��Lǝ��K��hZP[(=�@��.���Mj��W.hZP[��д��0*�>�iAmQ�6}Mj��)HhZP[}L#�i��9�Mj��ʺ	4-�-�jk_д���U]������44-��h5�@�2�{.CS�c[|�s���i�w�F�Q�D;�f��N'6ƛ�J�
����g{@�n��ie+����iT�.VJ�'����fXEӗ_��o�ի�}3�w���4��0<U97!�%�A�Yje��f9�
����=���T(�=������?�o��s}#S0?�`�Ń ��A0�tj;V#�M�ë�h�S�À���"��0�?p[n�A8�����IEND�B`�

rastermanden

alias psql2markdown=" sed 's/+/|/g' | sed 's/^/|/' | sed 's/$/|/' |  grep -v rows | grep -v '||'"