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
15 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 ...
  • 11
0 votes
0 answers
32 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 ...
  • 1
1 vote
0 answers
34 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. ...
2 votes
1 answer
62 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 ...
  • 2,154
1 vote
0 answers
43 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 ...
1 vote
1 answer
66 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 ...
  • 1,085
0 votes
1 answer
84 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 ...
  • 53
1 vote
0 answers
233 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)...
  • 1,507
0 votes
1 answer
52 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 ...
1 vote
1 answer
49 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, ...
  • 13
6 votes
1 answer
77 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 ...
2 votes
2 answers
275 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)'))...
  • 75
1 vote
1 answer
412 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 ...
  • 157
3 votes
1 answer
114 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 ...
  • 255
5 votes
1 answer
181 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 ...
  • 281
2 votes
2 answers
434 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 ...
1 vote
1 answer
44 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 ...
  • 101
2 votes
3 answers
362 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 ...
1 vote
1 answer
71 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 ...
1 vote
1 answer
222 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 ...
  • 13
0 votes
0 answers
32 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 ...
1 vote
1 answer
263 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 ...
  • 317
3 votes
3 answers
662 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 ...
  • 83
0 votes
1 answer
141 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 ...
  • 566
0 votes
0 answers
51 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 ...
4 votes
1 answer
123 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 ...
1 vote
0 answers
117 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 ...
  • 317
4 votes
1 answer
181 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 ...
  • 43
0 votes
2 answers
180 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)?
2 votes
2 answers
137 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 ...
  • 1,634
0 votes
2 answers
285 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 ...
1 vote
1 answer
571 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 ...
  • 11
4 votes
2 answers
2k 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 ...
2 votes
1 answer
229 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 ...
5 votes
1 answer
1k 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 ...
  • 279
1 vote
1 answer
147 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 ...
2 votes
1 answer
440 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 ...
1 vote
0 answers
128 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....
  • 11
1 vote
1 answer
396 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 ...
  • 918
0 votes
0 answers
61 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....
  • 1,634
0 votes
1 answer
156 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["...
  • 2,154
2 votes
1 answer
140 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, ...
  • 567
0 votes
2 answers
354 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'...
  • 2,452
3 votes
1 answer
644 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 ...
  • 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 ...
  • 137
1 vote
1 answer
150 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
1 answer
589 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 ...
9 votes
1 answer
2k 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 ...
  • 329
0 votes
1 answer
199 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 ...
7 votes
3 answers
10k 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 ...
  • 163

1
2 3 4 5