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
0
votes
0answers
23 views

ArcGIS feature table SRID is NULL

I am using Oracle to store ArcGIS data. I have created my table named PARCELS from ArcCatalog, and I inserted some data using ArcMap. So when I run the following SQL query: select * from MDSYS....
0
votes
1answer
25 views

Translate custom MKT projection to proj4 string?

I need to use a specific custom projection that not exist as SRID into standard spatial_ref_sys of my GIS, PROJCS["Conica_Equivalente_de_Albers_Brasil", GEOGCS["GCS_SIRGAS2000", DATUM["...
0
votes
1answer
52 views

Defining distance between points in meters

I want to calculate the distance in meters between two points but I am getting an obscene result 5497980.47338251 Here is the query I made: SELECT ST_Distance(ST_SeTSRID(ST_MakePoint(6761331.47, ...
0
votes
2answers
66 views

Geographic coordinates in PostGIS to QGIS and shapefile layers

I've got in PostgreSQL/PostGIS the table "points" with latitude and longitude fields. I've done update points set geom = st_point (longitude, latitude); and also select updategeometrysrid ('points'...
3
votes
1answer
44 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
61 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
124 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 ...
8
votes
1answer
392 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
78 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
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 ...
0
votes
1answer
385 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
188 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
249 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
404 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
27 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
299 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
81 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
262 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
46 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
305 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
342 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
123 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
191 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 ...
3
votes
2answers
267 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
228 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
35 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
354 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
225 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
136 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
917 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
192 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
317 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
90 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
161 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
862 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
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 ...
3
votes
1answer
377 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
2k 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
779 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
944 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 ...
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: ...
1
vote
1answer
72 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
510 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
1k 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
48 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
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["...
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 ...
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 ...
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 ...