Skip to content

Instantly share code, notes, and snippets.

@rastermanden
rastermanden / mac: install postgres
Created February 9, 2013 22:19
mac: install postgres
brew install postgres --use-gcc --no-perl
@rastermanden
rastermanden / post_septimamaps
Created February 13, 2013 09:43
POST: septimamaps create map
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
rastermanden / wkt
Created February 19, 2013 12:31
wkt
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
rastermanden / json
Created February 19, 2013 12:31
json
"{"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
rastermanden / gist:5052132
Last active December 14, 2015 07:39
ogrelasticsearch driver
/******************************************************************************
* $Id$
*
* Project: ElasticSearch Translator
* Purpose:
* Author:
*
******************************************************************************
* Copyright (c) 2011, Adam Estrada
*
@rastermanden
rastermanden / jitsuerror
Created June 11, 2013 19:32
nodejitsu deploy error
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 / map.geojson
Created August 12, 2013 20:27
via:geojson.io
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@rastermanden
rastermanden / localpg2cartodb
Created February 13, 2015 09:36
local-pg-2cartodb
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
rastermanden / 1221.png
Last active August 29, 2015 14:16
herlev_geom
�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[WsCdj��
�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[(=�@��.���M j ��W.hZP[��д��0*�>�iAmQ�6}M j ��)HhZP[ }L#�i��9�M j��ʺ 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
rastermanden / psql2markdown
Created March 11, 2015 20:26
termial alias to convert psql output to markdown tables
alias psql2markdown=" sed 's/+/|/g' | sed 's/^/|/' | sed 's/$/|/' | grep -v rows | grep -v '||'"