2
votes
1answer
79 views

PostGIS ST_Contains query returns null

I have a shapefile of all US States that I've imported into a table with a multipolygon geometry column. (SRID 4326) I perform a spatial query based on lat/lon to return the state abbreviation. This ...
0
votes
1answer
518 views

Choosing best projection/SRID

I created a shape in OpenJump and exported it to shape(ESRI) file and then imported it to SQL2008 via shape2sql , the problem is that it shows bigger than what I want, In OpenJump it shows 1meter ...
3
votes
2answers
2k views

ogr2ogr srs options: where is the well known definition determined?

In the ogr2ogr documentation it says that when using -a_srs srs_def: Srs_def can be a full WKT definition (hard to escape properly), or a well known definition (ie. EPSG:4326) or a file with a WKT ...