Tag Info

New answers tagged

2

You are currently only querying the points table. Railway stations might as well be mapped as polygons. A good strategy to get all commonly used OSM tags is to display your data on top of an openstreetmap background (e.g. with the openlayers plugin in QGIS), and look for missing stations. You can install the JOSM editor, zoom to the missing object, ...


1

Looking at http://wiki.openstreetmap.org/wiki/Tag:railway%3Dstation it seems that the new tag is public_transport=station though it is hard to see if that is a recent change or not.


2

I would prefer EPSG:3035. The ESRI codes might not be available on all platforms: EPSG:2163 has a different lon_0 leading to a distortion of the map:


1

Actually it would work as both are about ~~~~ the same latitiude but use the Euro version http://spatialreference.org/ref/esri/102013/


4

You could calculate ST_Area on a geography type. Since you have data with WGS84 (SRID=4326), you can add a simple geography cast, e.g. SELECT ST_Area(geom::geography) which will return area in m² on a curved surface (sphereoid by default). This should be pretty close to the true surface area, without requiring any projection. It would be interesting to ...


2

UPDATE: Your problem seems to be with your data. Here is a snippet of your file: }, "geometry": { "type": "Polygon", "coordinates": [ [ [ 585951.8, 181704.9 ], [ 576293.9, 181299.8 ], If I'm not mistaken, those ...



Top 50 recent answers are included