A Spatial Reference System Identifier (SRID) is a unique value used to unambiguously identify projected, unprojected, and local spatial coordinate system definitions

learn more… | top users | synonyms

0
votes
0answers
9 views

Distance Matrix in QGIS, which SRID

I read several threads about it.. How to get $length in meters in QGIS? How to join attributes from nearest point in QGIS? QGIS, CRS's and metric measurements of distance matrix and nearest ...
1
vote
2answers
46 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
1answer
153 views

Updating SRID (Update_GeometrySRID) does not alter polygons (when it should)

I am trying to change the SRID of polygons layer, but I'm having trouble visualizing the result. I the SRID is misreported the shapefile I used to import into PostGIS. The metadata says the ...
0
votes
1answer
43 views

Postgis geometry column with different srid

I have a table that has geometry column named the_geom. I set SRID value to 29903. And I used Openlayers api to view data on map. I set map srid as 29903 and works well. But if I need to show my data ...
1
vote
2answers
41 views

How to get ST_MakeLine ready for QGIS?

CREATE VIEW new_line AS SELECT point1.gid, ST_MakeLine(point1.geom, point2.geom) FROM point1, point2 WHERE point1.gid = point2.gid; It's possible to load the layer but QGIS says 'There is no entry ...
0
votes
0answers
40 views

H2GIS and POSTGIS

