The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [srid]

A Spatial Reference System Identifier (SRID) is a unique value used to unambiguously identify projected, unprojected, and local spatial coordinate system definitions

Filter by
Sorted by
Tagged with
53
votes
1answer
39k views

Choosing SRID and what is its meaning? [closed]

I'm new to GIS, in PostGIS, and I'm struggling with the SRID concept. How do you choose a SRID for a database column? This is making me crazy. Why do I need to choose a SRID? What's its meaning? ...
38
votes
6answers
20k 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 ...
32
votes
4answers
30k 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( '{ ...
19
votes
4answers
16k views

Is it possible to reproject spatial data using SQL Server?

SQL Server takes an SRID when creating spatial data, but is it possible to retrieve with a different SRID translating the coordinates? For example, let's say I have a bunch of spatial polygons using ...
17
votes
2answers
25k views

PostGIS Geometry Query returns “Error: Operation on mixed SRID geometries” only for certain values

I have PostGIS table with two geometry columns, both defined with SRID 4326. I can insert into the table without problem, using the following INSERT statement (where lng and lat are values passed in ...
16
votes
1answer
4k views

Using customized Coordinate System in ArcGIS Desktop?

I don't know so much about coordinate systems... In my office we use to deal with spatial data coming from archaeological sites. Each site has its own x-y-z coordinate system (GCS). Three simple ...
15
votes
3answers
39k views

How I get SRID from Geometry field

What is the function for getting SRID from Geometry field. I have inserted a shapefile into SQL Server table with a Geometry field defined. I know the projection of shapefile is Swreff99_1800 (EPSG:...
13
votes
4answers
4k 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 ...
11
votes
1answer
183 views

Calling ST_Transform in geometry that is already in target srid?

I'm writing a function that has a geometry as a parameter that can be in different projections: CREATE OR REPLACE FUNCTION foo(in geometry) RETURNS boolean AS $$ DECLARE transformed_geom geometry ...
10
votes
3answers
17k views

Adding additional geometry column in PostGIS?

I'm importing many sets of geodata into PostGIS, and they have different SRID's. (Some have EPSG:3857, some EPSG:4326, some something else). I'd like to create an additional geometry column, eg. ...
9
votes
3answers
2k views

SRID and Name relationship

PostGIS comes with a table of spatial reference systems with each one being identitfied by a SRID. However, from a user's perspective, SRID is just a number and doesn't tell them much. Is there a ...
9
votes
4answers
4k views

Understanding concept of Spatial Reference System?

I am trying to understand the concept behind the Spatial Reference System. Why is it used and what is so specific about the SRID number? I went through many definitions and almost all went over my ...
9
votes
2answers
7k views

What is the SRID of census.gov shapefiles?

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 ...
9
votes
1answer
5k views

Is re-projection needed from SRID 4326 (WGS 84) to 4269 (NAD 83)SRID

I have US census data against state boundaries stored as SRID 4269, in an MSSQL DB. The input data used for calculations against that dataset is stored as SRID 4326. As far as I can infer from the ...
9
votes
3answers
13k views

Problem with Geometry SRID in PostGIS

I ceated my table (borne) in PostGIS id_borne serial NOT NULL, num_borne character varying, shape_borne geometry I successfully changed the SRID of my table using select UpdateGeometrySRID('...
8
votes
1answer
397 views

Using shp2pgsql instead of ogr2ogr to import shapefile to PostGIS? [closed]

I may very well be doing something wrong here, but: If I import some shapefile to a PostGIS database using shp2pgsql, I have to first figure out the SRID/EPSG of that shapefile. I think this is, at ...
8
votes
1answer
3k 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 1980"...
8
votes
2answers
981 views

Storing SRID:4326 data as Geometry or Geography?

I used OGR2OGR to import SRID 4326 point data into MSSQL Server. Didn't realize that it defaults to creating a geometry column instead of detecting the data as 4326 and creating a geography column. ...
7
votes
2answers
6k 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
3k 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 http://thematicmapping.org/downloads/...
7
votes
1answer
270 views

Why is there an upper limit to the SRID value in the spatial_ref_sys table in PostGIS 2.1?

I was trying to insert a reference system in PostGIS from http://spatialreference.org/, and got a constraint violation for spatial_ref_sys_srid_check. I checked that constraint and found that, when ...
7
votes
2answers
979 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 ...
6
votes
2answers
1k views

What is the SRID for EPSG 102743?

I am trying to create a table in PostGIS for some LiDAR data and I need to set the the_geom column to my data's SRID. My data is in EPSG 102743, but when I try to use 102743 as my SRID as the_geom I ...
6
votes
2answers
234 views

Postgis 2.1 Inconsistent with spatialreference.org

The County of Napa, California, uses a projection "NAD_1983_StatePlane_California_II_FIPS_0402_Feet"; for example their roads.prj file has: PROJCS["NAD_1983_StatePlane_California_II_FIPS_0402_Feet",...
6
votes
1answer
1k views

PostGIS spatial reference ID (SRID) for regular cartesian coordinate system?

I would like to store a polygon as a set of 2D points represented as x, y coordinates of a Cartesian coordinate system. Which spatial reference can I use? Looking at my spatial_ref_sys table, all the ...
6
votes
1answer
2k 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 ...
6
votes
1answer
1k views

How do I change an existing srs in QGis?

I am showing postgis data with srid 28992 (Amersfoort / RD New). But when I plot the geospatial data on a map (with openlayers plugin), the data is shown a hunderd meters off because the datum shift ...
6
votes
1answer
168 views

Is there a way to determine the datum used when all you have is a lon and lat?

I have a dataset of US intersections from 2011 that I'm going to be using in a project together with data based in WGS84. Included in the CSV file is a variety of fields two of which are the lat and ...
5
votes
3answers
461 views

What SRID is this?

I have been sent the following coordinates, they belong to Switzerland: 641.621 189.131 I need to convert those to EPGS:4326, but I don't know what the source SRID is. Does someone recognise the ...
5
votes
2answers
2k views

Create custom coordinate system in postgis

I have a Wayne county Michigan parcel dataset with a custom SRID: when I bring it into ArcGIS Projected Coordinate System: NAD_1983_HARN_StatePlane_Michigan_South_FIPS_2113_Feet_Intl Projection: ...
5
votes
1answer
13k 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 y(...
5
votes
1answer
781 views

Where do SRID numbers come from?

We know what SRID 4326 means and what 3857 means but I do not know what these numbers mean. What is the minimum and maximum number for these SRIDs? I know it is a standard but how did they select ...
5
votes
2answers
307 views

What is the SRID for this .prj file?

PROJCS["3900_SC_Nad_83",GEOGCS ["GCS_North_American_1983",DATUM ["D_North_American_1983",SPHEROID ["GRS_1980",6378137,298.257222101]], PRIMEM["Greenwich",0.0],UNIT["...
5
votes
3answers
843 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 ...
5
votes
1answer
11k views

Transforming geometry coordinates from SRID 4326 to SRID 3011 [duplicate]

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 ...
5
votes
1answer
880 views

How can I get proj4text from srtext?

I have a custom projection used in some shapes on a prj file. I want to insert this projection in the table spatial_ref_sys PostGIS. The data in the prj file will SRTEXT table field, how can I get ...
5
votes
3answers
454 views

Different values while calculating distance

I'm developing a project using LeafleatJS and PostGIS. Currently I'm getting trouble while calculating distance between two coordinates. For example: Point 1 - lat: -12.99835864475412, lng: -38....
5
votes
3answers
3k views

PostGis: Geometry from UTM text

I have plain data in a postgresql table which looks like this: ╔════╦═══════╦═════════════╦══════════════╦══════════╦═════════════════╗ ║ id ║ index ║ easting ║ northing ║ utm_zone ║ ...
5
votes
2answers
2k 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 40....
5
votes
1answer
2k views

Is it possible to get coordinate system name from SQL Server geometry type?

I need to get the name of the coordinate system of a geometry type field in SQL Server 2008 R2 (for example NAD_1983_UTM_Zone_14N or GCS_WGS_1984 or other). Is this possible?
4
votes
2answers
951 views

ESRI projection to SRID?

I am looking at MapX and MapY coordinates. The docs say they are "truncated State Plane coordinates: NAD 1983 State Plane Louisiana South FIPS 1702 (US Feet)." I am trying to reproject into a common ...
4
votes
4answers
6k views

Performing SQL Server Geometry to geography conversion?

I have imported a number of Shapefiles 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 ...
4
votes
1answer
96 views

Problems with SRID 32717

I'm new with GIS systems and I need to determine if a point is into a polygon, I'm using a shapefile with SRID 32717 and I have a list of points (long, lat). With QGIS I export the shapefile to a ...
4
votes
2answers
583 views

Is there a command line tool for converting projection in .prj and GeoTiff to EPSG codes?

Is there a command line tool to convert a shapefile projection in the .prj file into corresponding EPSG code? I know that there is website http://prj2epsg.org/search for doing this online, but I ...
4
votes
1answer
125 views

Find projected coordinate system

I have lots of (multi)polygons generated with this tool: http://gis.ucla.edu/apps/click2shp/ It provides a zip with dbf, shp, shx, prj files. The prj file contains the following: GEOGCS["...
4
votes
1answer
609 views

Updating SRID (Update_GeometrySRID) does not alter polygons (when it should)

I am trying to change the SRID of polygons layer, but I'm having trouble visualizing the result. I the SRID is misreported the shapefile I used to import into PostGIS. The metadata says the ...
4
votes
0answers
149 views

Adding data from PostgreSQL to Query Layer of ArcGIS for Desktop warns that given coordinate references are incompatible? [closed]

When adding data from PostgreSQL in a Query Layer I get the warning: The given coordinate references are incompatible I have added many other layers with the same properties no problems, but I ...
3
votes
2answers
3k views

Ensuring SRID on geometry column in PostGIS

I am using a table that has a geometry type column called "wkt". Its definition in the table looks like this: create table sometable ( ... wkt geometry not null, ... ); I want to change it ...
3
votes
2answers
2k views

Is SRID 4326 Lon/Lat or Lat/Lon?

I built a wep app storing GPS coordinates, as SRID 4326. Coordinates are stored as Lon/Lat, and that was working fine on MySQL 5.6 and MySQL 5.7. Since I upgraded to MySQL 8, I get the following ...
3
votes
1answer
7k views

PostGIS - Geometry or Geography find points within distance in meters

I have a requirement where I need to store lat/long coordinates for locations all around the world. I then need to query for those locations that are within a specified distance (in meters) from ...