Stack Overflow
Stack Overflow

Questions tagged [srid]

A Spatial Reference System Identifier (SRID) is a 4-5 digit number used to unambiguously identify any Coordinate Reference System (CRS) definition while also pointing at sets of up to 20 parameters describing each CRS. Being part of the Simple Features standard of the Open Geospatial Consortium (OGC) SRIDs are used in most Geographic Information Systems. Use this tag for questions concerning the projection or transformation of geospatial data to a CRS.

45 questions
0
votes
0 answers

Why does SDO_LRS.CONCATENATE_GEOM_SEGMENTS_3D zero out the Z index?

Please look at following query (run on Oracle 19c): SELECT SDO_LRS.CONCATENATE_GEOM_SEGMENTS_3D ( MDSYS.SDO_GEOMETRY( 4402, 4327, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 2, 1), MDSYS.SDO_ORDINATE_ARRAY(-87.5581857869439, 41.6569754435628,…
gurunara5
  • 1
  • 1
0
votes
0 answers

MySQL 8.0.30+ - Check if a POINT() is inside a POLYGON() using SRID 4326

I'm using MySQL 8.0.30 which has fixed a major known issue related to SPATIAL indexes. I've modified a POINT() column to transform it to SRID 4326. Before, I had the following query returning 20+ rows: SELECT r.id FROM record r WHERE…
Bruno Leveque
  • 2,647
  • 2
  • 23
  • 33
0
votes
1 answer

An error occurred when transforming the geometry to the SRID of the geometry form field

I am working on geodjango , postgis and found a problem while saving a location from OSMGeoAdmin with open street map .The map showing accordingly but when i want to save a location it shows with red error "An error occurred when transforming the…
paul
  • 51
  • 2
  • 11
0
votes
1 answer

how reprojections are done with srid = -1

I get a huge doubt, I have a shape file that I introduced to postgres and I didn't specify an srid, so the_geom column has -1 in the srid, when I start any other map viwers like QGis or MapSertver I don have any problem to see the figure exactly…
AIM
  • 3
  • 1
0
votes
1 answer

Set SRID in View From XY Data

Trying to create a view that joins two tables, converts XY coord data into a sinlge spatial point, and sets the SRID value. I've got it all working except for the SRID command. I can't use pre assigned coordinates to do a transform as I'm generating…
Sessamel
  • 1
  • 3
0
votes
1 answer

How to transform an point cloud at once in PostgreSQL with PostGIS

I have an pointcloud which has an certain SRID. Now I want to transform the whole pointcloud using an select query into an different SRID (here: 4326 lat, lon). My first super inefficient approach is: SELECT ST_X ( ST_GeometryN( p , n ) ) as…
nali
  • 481
  • 1
  • 3
  • 16
0
votes
1 answer

Is it possible to use a fake projection in PostGIS?

I'm creating a spatial table in PostGIS. My geometries are going to be abstract, not related to a real world. So I need some fake SRID. What is the right way to do it?
Alexey Pomelov
  • 196
  • 1
  • 9
0
votes
1 answer

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 code I'm using. I keep getting back NaN. I've…
Doug
  • 264
  • 2
  • 10
0
votes
2 answers

MySQL Spatial - Convert Point from EPSG 4326 to 25831

I'm trying to learn how geospatial fields work in MySQL (5.7.20). I have a table like: CREATE TABLE `geom` ( `g` geometry NOT NULL, SPATIAL KEY `g` (`g`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; I had inserted this info: INSERT INTO geom VALUES…
Radiaktive
  • 108
  • 6
0
votes
1 answer

SRID in CreateTopology () in postgis topology

I am trying to createTopology() and find intersection information. But CreateTopology () has a SRID parameter. I am new to GIS so I really don't know what this means. The documentation says it is spatial reference identified as defined in…
daydayup
  • 2,049
  • 5
  • 22
  • 47
0
votes
1 answer

changing SRID of SDO_geometry from existing value without changing the original value

I have a Oracle database table with a column in SDO_GEOMETRY type. I am trying to write a view on this table and get the SDO_GEOMETRY column with different SRID. I don't want to change the original table or transform the value to a different SRID. I…
Use the fork Luke
  • 207
  • 4
  • 15
0
votes
1 answer

Get metric distance between two points via a PostgreSQL/PostGIS request

I have a question about the use of postgreSQL/postGIS. I would like to display markers on a map (stored in a database) which are some distance away from the user (coordinates given to the request). The type of the field of the markers is POINT (I…
QuentinG
  • 101
  • 2
  • 11
0
votes
1 answer

srid(geometry) function does not exist: Java hibernate

I'm retaking an old project that someone at my university was working on. It is mostly some DB management of geographic data (which is being made in psql, and using postgis 1.5 and 2.0) and some modifications and a GUI made in java netbeans. For the…
primer_cuervo
  • 101
  • 1
  • 10
0
votes
1 answer

Put points on the map, longitude/latitude not where they should be although SRID the same

Thank you for looking at this - I'm sure it's a simple question but this is all very new to me and after a lot of internet searching my points are still in the sea! I have a set of UK postcode data that I have converted into latitude and longitude.…
polly compston
  • 9
  • 1
0
votes
1 answer

Force geoserver to 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 administration page). In the layer definition of the…
Nko
  • 341
  • 1
  • 7
  • 18
1 2
3