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
1
vote
0 answers

Why is MySQL Database not using my spatial index?

In my setup I want to use a spatial index to search efficiently through a database, in particular to get all points in a radius around a second point. However, I'm kind of confused, why MySQL (version 8.0.29) is refusing to use my index. My query is…
andyde
  • 11
  • 1
1
vote
0 answers

Error: st_crs(x) == st_crs(y) is not TRUE

I am trying to execute following code to get nearest distance: df1 <- fread("df1.csv") df2<- fread("df2.csv") #converting geometry column data in df1 from wkb to multilinestring: df1$geometry <- sf::st_as_sfc(structure(as.list(df1$geometry),…
user17237211
  • 39
  • 5
1
vote
1 answer

MySQL 8 st_distance_sphere gives different values for different SRID

When, I run (SRID = 4326) Select st_distance_sphere( ST_GeomFromText( 'point(-51 -23)',4326), ST_GeomFromText('Point(-51.4264 -23.4158)',4326))/1000 as distance; I get '55.55951760685804'. SRID 4326 But, when, I run (SRID = 0) Select…
Dylan
  • 11
  • 3
1
vote
0 answers

Insert new Spatial Reference System (SRID) into SQL Server

Sorry for the long introduction before my question, but I have seen it answerd a few times in a way that does not help me precisely because of lack of contest. For those of you who are willing to read until the end and try to aid me, I really…
Luiz Rodrigues
  • 21
  • 2
1
vote
0 answers

Custom SRID in Django-Leaflet

I'm having trouble specifying a custom SRID with django-leaflet. The documentation on projections isn't very detailed, and mentions only briefly: By default, django-leaflet will try to load the spatial reference from your static files at…
sc28
  • 1,163
  • 4
  • 26
  • 48
1
vote
2 answers

Oracle: Change SDO_GEOMETRY's SRID for all tables in a schema

I need to change the SRID (set it to NULL) in the geometry objects of all tables in a specific schema (for a specific user) The command: UPDATE my_table t SET t.geometrie.sdo_srid = null; works fine for a single table. When I try to do it in a loop…
Pramisters
  • 13
  • 3
1
vote
2 answers

EPSG:4008 Layer Not Displaying

I have a map with OSM and Google Base layers and EPSG:4326 overlays. Now I am also trying to add overlays with other EPSG's to my map. Overlays which had an EPSG:2333 displayed just fine with no problems. Then I tried to add a layer with…
elshae
  • 539
  • 3
  • 11
  • 30
1
vote
1 answer

Django + SpatiaLite + srid + distance queries

I am trying to do simple geodjango app, which contains list of shops, and when you put an address in it it returns closest shops to your location. I am following tutorial which used PostgreSQL and Postgis, but I want to use SQLite and SpatiaLite (I…
ajgoralczyk
  • 35
  • 1
  • 10
1
vote
1 answer

POSTGIS: ERROR: Operation on mixed SRID geometries. Trying to find overlapping geoms with two different SRIDS/tables

POSTGIS_VERSION=2.1; I have two tables with two different SRID. My objective is to show which geoms from TABLE_B intersect with a region from TABLE_A. SELECT tablebname, a.geom FROM TABLE_B as a INNER JOIN (SELECT geom FROM TABLE_A WHERE tableAID =…
Rusty Robot
  • 1,725
  • 2
  • 13
  • 29
1
vote
2 answers

What spatial SRID is this? (trying to convert a .shp file to WSG84)

I'm trying to import some Shapefile mapping data into Sql2008. Before I do that, I need to convert it to WGS84 / SRID 4326, because all my existing data is in this format. This is the source file info: GEOGCS["GCS_GDA_1994",DATUM["D_GDA_1994", …
Pure.Krome
  • 84,693
  • 113
  • 396
  • 647
1
vote
1 answer

OpenStreetMaps and Postgis: wrong latitude and longitude from a geography point

I downloaded the file italy.osm and import to postgresql with postgis. So i try to extract latitude and longitude from the field "way" (geometry) of the table planet_osm_point, using the functions ST_X(), ST_Y() and these are the coordinates that I…
eold
  • 324
  • 4
  • 12
1
vote
1 answer

MongoDB spatial query for Polygons

I will build a GIS system based on polygons, not just points. I wanted to use MongoDB or PostGIS. How do this in MongoDB? Query A - get the center of a polygon Query B - distance between two polygons Query C - list of polygons that are part of a…
Ciro Vargas
  • 422
  • 1
  • 5
  • 16
1
vote
1 answer

GeoDjango + PostGIS calculates wrong Distances

I just installed PostGIS with GeoDjango. Everything worked fine, but now I have a problem and cant find out the reason for this. I have model like this: from django.contrib.gis.db import models class Shop(models.Model): name =…
Chris
  • 1,266
  • 4
  • 16
  • 34
0
votes
1 answer

How to change the projection in DataGrip's Geo Viewer?

Is it possible to change the projection of the base map in DataGrip's Geo Viewer???
Kambei
  • 458
  • 9
  • 23
0
votes
0 answers

Unit testing spatial database repository

Normally I wrap my persistence layer using a repository pattern, which I then unit-test using SQLite. Now I am processing spatial data using NetTopologySuite. The repository method GetUsersInPerimeterAsync(requestorLoc, perimeter) should return all…
Robert L.
  • 137
  • 1
  • 13
1
2
3