Skip to main content

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
0 answers
21 views

Is SRID not preserved in MySQL export/imports?

I have a database with spatial data stored as Polygons that I run queries such as ST_Intersects against. However if I export this database and import it the SRID appears to be lost, queries that ...
Mikael's user avatar
  • 1
0 votes
0 answers
31 views

How to get SRID from .prj file in PHP using OGR2OGR in PHP

I'm writing a PHP script that uses the OGR2OGR command to open a .prj file and get its SRID. I'm using the following code: $prjPath=Storage::path(filename); $output = shell_exec("ogrinfo -al -so $...
Maryam Atabati's user avatar
0 votes
0 answers
44 views

DB2 will only accept SRID's: 0, 1 and 4326?

I'm sure I'm doing something wrong here or just not understanding how this works but I cannot get DB2 to accept any coordinates that aren't either in SRID's 0, 1 or 4326. I'm trying to add data to a ...
Yndigo Dream's user avatar
2 votes
2 answers
480 views

If my geometry is stored in 4326 / WGS 1984 what should I transform to for the most accurate area in sq m?

I've got a plot of land in Texas that is (WKT): MULTIPOLYGON (((-98.12317899283 26.29444331481, -98.12355263136 26.29220720658, -98.1274736313 26.29279476234, -98.12691816383 26.29544258344, -98....
jcollum's user avatar
  • 153
0 votes
0 answers
50 views

How do you use negative coordinates with SRID 0 and DB2 Spatial?

I'm trying to store pure Geometry values in DB2 on a flat plane, no spatial reference or projection, apologies on the nomenclature as I might be a little off, basically planar cartesian coordinates. ...
Yndigo Dream's user avatar
1 vote
1 answer
174 views

SQL Error [22023]: ERROR: Geometry has Z dimension but column does not when updating SRID of PolygonZ column in PostGIS

I am trying to update the SRID of a PolygonZ column using: select UpdateGeometrySRID('public', 'bfp_clusters', 'convex_hull', 4326) ; I get the following error: SQL Error [22023]: ERROR: Geometry has ...
analyst92's user avatar
  • 857
2 votes
0 answers
158 views

ST_Transform returning different results in PostGIS 2.4 and PostGIS 3.0

I am facing a problem with the function st_transform()and here is my analysis of this pb: Example of SQL query with different results depending on PostGIS version: select st_astext(st_transform(...
moobster's user avatar
0 votes
1 answer
89 views

Unable to edit SRID in PostgreSQL pgAdmin

I am a new user to storing things GIS in PostgreSQL. My experience comes wholly from the QGIS training manual for 3.28.3 and some limited experience with QGIS. I added the PostGIS extension to my ...
Carl Huxohl's user avatar
1 vote
2 answers
246 views

How to extract information from a shapefile with the command ogrinfo in a machine readable way

I am looking for information like the SRID/CRS for a shapefile in an automated way. I know that by using ogrinfo path/to/xxx-filename.shp yyy-layer -so I can see some output with indentation left to ...
TPPZ's user avatar
  • 427
2 votes
1 answer
302 views

Changes to spatial_ref_sys tables do not take affect

I made changes to the spatial_ref_sys table in my PostGIS database but using ST_SetSRID and ST_Transform doesn't seem to be affected by the changes. For instance, I changed the proj4text because it ...
רוני אבזוב's user avatar
1 vote
1 answer
49 views

PostGIS concatenating tables with different SRIDs side-effects for area

I am quite new to Postgres/PostGIS and have an open question regarding 'mixing' tables with different SRIDs. I know this is generally not recommended, but in my case, I will already be required to ...
Bullfrog3655's user avatar
1 vote
0 answers
148 views

MariaDB set geometry field SRID SQL error

I'm trying to update a geometry field and set its SRID using the following statement which works fine in MySQL 8 but throws the following error in mariadb 10.3.37: sql error 1064 check the manual that ...
adam78's user avatar
  • 111
0 votes
0 answers
245 views

How to set SRID of the geometry attribute of GeoServer layer (automatically or through code), instead of -1 default value

Because of my problem with spatial queries (INTERSECTS) not working properly on a layer with SRID = -1 created with ogr2ogr - I need to force SRID of the geometry attribute of the layer to be ...
Eugene Kuklin's user avatar
0 votes
2 answers
681 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 ...
Eugene Kuklin's user avatar
1 vote
1 answer
587 views

Set SRID for mixed geometry type in PostGIS

I have a geometry column with mixed geometries like polygon, multi polygon. I am trying to set SRID for it using below query but I get the below error. What type of geometry has to be given when we ...
data en's user avatar
  • 145
1 vote
1 answer
172 views

ogr2org SHP file to SQLSserver Failed to process SRS definition

I am having issues importing a SHP file into SQLServer. The SHP file is EPSG 28354 (drawn in QGIS 3.x) and has these assoc files: REE_ProjectAreas.cpg REE_ProjectAreas.dbf REE_ProjectAreas.prj ...
LukeB's user avatar
  • 11
0 votes
0 answers
222 views

How do I UpdateGeometrySRID on table with mixed geometry sub types and mixed 2d/3d?

I have a table where where SRID of my geometry is set to 0 I am trying to update the SRID using SELECT UpdateGeometrySRID('location','geom',4326) The equivalent DDL statement would be ALTER TABLE ...
Xander's user avatar
  • 1
1 vote
0 answers
124 views

How do I get the distance between two points in meters with different SRIDs in PostGIS? [closed]

I purchased an address-point database (string, geom with SRID 2914) from my local county GIS provider, and I am trying to find the distance between a point in this database and a point with SRID 4326. ...
Cole Tritch's user avatar
1 vote
1 answer
964 views

Finding SRIDs of UTM quadrants or define other quadrants that are not at Equator

Trying to find the SRID of each official-updated ("SIRGAS 2000" or WGS84) UTM quadrant of Brazil. I am supposing that Latitude bands can use precise local projections, so on different SRID ...
Peter Krauss's user avatar
  • 2,304
1 vote
0 answers
142 views

Error changing geometry in oracle table by qgis

I'm having a problem changing or adding geometry in QGIS. My database is Oracle. I change my geometry in QGIS and when I go to save it, I get this message: SQL: ORA-29877: failed in the execution of ...
Nanda Toller's user avatar
1 vote
1 answer
163 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 ...
Leehan's user avatar
  • 1,234
0 votes
1 answer
332 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 ...
PhilpM's user avatar
  • 53
1 vote
0 answers
880 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)...
Theo F's user avatar
  • 1,839
0 votes
1 answer
309 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 ...
whitney vogel's user avatar
1 vote
1 answer
177 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, ...
mogita's user avatar
  • 13
6 votes
1 answer
118 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 ...
bibermann's user avatar
2 votes
2 answers
2k 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)'))...
c.j's user avatar
  • 75
1 vote
1 answer
2k 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 ...
marty_c's user avatar
  • 197
3 votes
1 answer
279 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 ...
Stephen's user avatar
  • 285
5 votes
1 answer
296 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 ...
J.Patordi's user avatar
  • 313
2 votes
2 answers
1k 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 ...
Scorpioooooon21's user avatar
1 vote
1 answer
71 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 ...
WMTS's user avatar
  • 101
2 votes
3 answers
553 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 ...
Peter Gerbrands's user avatar
1 vote
1 answer
161 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 ...
Jeff_Barahona's user avatar
1 vote
1 answer
631 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 ...
shadow's user avatar
  • 113
0 votes
0 answers
76 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 ...
A l w a y s S u n n y's user avatar
1 vote
1 answer
599 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 ...
jayarjo's user avatar
  • 367
3 votes
3 answers
1k 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 ...
derby's user avatar
  • 83
0 votes
1 answer
351 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 ...
Jio's user avatar
  • 652
0 votes
0 answers
61 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 ...
Mikeoramma's user avatar
4 votes
1 answer
290 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 ...
JamesLeversha's user avatar
1 vote
0 answers
378 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 ...
jayarjo's user avatar
  • 367
4 votes
1 answer
335 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 ...
nmn100's user avatar
  • 43
0 votes
2 answers
1k views

Using 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 than WGS 84 (SRID 4326) or Web Mercator (SRID 3857)?
Maxinef23's user avatar
3 votes
2 answers
297 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 ...
barteloma's user avatar
  • 1,714
0 votes
2 answers
524 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 ...
JamesLeversha's user avatar
1 vote
1 answer
991 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 ...
James's user avatar
  • 11
4 votes
2 answers
5k 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 ...
TheGuardener's user avatar
2 votes
1 answer
388 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 ...
pranshuagarwal's user avatar
5 votes
1 answer
2k 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 ...
rovyko's user avatar
  • 279

1
2 3 4 5