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
212
questions
1
vote
1
answer
37
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 ...
- 21
1
vote
0
answers
35
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 ...
- 111
0
votes
0
answers
55
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 ...
0
votes
2
answers
41
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 ...
1
vote
1
answer
99
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 ...
- 33
1
vote
1
answer
35
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
124
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
46
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. ...
- 11
2
votes
1
answer
200
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,214
1
vote
0
answers
76
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 ...
- 11
1
vote
1
answer
121
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,154
0
votes
1
answer
151
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
412
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,667
0
votes
1
answer
133
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
95
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
87
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 ...
- 61
2
votes
2
answers
769
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
779
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 ...
- 177
3
votes
1
answer
183
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 ...
- 275
5
votes
1
answer
229
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 ...
- 313
2
votes
2
answers
713
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 ...
- 401
1
vote
1
answer
50
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
425
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
83
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
284
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
46
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 ...
- 141
1
vote
1
answer
347
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 ...
- 327
3
votes
3
answers
887
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
191
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 ...
- 574
0
votes
0
answers
55
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 ...
- 523
4
votes
1
answer
188
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 ...
- 713
1
vote
0
answers
191
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 ...
- 327
4
votes
1
answer
220
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
414
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)?
- 93
2
votes
2
answers
175
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,654
0
votes
2
answers
364
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 ...
- 713
1
vote
1
answer
698
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
3k
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 ...
- 191
2
votes
1
answer
296
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
174
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 ...
- 537
2
votes
1
answer
526
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 ...
- 489
1
vote
0
answers
153
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
470
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
...
- 986
0
votes
0
answers
69
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,654
0
votes
1
answer
179
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,214
2
votes
1
answer
180
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
470
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,698
3
votes
1
answer
779
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