A Spatial Reference System Identifier (SRID) is a unique value used to unambiguously identify projected, unprojected, and local spatial coordinate system definitions
4
votes
3answers
84 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
32 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
73 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
1answer
46 views
problem with writing the srsName into the gml output in OpenLayers
I am trying to write out my geometry in gml format after it is drawn in OpenLayers. Actually it is working fine, I get the gml like this:
<gml:Polygon>
<gml:outerBoundaryIs>
...
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 ...
2
votes
1answer
71 views
add new SRID to sql server
Is it possible to add a new SRID to sql server 2012?
I've tried
insert into sys.spatial_reference_systems values (4938, 'GEOCCS["GDA94",DATUM["Geocentric Datum of Australia 1994",SPHEROID["GRS ...
1
vote
3answers
94 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
92 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
321 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
210 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
67 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
167 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> ...
1
vote
2answers
257 views
Why is Spatialite delivering “Invalid SRID” error message
Qspatialite in QGIS 1.8 (and also Spatialite-gui) delivers an "Invalid SRID" error message when I try to load shapefiles with a SRID value of 3814 (Mississippi Transverse Mercatur). The SRID is ...
3
votes
1answer
221 views
how to add a custom SRID to Spatialite
I'd like to create a spatialite database and load it with shapefiles using the Mississippi Transverse Mercator (MSTM) projection, but it doesn't have an EPSG definition in the spatialite library of ...
2
votes
0answers
68 views
How to do Spatial Tools Projections between different projection types
I am working with the SQL Spatial Tools from http://sqlspatialtools.codeplex.com/
And a variety of data sets, primarily from LINZ and Google.
These involve working with projections for
4326 (WGS84?)
...
0
votes
0answers
226 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 ...
2
votes
3answers
913 views
SQL Server Geometry to geography conversion
I have imported a number of Shape files from the ordnance survey using shape2SQL
these have been imported as geometry however i would like to convert them to Geography and specifically to srid 4326
...
3
votes
0answers
103 views
ArcGIS and SqlServer.Types: Does feature.Shape.SpatialReference.FactoryCode == srid?
I created a test implementation of the ESRI Geometry to WKT recipe provided by @SagebrushGIS. It seems to work great, but I'm wondering if the SRID value expected by Microsoft.SqlServer.Types ...
5
votes
2answers
540 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
336 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
248 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 ...
5
votes
4answers
311 views
What is Spatial Reference System in Laymans Language?
I am trying to understand the concept behind the Spatial Reference System, Why is it used and what is so specific about the number. I went through many definations and almost all went over my head. So ...
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
772 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 ...
2
votes
3answers
275 views
which map projection should I use to calculate distance in Poland
I'm using/learning geodjango + postgis, and I'm trying to calculate distance between 2 cities in Poland. First using WGS84/4326 I define 2 points, and then after transforming this points into ...
1
vote
1answer
247 views
Inconsistent Spatialite Update Behavior; SRID not allowed?
I have two tables: crime and (police) stations. The latter has only 4 records with (name, lat, lng) fields. The former has over 500K records with two California Zone 2 (ft) coordinate columns named ...
4
votes
1answer
1k views
Transforming geometry coordinates from SRID 4326 to SRID 3011
In SQLServer geometry field, I want to change the coordinates of geometry from one spatial reference system to another spatial reference system (from SRID 4326 to SRID 3011) by using ST_Transform. But ...
0
votes
1answer
3k views
How I get SRID from Geometry field
what is the function for getting SRID from Geometry field. I have inserted a shapefile into SQLServer table with Geometry field defined. I know the projection of shapefile is Swreff99_1800 ...
0
votes
1answer
348 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 ...
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
159 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 ...
1
vote
2answers
878 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 ...
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 ...
8
votes
3answers
1k views
Looking for a pythonic way to calculate the length of a WKT linestring
I was quite unsatisfied with Calculating Length of Linestrings in WGS84 in Miles. It kept me wondering if there is a more convenient, Pythonic way to calculate the length of a WKT linestring according ...
