Stack Exchange Network

Stack Exchange network consists of 175 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

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

3
votes
1answer
28 views

Representing projected coordinates from several UTM zones into the same one

I have a database with coordinates in WGS84 (4326) that all of them belong to Italy. Italy is split in two more or less equal UTM zones, 32 and 33. I need to transform those geographic coordinates to ...
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 ...
1
vote
1answer
46 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
66 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 ...
7
votes
1answer
262 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
58 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
2answers
891 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
1answer
250 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
134 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
161 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
314 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
26 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
202 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
65 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
210 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
41 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
231 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
262 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
117 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["...
2
votes
1answer
143 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 ...
2
votes
2answers
181 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
187 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
30 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
283 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
195 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
124 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
734 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
171 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
238 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
76 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
116 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
703 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 ...
11
votes
1answer
182 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
329 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
648 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
765 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
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: ...
1
vote
1answer
63 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
419 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
807 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
44 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
286 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["...
4
votes
1answer
92 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
445 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
1k 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 ...
1
vote
1answer
601 views

Has the function srid(geometry) been removed or has the name changed?

I am in the process of restoring a database that relied on PostGIS version 1.5 functions to a newer Postgresql engine that leverages PostGIS 2.2 functions. In my restore process, I receive the ...
1
vote
1answer
260 views

Convert ETRS89 points to CARTO Lat Long

I'm new in Geographic Information Systems and programming. I have some points referencing Barcelona, Spain. These points are comming from City Hall's opendata site. They say they are in ETRS89 ...
1
vote
1answer
166 views

Length of reversed geometry in meters

I know that a similar question has been asked multiple times here (a great answer can be found here: How can I get the geometry length in meters?), but in contrast I want to get the length of the ...
2
votes
1answer
1k 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 ...