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
1 vote
1 answer
34 views

Can't import a shapefile with different SRID in a geometry column

PostgreSQL 13, PostGIS 3, QGIS 3.22 In a table, I had a geometry column geom with a SRID 2154. Now I have to store geometries with different SRIDs in geom. So I did : alter table activite.prescription ...
user avatar
  • 1,035
0 votes
1 answer
41 views

How to obtain the SRID of a GDB layer using ogr_layer_SRID with ogrinfo?

I would like to use ogrinfo.exe through a command line to query the SRID of a layer (e.g., polygon layer) inside an ESRI GDB. Similarly to SpatialReference.GetAuthorityCode() when using GDAL Python ...
user avatar
  • 53
0 votes
0 answers
78 views

PostGIS: ST_Transform error

I have a table (tbl1) containing POINT geometries in EPSG:27700 (British National Grid). SELECT id, ST_AsText(geom) as geom FROM tbl1; = id | geom ------+-------- 1 | POINT(363179.79 176400.12)...
user avatar
  • 1,365
0 votes
1 answer
29 views

PostGIS tables don't retain SRID [duplicate]

I have multiple tables in a PSQL/PostGIS database which are comprised of GPS locations of animals. The tables are uploaded into the database with latitude, longitude, and timestamp columns, and then I ...
user avatar
1 vote
1 answer
36 views

How to parse Esri geometry coordinates that look like relative values?

