478 reputation
112
bio website
location
age
visits member for 1 year, 9 months
seen Apr 15 at 5:09

Apr
15
revised PostGIS to GeoJSON with GDAL: how to get lat/longs?
added 225 characters in body
Apr
14
awarded  Quorum
Apr
14
comment PostGIS to GeoJSON with GDAL: how to get lat/longs?
Actually this is still wrong - if I'd even looked at the screenshot I was taking I'd notice. They're lat-longs, but way off. (The left end of the orange line in the above pic should be exactly at Skipton, top left.)
Apr
14
comment PostGIS to GeoJSON with GDAL: how to get lat/longs?
Looks like the basic cause of this is a bug in ogr2ogr - there is no CRS (coordinate reference system) element included in the GeoJSON output. Apparently fixed in 1.10.0, but I only have 1.9.2. trac.osgeo.org/gdal/ticket/4995
Apr
13
answered PostGIS to GeoJSON with GDAL: how to get lat/longs?
Apr
13
comment PostGIS to GeoJSON with GDAL: how to get lat/longs?
Thank you! I didn't know about st_asgeojson - that will probably work, although one hiccup is there are several line segments per osm_id, which ogr2ogr automatically merges (or at least combines into one file). I still don't quite understand why ogr2ogr is producing projected coordinates which, say, Github.io is incapable of rendering.
Apr
13
accepted Render a map showing lots of individual traces/routes simultaneously
Apr
13
accepted Extract PostGIS line features to GPX
Apr
13
accepted How to create a new 'gis' database in PostGIS?
Apr
13
accepted Can't install CartoDB on Ubuntu Lucid - mapnik dependency issue
Apr
13
answered Can't install CartoDB on Ubuntu Lucid - mapnik dependency issue
Apr
13
asked PostGIS to GeoJSON with GDAL: how to get lat/longs?
Mar
27
answered How to Export Feature GeoJSON from PostGIS
Mar
20
comment Can't install CartoDB on Ubuntu Lucid - mapnik dependency issue
Thanks very much. Yes, the documentation is definitely at least a little bit out of date, as some of the other commands didn't work quite right. I think it would probably say if they'd switched the target install platform from Lucid. Hm. Anyway, will see how far I get.
Mar
18
comment Can't install CartoDB on Ubuntu Lucid - mapnik dependency issue
Well, what do you mean by "wrong". All the steps I've taken are following the CartoDB instructions, and are documented in the two gists. This was a clean Lucid image.
Mar
18
comment Can't install CartoDB on Ubuntu Lucid - mapnik dependency issue
Ok, didn't get far. Ran into the same problem with a dependency for mapnik: build-essential: Depends: dpkg-dev (>= 1.13.5) but it is not going to be installed \ python-dev: Depends: python2.6-dev (>= 2.6.5) but it is not going to be installed (following instructions here)
Mar
18
comment Can't install CartoDB on Ubuntu Lucid - mapnik dependency issue
Building mapnik from source? Sure, I guess. Will that achieve the same thing as installing libmapnik-dev, python-mapnik and mapnik-utils?
Mar
18
asked Can't install CartoDB on Ubuntu Lucid - mapnik dependency issue
Feb
12
accepted Can I use leaflet to access a WMS service published as an OpenLayers javascript API?
Feb
1
accepted Refer to zoom level in TileMill expressions