Tag Info

New answers tagged

2

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 ...


2

(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 ...


1

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


0

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


0

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 ...


1

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 ...


3

I made and tested the functions I need. For point generation I used a simplified version of the functions in trac.osgeo.org/postgis/wiki/UserWikiRandomPoint: CREATE OR REPLACE FUNCTION random_point( x_min integer DEFAULT 13, y_min integer DEFAULT 49, x_max integer DEFAULT 16, y_max integer DEFAULT 51, srid integer DEFAULT 4326 ) RETURNS geometry AS ...



Top 50 recent answers are included