Stack Overflow
Stack Overflow

Questions tagged [srid]

A Spatial Reference System Identifier (SRID) is a 4-5 digit number used to unambiguously identify any Coordinate Reference System (CRS) definition while also pointing at sets of up to 20 parameters describing each CRS. Being part of the Simple Features standard of the Open Geospatial Consortium (OGC) SRIDs are used in most Geographic Information Systems. Use this tag for questions concerning the projection or transformation of geospatial data to a CRS.

45 questions
39
votes
6 answers

How do you know what SRID to use for a shp file?

I am trying to put a SHP file into my PostGIS database, the the data is just a little off. I think this is because I am using the wrong SRID. The contents of the PRJ file are as…
priestc
  • 33,060
  • 24
  • 83
  • 117
21
votes
5 answers

ST_DWithin takes parameter as degree , not meters , why?

The ST_DWithin document says , the third parameter(distance) is in meters. But when I execute some query , it seems it takes the 3rd parameter as 'degree' ? Here is my simplified table structure : > \d+ theuser; Table…
smallufo
  • 11,516
  • 20
  • 73
  • 111
10
votes
2 answers

PostGis Distance Calculation

I am doing a indoor map navigation application right now and what I am trying to do is to build a database of map point in the building. All of the coordinate I use is taken from Google Map (which means the EPSG is 3857). What I need to do now is to…
Thomas Dang
  • 201
  • 3
  • 4
  • 14
9
votes
1 answer

How to create a circle in meters in postgis?

I would like to ask how to create a circle with radius=4km. I have tried the ST_Buffer function but it creates a larger circle. (I see the created circle by inserting its polygon into an new kml file.) This is what i am trying. INSERT INTO…
Mike Vasi
  • 467
  • 2
  • 5
  • 16
5
votes
0 answers

EF error with DbGeography and SRID 104001

Database table: ,[Location] GEOGRAPHY Update Location with EF using SRID 104001 item.Location = System.Data.Entity.Spatial.DbGeography.PointFromText($"Point({loc.Lng} {loc.Lat})", 104001); Exception: 24204: The spatial reference identifier (SRID)…
D. Traykov
  • 51
  • 3
3
votes
1 answer

ARCGIS tiles to coordinates

I'm trying to develop my own map service then display my generated images into ARCGIS map viewer ... Anyway my *.ashx service reads ARCGIS Tile URL looks like…
Gerard
  • 65
  • 1
  • 6
3
votes
0 answers

How I can transform GEOGRAPHY exemplar from one coordinate system to another in MS SQL Server?

How I can transform GEOGRAPHY exemplar from one coordinate system to another in MS SQL Server? For example, I have: DECLARE @g geography; SET @g = geography::STGeomFromText('POINT(3 3)', 4326) How I can transform this GEOGRAPHY to coordinate system…
Walentyna Juszkiewicz
  • 187
  • 3
  • 21
3
votes
1 answer

How to transform from SRID 4258 to 4326 in PostGIs

I have a column with polygons with the SRID 4258, I have been trying to transform that column to SRID 4326 but does not transform it correctly. I have done using this two commands: SELECT UpdateGeometrySRID('lig','geom',4326); UPDATE lig SET…
AritzBi
  • 197
  • 3
  • 10
3
votes
5 answers

MySQL Spatial - Convert from SRID 31287 to 4326

In MySQL I have a a database with around 100 tables. They all contain a column called ´shape´, this is a polygon type field. It contains information in what I believe (st_srid returns 1, but it's wrong) is SRID 31287. I would like to convert it to…
alexisdevarennes
  • 5,437
  • 4
  • 24
  • 38
3
votes
2 answers

Which SRID does Apple Maps use?

The app will send the latitude and longitude to the server. It looks like it is probably NAD83 or WGS84 and I'm confused by some of the stuff I've been reading.
Glenn Wark
  • 1,499
  • 4
  • 19
  • 23
2
votes
2 answers

Can someone tell me why this keeps returning degrees instead of meters?

Can someone tell me why this keeps returning degrees instead of meters? I’m transforming the geometry SRID to 32613, which measures in meters. Thanks SELECT storm_date, hail_size_inches, ST_Distance( ST_Transform(geom32613, 32613),…
Nick Michniok
  • 21
  • 3
2
votes
2 answers

How is postgis treating coordinates sent with different SRID

I am running a django application and I am using the PostGis extension for my db. I am trying to understand better what happens under the hood when I send coordinates, especially because I am working with different coordinate systems which translate…
Micromegas
  • 1,499
  • 2
  • 20
  • 49
2
votes
1 answer

Manage multiple SRID on a single PostGIS table

I'm developing a web-GIS based on PostGIS. When I create a GIS-enalbled table on PostGIS I've to specify the SRID of the data, for example an UTM Zone (eg. UTM 33N SRID 32633). Is there a way to keep the project scalable and put in the same table…
feamarth
  • 23
  • 4
2
votes
1 answer

How to sort for non-geographical (X, Y, Z) distances using GeoDjango / PostGIS?

I'm currently using GeoDjango in a "Star searching and sorting" database that provides information about and will simulate information on star and planetary systems. I'm using GeoDjango 1) because I like it and use it elsewhere, and 2) because I…
JayCrossler
  • 2,079
  • 2
  • 22
  • 22
2
votes
1 answer

geodjango admin : An error occurred when transforming the geometry to the SRID of the geometry

When adding geometry in my database via the admin form I get this error: "An error occurred when transforming the geometry to the SRID of the geometry" Proj4 and geos lib are installed and I'm using postgres/postgis database. My geom field is in…
HydrUra
  • 1,336
  • 2
  • 13
  • 23
1
2 3