New answers tagged postgis-2.0
Yes, the default SRID in PostGIS is zero meaning unknown or local coordinate system. You can take advantage of all geometry-based queries and functions -- except any that transform or project between known coordinate systems. (Geography-based queries and functions won't make any sense.)
I just had the same problem on Ubuntu Server 14.04. I installed postgis extension from the official ubuntu repositories. So I used # apt-get install postgis. Then, find /usr -name postgis.control didn't return any result. The reason was extension/postgis.control wasn't installed because of postgis-scripts wasn't. $ aptitude search postgis i ...
(1) Yes. osm2po creates a SQL import file, which already contains the routing topology. (2) Yes. You just need to convert kilometers to miles. If you use km AS cost in your pgRouting query, then your route cost attribute will be in km as well. (3) For the address lookup you need a Geocoder, for example Nominatim. When you know the point coordinates, you ...
That's a feature in pgadmin/PostGIS - it won't show geometry column values if they are too long. It's mentioned in the PostGIS manual http://postgis.net/docs/manual-dev/PostGIS_FAQ.html#pgadmin_shows_no_data_in_geom
I fix it. CLASSITEM name CLASS EXPRESSION "Distrito1" OUTLINECOLOR 255 255 255 END CLASS EXPRESSION "Distrito2" OUTLINECOLOR 0 255 255 END CLASS EXPRESSION "Distrito3" OUTLINECOLOR 0 128 255 END
The "ST_UpdateGeometrySRID" function transfers the the spatial reference system of you data into another coordinate system and then UPDATE the geometry column of the existing table, which means it would change the spatial reference system of your table/geometry column and save it forever. Yet "ST_Transform" would only return you the new geometry with it's ...
UpdateGeometrySRID is only changing the SRID in all necessary places taking care of the triggers. Use case is that user has imported data with wrong SRID code and wants to correct it without making a new import. Function does not reproject the data like ST_Transform does and coordinate values will remain the same after UpdateGeometrySRID. For the second ...
Top 50 recent answers are included