When you store data using the Geography data type (like in PostGIS), is it always in lon/lat in degree decimals? For the Geometry data type, what are the units used in the coordinate pairs? Can it ...
I'm trying to calculate an average value in a buffer around a point. Given a raster in EPSG 4326 and a similar point, this is fine, except that the values will be skewed as they are not projected in ...
I have data in the ETRS 89 LAEA format (SRID: 3035). But I have problems to transform it. Example data: N2736 E4541 I want to transform it to EPSG WGS84 (SRID: 4326), to check the coordinates on ...
Using the PostGIS shp2pgsql -s 4326 ... I generated the sql file and created my spatially enabled table. When executing my query: select box2d(ST_extent(the_geom)) from feature_data; I'm returned ...
How do I convert a WGS84 lat lon point in postgis to Guass Kruger 3 (31467)? Somehow, I do not seem to get it right. I tried the usual way for converting projections: ...
I have a postgis table containing polygons. I want to transform my polygons to 4 points polygons : retrieve the smallest MBR. Here comes an illustration of what I want : My original polygon is ...
I have a PostGis database with a multipolygon geography (as opposed to geometry) column. I'd like to fill it with the country border data available from ...
Is there a way to convert a line layer (shp or PostGIS) data into (x, y , z, cost) i.e. (From_node, To_node, optional_Elevation, Cost/Weight) ?