i use PostGIS and H2GIS and i have tested ST_Transform function on both systems: SELECT ST_AsText( ST_Transform( ST_GeomFromText('POINT('||to_char(5873455.6,'9999999.99')||' ...
0
votes
1answer
23 views

Transforming takes long time with st_transform

I have two shape files contains considerably large data. I exported them to my geodatabase(using arccatolog), which takes 2 days. The problem is their srid must be changed. So i tried creating new ...
0
votes
1answer
85 views

SRID, Shape2SQL and SQL Server 2008r2 query

I'm using Shape2SQL to load the Ordinance Survey's Meridian 2 map into SQL Server 2008r2 (which is working very smoothly and painlessly). According to this page ...
7
votes
1answer
49 views

Why is there an upper limit to the SRID value in the spatial_ref_sys table in PostGIS 2.1?

I was trying to insert a reference system in PostGIS from http://spatialreference.org/, and got a constraint violation for spatial_ref_sys_srid_check. I checked that constraint and found that, when ...
1
vote
1answer
50 views

Creating geodjango model with geometry field that can accept different projections

I am working on web application with GeoDjango and within the model (db table) RoadAxis I have geometry field or more precisely LineStringField where I need to store different polylines (road axis) ...
1
vote
0answers
38 views

set Default projection in postgis table

I've set the SRID 4326 for a table having geometry column, but when i insert a geometry without SRID, i get an error because no SRID specified is interpreted as -1 or 0, so how i can set a default ...
0
votes
2answers
61 views

SRID is messed up when google-maps layer is added

I've some problems with using a PostGIS layer within QGIS. First of all, I had this same problem on both QGIS 2.4.0 and 2.6.1 I cannot display the Google Maps layer AND my PostGIS layer together. ...
2
votes
1answer
63 views

Calculating Distances Between Geometry Columns of Differing SRIDs

I am attempting a relatively simple task but have been running into trouble. I have two tables, one which has lat and lon points which were geocoded using google (SRID 3857) and another table which ...
2
votes
0answers
64 views

Different SRID problem

Hi here is my problem, I have two geodatabases and i import a number(large) of tables from one to another by using arccatolog(ArcGIS 10.2). However the tables and indexes created on them are imported ...
1
vote
1answer
121 views

Baidu Maps SRID?

I am making an App which will make use of Baidu maps for geofencing and other features (as the app will be released in mainland China) I am using GeoDjango, with Postgresql / PostGIS / Proj4 etc.. ...
0
votes
0answers
44 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 ...
0
votes
0answers
41 views

How to work with SRID using PostGIS [duplicate]

I am using PostGIS with OSM Data from Geofabrik that covers the complete area of Austria. I am used to work with calissical longitude and latitude. If you enter Vienna, Austria in ...
2
votes
0answers
72 views

geodjango difficulties with srid

I'm trying to make geodjango app. I'm using SQLite and SpatialLite. I want to add shops, and be able to sort them from closest to furthest from my location. When in my model I have: location = ...
-1
votes
1answer
152 views

How to choose a SRID and what is its meaning? [duplicate]

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
0answers
133 views

How to choose data type and SRID, for coordinates from different sources, in a medium size zone

I'm developing an application. In the database I need to store coordinates for many places, in the north-east of Italy, but the area could expand in the future. This coordinates will come from some ...
2
votes
3answers
253 views

Where to find the units for a 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: ...
0
votes
1answer
33 views

why the graphics layer coming from the Geoprocessing service in WGS_84, is projected correctly on a Web Mercator Auxiliary Sphere Basemap

I have made a Geoprocessing service, which results (features) are in wgs_84 (4326). My map's spatial reference is wgs_84 Web Mercator Auxiliary Sphere 102100 (projected system) Considering that the ...
5
votes
3answers
374 views

PostGis: Geometry from UTM text

I have plain data in a postgresql table which looks like this: ╔════╦═══════╦═════════════╦══════════════╦══════════╦═════════════════╗ ║ id ║ index ║ easting ║ northing ║ utm_zone ║ ...
0
votes
2answers
209 views

What does the srid code mean in an sde.st_geometry?

In case of an sql insert query like : INSERT INTO OUTBREAKS (OID, address, city_code, loc) VALUES (1, '1420 kirchestrasse', 43, sde.st_geometry (0.00003, 0.00051, null, null, 4326) ...
0
votes
1answer
63 views

geometries with different SRIDs errors (even after setting SRID)

I've looked at existing questions about this (including this one) and followed the advice that was shared there. I'm still seeing this when I run some queries: RuntimeError: Postgis Plugin: PSQL ...
2
votes
1answer
239 views

How do I get the closest point on a road to a point when I have imported OSM data using osm2pgsql?

I have been trying to use OSM data to find the closest point to a road for a given point. I imported the OSM data into postgis using osm2pgsql, and I am getting results back, but they are at the ...
1
vote
2answers
372 views

Ensuring SRID on geometry column in PostGIS

I am using a table that has a geometry type column called "wkt". Its definition in the table looks like this: create table sometable ( ... wkt geometry not null, ... ); I want to change it ...
1
vote
1answer
39 views

Why does my query not run since SRID are the same?

I am running this query: SELECT source,ST_AsText(ST_ClosestPoint(roads.geom,ST_GeomFromText('POINT(22.256 39.569)'))) FROM roads ORDER BY ST_Distance(roads.geom,ST_GeomFromText('POINT(22.256 ...
1
vote
1answer
58 views

Equal Area SRID for Finland?

Does anyone know the SRID for an equal area projection that is suitable for Finland?
0
votes
0answers
149 views

Storing 3D Oracle sdo_geometry objects with a 2D SRID

I'm trying to understand the implications of storing 3-dimensional sdo_geometry values in Oracle when the geometry's SRID is a 2-dimensional system. The database I'm studying uses SRID 4326 (WGS84 ...
4
votes
2answers
154 views

Is there a command line tool for converting projection in .prj and GeoTiff to EPSG codes?

Is there a command line tool to convert a shapefile projection in the .prj file into corresponding EPSG code? I know that there is website http://prj2epsg.org/search for doing this online, but I ...
4
votes
0answers
83 views

Adding data from PostgreSQL to Query Layer of ArcGIS for Desktop warns that given coordinate references are incompatible?

When adding data from PostgreSQL in a Query Layer I get the warning "The given coordinate references are incompatible" I have added many other layers with the same properties no problems, but I have ...
0
votes
0answers
127 views

Find correct SRID

I'm learning PostGIS raster, and importing GeoTiff with raster2pgsql. This command line tool states: -s <srid> Set the raster's SRID. Defaults to 0. If SRID not provided or is 0, ...
1
vote
0answers
69 views

Node.js transformation from NAD83 to WGS84

I've used the excellent npm shapefile library to import Canadian electoral districts into MongoDB. Here's a sample file: http://ftp2.cits.rncan.gc.ca/pub/geott/electoral/2011/fed308.2011.zip Is ...
1
vote
1answer
209 views

Adding SRID 3857 to spatial_ref_sys

My application is throwing the following error: DatabaseError: GetProj4StringSPI: Cannot find SRID (3857) in spatial_ref_sys I'm guessing (as stated above) that I need to add the SRID 3857 to the ...
0
votes
1answer
100 views

Determining a meter-based SRID

I have a set of shapefiles (Kabul, Afghanistan) that are currently in the WGS84 geographic coordinate system (GEOGCS), which I believe has a SRID of 4326. In ArcMap, this coordinate system is decimal ...
3
votes
3answers
492 views

Problem with Geometry SRID in PostGIS

I ceated my table (borne) in PostGIS id_borne serial NOT NULL, num_borne character varying, shape_borne geometry I successfully changed the SRID of my table using select ...
3
votes
1answer
130 views

Should I use a projection or not, and if so what SRID would be useful?

First off, I realize that this is perhaps not the most stackexchange-esque question. I am however having trouble finding a good source of information for this. So if there is a better place for me to ...
1
vote
1answer
162 views

Nokia HERE maps SRID

I'm just beginning with GeoDjango and just came across with term SRID. What I've understood so far is that I'd need to know a little something about the map projection to for example calculate ...
4
votes
2answers
225 views

Storing SRID:4326 data as Geometry or Geography?

I used OGR2OGR to import SRID 4326 point data into MSSQL Server. Didn't realize that it defaults to creating a geometry column instead of detecting the data as 4326 and creating a geography column. ...
3
votes
1answer
207 views

How can I get proj4text from srtext?

I have a custom projection used in some shapes on a prj file. I want to insert this projection in the table spatial_ref_sys PostGIS. The data in the prj file will SRTEXT table field, how can I get ...
2
votes
1answer
274 views

Is it possible to get coordinate system name from SQL Server geometry type?

I need to get the name of the coordinate system of a geometry type field in SQL Server 2008 R2 (for example NAD_1983_UTM_Zone_14N or GCS_WGS_1984 or other). Is this possible?
3
votes
2answers
388 views

ESRI projection to SRID?

I am looking at MapX and MapY coordinates. The docs say they are "truncated State Plane coordinates: NAD 1983 State Plane Louisiana South FIPS 1702 (US Feet)." I am trying to reproject into a common ...
1
vote
1answer
427 views

Reprojecting in postGIS from 900913 to 4326. Wrong coordinates

I'm working with postGIS 2.1 I have a table called 'xacementos' created with the srid: 900913. I took the points coordinates from google maps and I want to convert them to SRID:4326 to show the points ...
2
votes
1answer
117 views

Problem while Reprojecting

When I try to transform geometries from SRID 2321 to 4326, the transformed coordinates are swapping. Why is this happening? Below are the details Source SRID - EPSG:2321 Source Data Projection ...
9
votes
1answer
591 views

Using customized Coordinate System for Archaeological site data

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 ...
2
votes
1answer
178 views

PostGIS ST_Contains query returns null

I have a shapefile of all US States that I've imported into a table with a multipolygon geometry column. (SRID 4326) I perform a spatial query based on lat/lon to return the state abbreviation. This ...
6
votes
1answer
323 views

How do I change an existing srs in QGis?

I am showing postgis data with srid 28992 (Amersfoort / RD New). But when I plot the geospatial data on a map (with openlayers plugin), the data is shown a hunderd meters off because the datum shift ...
6
votes
2answers
148 views

Postgis 2.1 Inconsistent with spatialreference.org

The County of Napa, California, uses a projection "NAD_1983_StatePlane_California_II_FIPS_0402_Feet"; for example their roads.prj file has: ...
2
votes
1answer
904 views

Postgis | Problems Reprojecting a Point from UTM ED50 to GEOGRAPHIC ETRS89

I've got a POINTS PostGIS table in the 23030 (ED50 UTM 30N) SRID. I'm having a lot of problems trying to reproject those points from ED50 UTM coordinate system to ETRS89 Geographic (lat/long) ...