While doing GIS system integration I encountered a kind of response data that I have no experience with. The coordinates looked very strange, except for the first one, the rest were mostly [1, 1], [1, ...
user avatar
  • 13
6 votes
1 answer
73 views

Is an SRID unique?

I wonder why the Authority and the SRID are often both used together to refer to a CRS, like in EPSG:4326. Isn't the SRID unique? Wikipedia says it is a "unique value", but also that spatial ...
user avatar
2 votes
2 answers
93 views

Operation on mixed SRID geometries error

I have two tables flickr_edin and temmpat. temppat was created using: CREATE TABLE temppat (id serial, geom geometry); INSERT INTO temppat (geom) VALUES (ST_GeomFromText('POINT (326253.33 674110.63)'))...
user avatar
  • 75
1 vote
1 answer
204 views

PostGIS Column not found in geometry_columns table

I've just loaded a bunch of shapefiles into postgis using psql2shp (from the command line). All of the shapefiles appeared to have been inserted correctly and the table I created is populated. But the ...
user avatar
  • 157
3 votes
1 answer
63 views

pgrouting - pgr_nodeNetwork: Can NOT determine the srid of the geometry "osm_id" IN table

I have been following the guide in order to import PBF data into a PostGIS database: pgrouting - documentation. I have downloaded the Belgium PBF from Geofabrik and installed all extensions needed ...
user avatar
  • 225
5 votes
1 answer
148 views

Reprojecting in PostGIS not working as expected

I just reprojected with PostGIS tree layers using this function: select UpdateGeometrySRID('schema', 'table', 'geom', 3857) These tree layers are contiguous. The problem is, when I open it on QGIS to ...
user avatar
  • 281
2 votes
2 answers
251 views

How to reproject a table using PostGIS

To reproject a table into different CRS is a very common practice in geospatial analysis. However, I am still struggling to reproject my table in PostGIS, after reading loads of Q&A related to ...
user avatar
1 vote
1 answer
40 views

Mixed SRID's when using users Lat & Lon coordinates to perform KNN through PostGIS when building points to jsonp

I have managed to create a script that passes the users lat and lon to a postgres query that finds the nearest 5 pubs to a users location. However, on execution I realised no matter what lat and long ...
user avatar
  • 101
2 votes
3 answers
321 views

How to overlay layers with different SRID using QGIS and PostGIS? [closed]

I have a map of the Netherlands imported from a SHP-file into my PostGIS environment with SRID 4289 (Rijksdriehoek Amersfoort). When I connect using QGIS to the PostGIS database and add the layer with ...
user avatar
1 vote
1 answer
61 views

My geometry appears far away from the real

I'm kind of new on PostGIS. I have the coordinates (UTM) in a table, and I need to update the geometry field based on that coordinates. The SRID in the table is 32717. I tried this sentence UPDATE ...
user avatar
1 vote
1 answer
175 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 ...
user avatar
  • 13
0 votes
0 answers
30 views

Different results for GEOGRAPHY and ST_TRANSFORM query on geo_point field

I am finding properties that are within 20K distance using ST_DWithin. But when I try with ::GEOGRAPHY casting the result is different from ST_Transform. Note: SRID of geo_point field is 4326 Indexed ...
user avatar
1 vote
1 answer
198 views

How to create custom CRS with custom SRID in PostGIS?

In our app we are using several CRS - one of them is a custom one. I'd like to turn it into a proper CRS that PostGIS can fully support (e.g. administering valid transformations on it with something ...
user avatar
  • 287
3 votes
3 answers
486 views

Missing geometry type and SRID in PostGIS

I created a view with select a, st_union(geom) from table group by a srid: 25832, geometry type: Multipolygon The view has no SRID and the geometry type is "GEOMETRY". Now i want to ...
user avatar
  • 83
0 votes
1 answer
117 views

SRID not updating

I have created a point geometry using ST_GeomFromText function in PostGIS and simultaneous set the SRID to 3857. Alter table data.trips_42779 add column geom geometry; UPDATE data.trips_42779 SET ...
user avatar
  • 562
0 votes
0 answers
49 views

CRS definitions in QGIS

I have a drone software package that wants to output my data in CRS 32612. QGIS seems to load and view it fine but when I extract contours from a DEM at this projection it tries to write the ...
user avatar
4 votes
1 answer
95 views

Transformation on insertion into PostGIS

If I have a specific SRID set on a geometry column in PostGIS, say 4326; if I then insert geometry with a different SRID, say 4283, what SRID will be stored in the database, will PostGIS transform the ...
user avatar
1 vote
0 answers
79 views

Is a SRID an attribute of geometry or geometry column? [closed]

I'm not an expert. Yesterday I found out that SRID in PostGIS is property of the column - an actual constraint that is even stored in pg_constraints table and then retrieved through geometry_columns ...
user avatar
  • 287
4 votes
1 answer
161 views

Different results for same transformation on different PostgreSQL/Postgis installations

While migratring web services from one server to another, we noticed different transformation results for the same query. In our case, a Polygon is supplied in WKT with SRID=4326 and a query is sent ...
user avatar
  • 43
0 votes
2 answers
100 views

Is there any reason to use or know anything other than WGS 84 (SRID 4326) or Web Mercator (SRID 3857)? [closed]

I'm new to GIS and learning about SRIDs. Are there still other relevant or commonly used SRIDs?
user avatar
2 votes
2 answers
114 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 ...
user avatar
  • 1,604
0 votes
2 answers
208 views

Geometry in PostGIS Table wrong SRID and type [closed]

I have loaded some points into a table as Multipoint, they have come through with an SRID of 0. I need to change these to have a SRID of 7844 and also change them to be of type Point. There are other ...
user avatar
1 vote
1 answer
491 views

ST_Transform not working SRID

I have some MultiPolygon geometries in SRID 4258 and am trying to transform them into SRID 4326. When I run the following command, however, the output still seems to be in SRID 4258. Command: SELECT ...
user avatar
  • 11
3 votes
2 answers
1k views

What exacly ST_SetSRID in PostGIS does?

I am new to DBA and PostGIS. I am developing an application using PostgreSQL and PostGIS where nearby locations need to be queried. I created a sample table as below: CREATE TABLE foo (geog ...
user avatar
2 votes
1 answer
165 views

Extracting a Point from MuItipoint and use it for a ST_DWithin query

I have a MultiPoint geometry column which has only one point (DB is a live server which cannot be changed now). I need to find all points within a certain distance from a fixed point I provide to the ...
user avatar
5 votes
1 answer
819 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 ...
user avatar
  • 279
1 vote
1 answer
113 views

Should ST_OrientedEnvelope results differ depending on order of transform?

I have a PostgreSQL db with a table with geometry multipolygons stored in srid 4326 (lat/lngs). I need to calculate the area of the oriented envelope around each polygon, and I am using ...
user avatar
2 votes
1 answer
379 views

Trying to set SRID for a Geometry

I imported precinct data from the Harvard Dataverse into Postgres 9.3 using the PostGIS Shapefile Import/Export Manager. It creates a geom column with a SRID of 0. I think the data is projected as ...
user avatar
1 vote
0 answers
100 views

PostGIS add polygon in meters around a point (lat,long)

I have a point in my PostGIS database that is put in using the lat/long using srid: 4326. The point represents a car driving, now I want to add a polygon of the cars shape around this point and update....
user avatar
  • 11
1 vote
1 answer
320 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 ...
user avatar
  • 756
0 votes
0 answers
57 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....
user avatar
  • 1,604
0 votes
1 answer
142 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["...
user avatar
  • 2,084
2 votes
1 answer
121 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, ...
user avatar
  • 567
0 votes
2 answers
286 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'...
user avatar
  • 2,271
3 votes
1 answer
532 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 ...
user avatar
  • 272
9 votes
3 answers
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 ...
user avatar
  • 137
1 vote
1 answer
125 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 ...
user avatar
0 votes
1 answer
510 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 ...
user avatar
9 votes
1 answer
1k 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 ...
user avatar
  • 329
0 votes
1 answer
170 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 ...
user avatar
7 votes
2 answers
9k 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 ...
user avatar
  • 163
1 vote
2 answers
1k 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(...
user avatar
1 vote
2 answers
630 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. ...
user avatar
  • 616
0 votes
2 answers
641 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 ...
user avatar
  • 111
0 votes
0 answers
625 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." ...
user avatar
2 votes
0 answers
90 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 ...
user avatar

1
2 3 4 5