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
44
questions
22
votes
1
answer
6k
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 ...
- 461
41
votes
6
answers
24k
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 ...
- 22.9k
44
votes
4
answers
51k
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(
'{
...
- 1,154
25
votes
4
answers
28k
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 ...
- 788
15
votes
1
answer
8k
views
Is re-projection needed from SRID 4326 (WGS 84) to SRID 4269 (NAD 83)?
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 ...
10
votes
2
answers
4k
views
Creating 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: ...
- 4,380
24
votes
2
answers
51k
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 ...
- 341
15
votes
3
answers
33k
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. ...
- 785
7
votes
2
answers
1k
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 ...
17
votes
3
answers
55k
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:...
- 1,417
5
votes
1
answer
13k
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 ...
- 1,417
2
votes
1
answer
2k
views
1
vote
1
answer
1k
views
Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type
After import some data from OSM file into Postgre, the coordinates numbers are too big and having trouble to cast to Geography:
Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY ...
- 2,040
70
votes
1
answer
60k
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?
...
- 881
13
votes
3
answers
28k
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('...
- 387
12
votes
5
answers
6k
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 ...
- 6,770
11
votes
4
answers
5k
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 ...
- 839
11
votes
1
answer
263
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 ...
- 4,398
9
votes
2
answers
8k
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,763
9
votes
1
answer
4k
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"...
- 375
8
votes
1
answer
18k
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(...
- 825
8
votes
3
answers
12k
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 error ...
- 173
7
votes
2
answers
4k
views
Why does Find_SRID return zero?
using
SELECT Find_SRID('public', 'myTable', 'myColumn');
I get zero as the result, what does it mean?
- 1,259
6
votes
1
answer
2k
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 ...
- 161
5
votes
1
answer
1k
views
Getting geometry column integer SRID from a GeoPandas geodataframe?
The primary answer to Adding GeoPandas Dataframe to PostGIS table? requires entering the geodataframe geometry column's integer SRID.
Getting the CRS attribute using the crs attribute like so
import ...
- 279
5
votes
3
answers
5k
views
PostGis: Geometry from UTM text
I have plain data in a postgresql table which looks like this:
╔════╦═══════╦═════════════╦══════════════╦══════════╦═════════════════╗
║ id ║ index ║ easting ║ northing ║ utm_zone ║ ...
- 63
4
votes
4
answers
8k
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
...
- 153
4
votes
2
answers
1k
views
How to find good meter-based projection in PostGIS
I have a set of point geometries that I would like to cluster together using ST_ClusterDBSCAN. Unfortunately, it doesn't seem to work for WGS84 and requires a meter-based projection. Every tutorial ...
- 392
4
votes
2
answers
1k
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 ...
- 611
3
votes
1
answer
2k
views
How do I get the closest point on a road to a point when I have imported OSM data using osm2pgsql?
I have been trying to use OSM data to find the closest point to a road for a given point. I imported the OSM data into postgis using osm2pgsql, and I am getting results back, but they are at the ...
3
votes
1
answer
2k
views
Distance from point stored in geometry with SRID 4326
I have stored 2.5 million data points (addresses) using the geometry data type in column latlong with SRID 4326. The latlon - column has a GIST index defined. I would select all addresses within a ...
- 145
2
votes
0
answers
169
views
Create custom Non-North/Rotated SRID
Often in the hard rock mines that I consult for, they use a local grid coordinate system. The area is typically small <20km x 20km so curvature of the earth is not a major problem. Typically I ...
- 176
2
votes
2
answers
5k
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 ...
- 825
2
votes
2
answers
188
views
How to manage different SRID data in same database table? [closed]
My data is in two different cities and three different EPSG code area. (Database is PostgreSQL/PostGIS.)
So I think, I can not set SRID values by data. Making 3 different table is difficult. How can ...
- 1,654
2
votes
3
answers
4k
views
Finding units for specific spatial reference system?
I want to use the st_within function to find geometries within a specifi distance. My geometries are both in the same SRID stored in a postgis db.
From what I read here: http://postgis.net/docs/...
- 2,604
2
votes
1
answer
2k
views
Why does QGIS recognize the geometry type of some MSSQL tables and not others?
In QGIS, when I go to add a MSSQL table, it recognizes the geometry type and SRID of some tables and not others. When it doesn't recognize these I can set them manually and load the data without a ...
- 877
1
vote
1
answer
314
views
Google Maps satellite view footprints not congruent to street map view
I am trying to draw the layout of a building and project them to a web map using Django and Leaflet. I am using a satellite image to get the correct latitude and longitude and then I send the ...
- 13
1
vote
1
answer
496
views
Use SDE.ST_GEOMETRY functions in a custom function
I have a dummy query where I generate an SDE.ST_GEOMETRY point:
select
shape as srid_test
from
(
select
sde.st_geometry ('point (10.01 50.76)', 4326) as shape
from
...
- 1,054
1
vote
1
answer
484
views
cartodb: query for the points within a radio from another point - postgis
I've georreferenced a couple of points in a CartoDb table, so now I have a the_geom column of type point
I'd like to get all the points that are x meters away from a certain x,y point.
So far now, ...
- 275
1
vote
1
answer
795
views
Control number of segments in ST_Buffer for geographies?
I've been attempting to construct circles centered around a list of points in PostGIS with good success. I've opted to circumvent having to look up UTM zones and using optimal SRID by simple letting ...
- 55
1
vote
2
answers
2k
views
including SRID in WKBWriter in Shapely doesn't work
I want to encode coordinates of LineString in WKB with the SRID included
wkbwriter = shapely.geos.WKBWriter(shapely.geos.lgeos, big_endian=False, include_srid=True)
geo = wkbwriter.write_hex(...
- 131
1
vote
1
answer
264
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 ...
- 426
0
votes
2
answers
66
views
Geoserver returns error when using CQL_FILTER=INTERSECTS(...) "ST_Intersects: Operation on mixed SRID geometries (Point, 3857) != (Polygon, 0)"
When I try to send request to geoserver with BBOX:
request=GetFeature
srsname=EPSG:3857
CQL_FILTER=BBOX(geom,5147051.465935892,7328515.141536634,5147051.465935892,7328515.141536634)
everething is ...
0
votes
1
answer
956
views
Oracle equivalent to postgis EPSG 4326 "geometry" type
We have polygons stored in Oracle SRID 8307 (geodetic datatype), but need to perform various operations on this layer in a 2d cartesian/non-geodetic system based on the geographic coordinates.
I.e. ...
- 3