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
3
votes
3answers
78 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 ...
0
votes
1answer
36 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 ...
0
votes
0answers
39 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
1answer
54 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
0answers
32 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 ...
4
votes
1answer
70 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 ...
0
votes
2answers
65 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?
1
vote
2answers
54 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 ...
0
votes
2answers
43 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
1answer
67 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 ...
3
votes
2answers
197 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
1answer
63 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 ...
1
vote
1answer
198 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 ...
1
vote
1answer
43 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
1answer
117 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
0answers
45 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....
1
vote
1answer
110 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 ...
0
votes
0answers
32 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
90 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
76 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
115 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
135 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
86 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
271 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
811 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
108 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
5k 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
2answers
595 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
2answers
334 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
413 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
494 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
28 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
433 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
101 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
379 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
62 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
514 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
524 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
149 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
433 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
505 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
498 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
37 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
446 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
299 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
206 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
2k 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
241 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:...
1
vote
1answer
520 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....