Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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
0answers
23 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
26 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
52 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
66 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'...
16
votes
1answer
4k views

Using customized Coordinate System in ArcGIS Desktop?

I don't know so much about coordinate systems... In my office we use to deal with spatial data coming from archaeological sites. Each site has its own x-y-z coordinate system (GCS). Three simple ...
0
votes
1answer
387 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
1answer
191 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. ...
2
votes
3answers
3k views

Finding units for specific spatial reference system?

I want to use the st_within function to find geometries within a specifi distance. My geometries are both in the same SRID stored in a postgis db. From what I read here: http://postgis.net/docs/...
3
votes
1answer
45 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 ...
13
votes
4answers
4k views

Looking for a pythonic way to calculate the length of a WKT linestring

I was quite unsatisfied with Calculating Length of Linestrings in WGS84 in Miles. It kept me wondering if there is a more convenient, Pythonic way to calculate the length of a WKT linestring according ...
0
votes
1answer
252 views

Auto-reprojecting (st_transform) SRIDs in Postgis

I have a postgis table that is edited from different sources. The points added from Source 1 are in SRID 23030. The points added from Soruce 2 are in SRID 4230. I want all the points in the table ...
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 ...
3
votes
2answers
2k 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 ...
5
votes
2answers
2k views

Create custom coordinate system in postgis

I have a Wayne county Michigan parcel dataset with a custom SRID: when I bring it into ArcGIS Projected Coordinate System: NAD_1983_HARN_StatePlane_Michigan_South_FIPS_2113_Feet_Intl Projection: ...
10
votes
3answers
17k views

Adding additional geometry column in PostGIS?

I'm importing many sets of geodata into PostGIS, and they have different SRID's. (Some have EPSG:3857, some EPSG:4326, some something else). I'd like to create an additional geometry column, eg. ...
4
votes
4answers
6k views

Performing SQL Server Geometry to geography conversion?

I have imported a number of Shapefiles from the ordnance survey using shape2SQL These have been imported as geometry however i would like to convert them to Geography and specifically to srid 4326 ...
1
vote
1answer
62 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
0answers
406 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." ...
0
votes
1answer
126 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 ...
3
votes
1answer
377 views

Converting 32639 spatial reference to 3857 in PostGIS

I have a polygon layer which is in UTM 39N as x and y coordinates. I need to convert it to EPSG:3857 and for this I used ST_Transform. select st_transform(geom,3857) from block_1 But when I get ...
19
votes
4answers
16k views

Is it possible to reproject spatial data using SQL Server?

SQL Server takes an SRID when creating spatial data, but is it possible to retrieve with a different SRID translating the coordinates? For example, let's say I have a bunch of spatial polygons using ...
0
votes
1answer
264 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. ...
2
votes
0answers
35 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> -- ...
8
votes
1answer
399 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 ...
1
vote
1answer
268 views

Convert ETRS89 points to CARTO Lat Long

I'm new in Geographic Information Systems and programming. I have some points referencing Barcelona, Spain. These points are comming from City Hall's opendata site. They say they are in ETRS89 ...
0
votes
1answer
81 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
1k views

Why does Find_SRID return zero?

using SELECT Find_SRID('public', 'myTable', 'myColumn'); I get zero as the result, what does it mean?
0
votes
1answer
351 views

Force GeoServer SRID 0

I'm developing a GIS solution which uses only geometry data. I designed my spatial DB with PostGIS and now I'm performing some trials connecting the DB with GeoServer map server (using the ...
0
votes
2answers
253 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 ...
3
votes
0answers
81 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 ...
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
302 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
1answer
226 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["...
53
votes
1answer
39k views

Choosing SRID and what is its meaning? [closed]

I'm new to GIS, in PostGIS, and I'm struggling with the SRID concept. How do you choose a SRID for a database column? This is making me crazy. Why do I need to choose a SRID? What's its meaning? ...
0
votes
1answer
46 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
308 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 ...
1
vote
1answer
187 views

Equal Area SRID for Finland?

Does anyone know the SRID for an equal area projection that is suitable for Finland?
0
votes
2answers
351 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
125 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["...
4
votes
1answer
96 views

Problems with SRID 32717

I'm new with GIS systems and I need to determine if a point is into a polygon, I'm using a shapefile with SRID 32717 and I have a list of points (long, lat). With QGIS I export the shapefile to a ...
2
votes
1answer
194 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 ...
7
votes
2answers
980 views

Creating Ellipse in WGS84, but with metric parameters

I have the function --Ellipse(x,y,rx,ry,rotation,#of segments in 1/4 of ellipse) SELECT ST_Translate( ST_Rotate( ST_Scale( ST_Buffer(ST_Point(0,0), 0.5, $6), $3, $4), $5), $1, $2) I have points in ...
3
votes
2answers
269 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
230 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(...
3
votes
1answer
2k views

How to transform SRID 3035 to SRID 4326?

I have data in the ETRS 89 LAEA format (SRID: 3035). But I have problems to transform it. Example data: N2736 E4541 I want to transform it to WGS84 (SRID: 4326), to check the coordinates on a ...
0
votes
1answer
356 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 ...
2
votes
1answer
1k views

Problem with writing the srsName into gml output in OpenLayers

I am trying to write out my geometry in gml format after it is drawn in OpenLayers. Actually it is working fine, I get the gml like this: <gml:Polygon> <gml:outerBoundaryIs> <gml:...
5
votes
1answer
11k views

Transforming geometry coordinates from SRID 4326 to SRID 3011 [duplicate]

In SQLServer geometry field, I want to change the coordinates of geometry from one spatial reference system to another spatial reference system (from SRID 4326 to SRID 3011) by using ST_Transform. But ...
2
votes
1answer
136 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
925 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 ...