Tagged Questions
0
votes
0answers
12 views
Units of Geometry & Geography data type [duplicate]
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 ...
3
votes
1answer
338 views
PostGIS 2.0 ST_Transform with Rasters cannot find custom SRID
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 ...
1
vote
1answer
249 views
How to transform ETRS to EPSG?
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 ...
1
vote
2answers
2k views
Getting a Bounding Box in Latitude / Longitude using PostGIS shp2pgsql
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 ...
2
votes
1answer
395 views
Postgis: WGS84 Lat Lon Point to Gauss-Kruger 3
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:
...
6
votes
3answers
616 views
Retrieve polygon smallest MBR
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 ...
7
votes
1answer
1k views
How do I get a country border data set into my geography column?
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 ...
2
votes
1answer
426 views
How to convert SHP/POSTGIS data into x, y, z, “cost” data?
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) ?
