Tagged Questions
5
votes
3answers
95 views
How to insert a GeoJSON polygon into a PostGIS table?
I need to insert a polygon from GeoJSON to my PostGIS table. This is how the SQL query looks like.
INSERT INTO tablename (name, polygon)
VALUES
(
'Name',
ST_GeomFromGeoJSON
(
{
...
0
votes
1answer
34 views
Force Geoserver SRID 0
I'm developing a gis solution which uses only geometry data.
I designed my spatial DB with PostGIS and now I'm performing some trials connecting the DB with GeoServer map server (using the ...
1
vote
1answer
78 views
PostGIS not converting GIS data into latitude/longitude values
I am running PostgreSQL and PostGIS. I am trying to do something mind-numbingly simple: determine the latitude and the longitude of a point.
Unfortunately, PostGIS stubbornly refuses to transform the ...
2
votes
1answer
62 views
Calculating points in the USDA's Cropland Data Layer coordinate system
I need to integrate against the USDA's cropland data layer. They've got a demo and some API docs.
The important query I need to run is this, given an (x, y) of say (1551459.363, 1909201.537):
...
1
vote
0answers
43 views
How to import multiple shapefiles each with different source projections to postgis
I have a couple thousand .zip files each with a .shp, .dbf, .shx, and .prj inside them that I want to load into postgis. The problem is, they have many different source projections (each defined in ...
1
vote
3answers
105 views
finding the definition of missing srid in postgis
I am converting a spatial Oracle database to POSTGIS, and one of the problems I encounter is that we use SRID in Oracle that do not exist in POSTGIS.
I am talking about the following SRID:
90112 : ...
2
votes
0answers
93 views
Creating Ellipse in WGS84, but with metric parameters
I have the function
--Ellipse(x,y,rx,ry,rotation,#of segments in 1/4 of ellipse)
SELECT ST_Translate( ST_Rotate( ST_Scale( ST_Buffer(ST_Point(0,0), 0.5, $6), $3, $4), $5), $1, $2)
I have points in ...
1
vote
1answer
334 views
SRID 4326 and geometry conversion
From this line:
SELECT ST_AsEWKT(geom) FROM buildings LIMIT 1;
I get this result:
"SRID=4326;MULTIPOLYGON(((404269.308014269 4543087.6184561,...)))"
I'm wondering if the coordinations are ...
1
vote
1answer
223 views
How to fix incorrect SRID of the geometry column?
I've been told to use AddGeometryColumn to properly add a column with correct/preferred SRID. however I wonder if it's possible to fix/change the current column instead of adding a new?
If there's no ...
0
votes
1answer
70 views
Why does Find_SRID return zero?
using
SELECT Find_SRID('public', 'myTable', 'myColumn');
I get zero as the result, what does it mean?
Regards,
3
votes
3answers
176 views
How to find SRID for random polygon?
I'm testing spatial database performance on a dataset. Spatial objects in this dataset (stored as WKT in a flat text file) are random valid polygons which have vertex coordinates (x,y) where 100,000> ...
0
votes
0answers
228 views
PostGIS geometry aggregation problem
i have a problem with aggregation of geometry either with ST_Collect, ST_Union, Array_Agg after doing intersection with transformed geometry.
Faulty PSQL code goes like this:
SELECT ...
5
votes
2answers
551 views
What is the SRID of census.gov shapfiles?
I downloaded the county files from:
http://www.census.gov/cgi-bin/geo/shapefiles2011/main
I cannot figure out what SRID to use with them. When I am trying to generate a class file from ./manage.py ...
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 ...
2
votes
2answers
1k views
Problem when calculating longitude and latitude for points
I have a PostGIS database with SRID=900913 (Google Mercator) and I would like to know the latitude and longitude of points.
I use this command:
ST_X(ST_TRANSFORM(the_geom,4283))
Following what is ...
3
votes
1answer
778 views
How to get the coordinate system from a PostGIS database?
My question is probably amazinlgy stupid, but I can't find the answer myself.
I would like to extract from a database the latitude and longitude of points. For now, I'm getting x(the_geom) and ...
1
vote
1answer
106 views
Get relative north aligned point 2163 (US Equal Area)
What I'm trying to do is create a grid where the y axis is north aligned. I have a origin Lat/Lon point which is the bottom left corner of the grid and each cell should be 100 by 100 meters. So I ...
3
votes
1answer
161 views
How to mix coordinate systems in GeoDjango?
This is a beginner question about working with different coordinate systems in GeoDjango.
I've got a GeoDjango object with a polygon field, stored as OSGB coordinates:
class Region(models.Model):
...
13
votes
6answers
4k views
Shapefile PRJ to PostGIS SRID lookup table?
I was wondering if there is such a thing as an shapefile PRJ to PostGIS SRID lookup table? Something that can translate the most standard shapefile PRJ definitions into the likely SRID.
When using ...
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 ...
