A Spatial Reference System Identifier (SRID) is a unique value used to unambiguously identify projected, unprojected, and local spatial coordinate system definitions
4
votes
2answers
116 views
ST_Distance is not delivering right results
I want to calculate the distance between lat/lon points.
I tried the following queries:
Select
ST_DISTANCE(ST_GeomFromText('POINT(-73.97923 40.75571)', 4326), ST_GeomFromText('POINT(-73.974509 ...
1
vote
1answer
63 views
Problem with writing the srsName into 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>
...
5
votes
3answers
162 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
36 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 ...
14
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 ...
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
118 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 ...
1
vote
3answers
136 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 : ...
1
vote
0answers
45 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 ...
3
votes
1answer
99 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 ...
0
votes
0answers
236 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
973 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
...
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 ...
3
votes
1answer
239 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
98 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
403 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
304 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
75 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
195 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> ...
3
votes
1answer
168 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):
...
1
vote
2answers
281 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 ...
2
votes
0answers
70 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?)
...
3
votes
0answers
107 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
610 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
357 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
263 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
333 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 ...
1
vote
1answer
266 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 ...
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
834 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
285 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 ...
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
360 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 ...
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 ...
1
vote
2answers
943 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 ...
1
vote
1answer
107 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 ...
