Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Make your voice heard. Take the 2019 Developer Survey now

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

1
vote
1answer
40 views

PostGIS: Problem with SRID conversion

I am new in PostGIS and I am trying to convert a geometry field to GeoJSON Lat/Lng for visualization in a map as a layer. I had a .HSP file that I exported to PostGIS with OpenJump program. The .prj ...
0
votes
1answer
28 views

With Spatialite, how do I run PtDistWithin with meters?

So the problem is that I have a set of multipolygons and points and I need to be able to query the data with a given point to check which ones are within 'x' km. Initially my SRID was 4283 but I ...
0
votes
0answers
29 views

Converting x, y, srid to latitude / longitude

I have positions in JSON as x, y and srid ({"x":740370,"y":1045712,"srid":5514}). What would be the way to convert them to simple Latitude / Longitude ones (srid is different on other positions)? (...
7
votes
1answer
128 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 ...
0
votes
1answer
39 views

Setting coordinate system in CARTO Builder map?

I uploaded a polygon layer in EPSG 25830, called 'parcels'. I know that the geometries are reprojected and the dataset has two geometry columns: 'the_geom' in EPSG 4326 'the_geom_webmercator' in ...
3
votes
1answer
467 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 ...
0
votes
0answers
135 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(...
1
vote
1answer
69 views

Different SRID shown in QGIS and PostGIS for the same data

I have data stored in PostGIS. When I view its properties in QGIS, it says: SRS: EPSG:4326 - WGS 84 However, when I want retrieve the SRID value directly using the Find_SRID function, it returns 0. ...
0
votes
2answers
106 views

Wrong Calculated distance in PostGIS

I have downloaded Malaysia map from opensteetmap website and I have started to work on it in PostGIS. I need to find out the distance of some points to the nearest street over the map, so I used this ...
0
votes
0answers
230 views

SQL Server - ESPG:4326 data stored in Geometry column

It seems that the Microsoft SQL Server Geography data type is better suited for lat/lon because Geography "stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates." ...
1
vote
0answers
21 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 ...
1
vote
1answer
121 views

How to convert a SRID/SRS in PostGIS into Well Known Text (WKT)?

Is there a PostGIS function for obtaining the WKT of an SRID in PostGIS? By WKT, I mean the ones that can be uploaded to spatialreference.org. I'm trying to create a new SRID/SRS by tweaking ...
3
votes
0answers
46 views

create custom SRID from OGCWKT

I wanted to create a new SRID for use in PostGIS. My goal is to have a SRS that can cover an entire state (instead of have multiple zones as in SPCS). For example, I wanted to create a new SRS for ...
0
votes
1answer
145 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. ...
0
votes
1answer
36 views

Deciding whether to cast or Project when meters needed for ST_Distance?

I have a database and I am using geoms to build polygons around points. I need to do st_distance, st_area, st_overlaps, st_union, and st_instersects. also using st_x and st_y and st_project, so ...
2
votes
2answers
149 views

Reproject SRID using DotSpatial

I'm nota GIS guy so I need some help. I need to reproject from one SRID to another. I'm trying to take global lat/longs (4326), reproject them to a local SRID (2336). This is basically the line of ...
0
votes
2answers
172 views

query to check srid of features in feature class? [duplicate]

What query should I use to check the SRID of the features in a feature class? The storage type of the feature class in st_geometry? I tried the following query but no luck : select top 1 [...
4
votes
1answer
99 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["...
0
votes
0answers
28 views

Missing field in gdalsrsinfo report

I am trying to use gdalsrsinfo first time to extract ESPG id. cmd line is gdalsrsinfo -o wkt file.shp This prints PROJCS["South African Coordinate System zone 29", GEOGCS["Cape", DATUM[...
2
votes
1answer
107 views

How can I add custom projections to the default spatial_ref_sys table in PostGIS?

The data I work with requires me to project between WGS84 (4326) and OSGB (27700), the default projection in PostGIS is using the older less accurate version of the projection. I am trying to add ...
0
votes
0answers
60 views

problem with django GDALRaster to load ascii grid rasters

I'm trying to load a raster file in format ascii grid to postgresql using postgis. My model: class elevation(models.Model): rast = models.RasterField(srid=3857) filename = models.CharField(...
2
votes
2answers
131 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 ...
1
vote
1answer
149 views

How to convert point coordinates to point geometry in a different spatial reference coordinate system?

I have point coordinates returned with wkid 3857 and need to convert to 4326 to get point geometry using PostGIS. I know I can return geometry of the same type using the following: ST_SetSRID(...
2
votes
0answers
24 views

Defining grid for Mapcache for data stored in SRID 3912? [closed]

How do I define the grid for Mapcache when the data is stored in SRID 3912? <grid name="SLOGRID"> <size>256 256</size> <extent>413919,90129,694326,133000</extent> -- ...
0
votes
1answer
217 views

SRID for basic X,Y coordinate system?

I would like to build a web-based application using leaflet which will have a flat plane and a simple X,Y coordinate system. Is there an SRID I can use for this? I will be generating my own basemaps ...
3
votes
1answer
166 views

SRID for New York City 2010 Census Shapefile

I pulled the New York City census tract PostGIS from Todd Schneider's work, but I am struggling to find the correct SRID. PROJCS["NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet",GEOGCS["...
2
votes
1answer
109 views

Postgres/PostGIS spatial join returning null results

I have 1.3 million points and 15 thousand polygons. I'm trying to do a spatial join so I can find out how many points intersect with each polygon. Ultimately, I'll add up the values in some columns ...
1
vote
1answer
574 views

PostGIS query “Error: Operation on mixed SRID geometries” only for certain tables

I have imported various shape files, all obtained from the geofabriks website, into QGIS using the 'PostGIS Shapefile Import/Export Manager'. A couple of them are throwing the error “Error: Operation ...
1
vote
1answer
134 views

Query Geoserver using lat/long with UTM store [closed]

I have been using a Geoserver for years with my developers querying it using lat/long to get US parcel boundaries from a SQL Server store. I got a dataset with UK parcel boundaries but it's in EPSG:...
0
votes
1answer
158 views

SRID issue on insertion

I have a table with a point geometry defined as "geom geometry(Point,28355)" I am trying to insert data using the following: INSERT INTO tmpwatscint ( scgid, pipeid, geom ) SELECT s.gid, p....
-1
votes
1answer
65 views

What is the expected SRID value during importing shapefile with TDGeoImport tool (Teradata Database)? [closed]

I can successfully upload my SHP file into Teradata database using the TDGeoImport tool. The aim is to publish the geospatial table in Teradata to GeoServer as (web) map services. I'm curious as to ...
1
vote
0answers
92 views

What is the expected SRID value in Teradata ST_Geometry Methods?

In Teradata database there's SPATIAL_REF_SYS table in SYSSPATIAL schema. In my Teradata production database the table lists 3,167 different Spatial Reference Systems (SRSs). Now, it seems that ...
1
vote
1answer
587 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 ...
0
votes
0answers
134 views

Django GEOS: SRID 4326 vs SRID 32118 to calculate area

I believe that SRID:4326;geography=True is used for representing actual geography (cities, locality, etc.) but when I do polygon.area, I'm getting area of a geometry object. To find out the area in ...
0
votes
0answers
147 views

PostGIS ST_Contains return wrong result

I uploaded a csv with lat and lng columns to a postgis database and created a geom column from those, and uploaded a shapefile as well. I ran an ST_Contains to see what geography each point was in ...
11
votes
1answer
174 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 ...
3
votes
1answer
296 views

Converting 32639 spatial reference to 3857 in PostGIS

I have a polygon layer which is in UTM 39N as x and y coordinates. I need to convert it to EPSG:3857 and for this I used ST_Transform. select st_transform(geom,3857) from block_1 But when I get ...
1
vote
2answers
1k views

Get different SRIDs of geometry column in a table

It is possible that a geometry column in a table of PostGIS has different SRIDs. I've used Find_SRID to get the SRID of this column but seems it only returns one value for SRID which is the first row. ...
5
votes
1answer
560 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 ...
1
vote
1answer
604 views

How to Select an SRID? And how is it different from the SRID passed into ST_Transform?

Say I wanted to find geometries that intersect a circle at lat/long as outlined here How to Select all polygons or lines that lie at least partially within a circle with a radius?. SELECT * FROM ...
3
votes
2answers
1k 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: ...
1
vote
1answer
52 views

FInding the SRID for NAD_1927_UTM_Zone_7N? [duplicate]

How do I find the SRID for this shapefile? (output from ogrinfo -so) Geometry: Polygon Feature Count: 3 Extent: (-76840.712074, 7832057.693703) - (123912.271665, 7979730.291856) Layer SRS WKT: PROJCS[...
2
votes
1answer
335 views

howto set ogr2ogr imported SRID to 0? Currently defaulting to SRID 1

I'm currently trying to import a bunch of boundaries into a legacy system with a specific SRID. its a mySQL db. After import and running some intersect code, i receive this error: Binary geometry ...
1
vote
1answer
529 views

Updating the Entry in geometry_columns for Spatial Table Created from a Query

I created a spatial table from a query. Now, I notice in geometry_columns, the following entry for the table: f_table_catalog | f_table_schema | f_table_name | f_geometry_column | ...
2
votes
0answers
42 views

ST_Transform Displaced Locations

Ive updated my spatial_ref_sys table in postgres with spatial reference statement from http://spatialreference.org/ref/esri/102737/. I can perform the tranformation from srid 4326 to srid 102737 and ...
5
votes
2answers
263 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["...
0
votes
0answers
126 views

Setting SRID using SQL code in Spatialite in QGIS using QSpatiaLite Plugin?

I'm trying to figure out how to set the Spatial Reference (SRID) for shapefiles I put into a SpatiaLite database in QGIS. I went to the QspatiaLite plugin and clicked on the "show metadata" tab for ...
4
votes
1answer
89 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 ...
5
votes
3answers
427 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 ...
1
vote
1answer
917 views

Postgis - Spatial relationships in metres

I'm trying to perform some spatial relationship analysis using Postgis functions like st_dwithin and st_dfullywithin. I searched and found that for any SRID, using the geography type gives the results ...