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

2
votes
1answer
719 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:...
1
vote
1answer
188 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) ...
5
votes
3answers
58 views

Different values while calculating distance

I'm developing a project using LeafleatJS and PostGIS. Currently I'm getting trouble while calculating distance between two coordinates. For example: Point 1 - lat: -12.99835864475412, lng: -38....
1
vote
1answer
20 views

Control number of segments in ST_Buffer for geographies?

I've been attempting to construct circles centered around a list of points in PostGIS with good success. I've opted to circumvent having to look up UTM zones and using optimal SRID by simple letting ...
0
votes
1answer
3k 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
41 views

Transform data type EWKT and GeoJSON to SRID 900913 [duplicate]

Is posible transform data type EWKT with SRID 0 for example: MULTIPOLYGON(((295098.566494 6006717.0377012,344018.26458971 6009163.022606,329342.355161 5972473.2490342,295098.566494 6006717.0377012))) ...
1
vote
1answer
69 views

Transform to SRID 900913

How i can transform the geometry WKB for example: ...
0
votes
0answers
39 views

SRID and lat long values

I am using the following query to generate the lat long values SELECT NAME, ST_X(ST_Centroid(ST_Transform(geom, 4326))) as longitude, ST_Y(ST_Centroid(ST_Transform(geom, 4326)))as latitude from ...
4
votes
0answers
104 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 ...
2
votes
1answer
54 views

Add SRID to Point

When inserting a point into a PostGIS database I do it using ST_GeomFromText('POINT(0 1 2)',26918). Note that this was done on a tutorial database where the SRID was set manually as explained ...
10
votes
1answer
1k 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 ...
0
votes
1answer
40 views

Do different RDMS use different SRID's to identify the coordinate system of a spatial object?

I'm looking for a reference that lists a standard SRID for a given CRS. Do RDMS's utilize a standardized SRID, such as OGC? Or is it unique to the RDMS?
0
votes
0answers
148 views

GeoDjango: Insert geography coordinates and filter the nearest points, step by step

I would like to: Save pairs of srid 4326 (latitude, longitude) points in a PostGIS Geodjango 1.8 Database. (Maximum distance between the edge points: 2.000km) Given a srid 4326 (latitude, longitude) ...
0
votes
1answer
35 views

How to get detailed informations about a layer (SRID, extent, …) in Geoserver REST API?

I'm trying go get detailed informations about a layer using the Geoserver REST API (I'm using Geoserver 2.8.1), but according to the online API documentation, I can only get basic informations such as ...
1
vote
0answers
61 views

Best SRID for worldwide data in Microsoft Sql Server geometry field?

I'm using Microsoft Sql Server 2012 to store geographical data related to hydrometeorological stations which are scattered around the globe (point layers and multipolygon layers). My data is in WGS84 ...
1
vote
2answers
119 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 ...
1
vote
0answers
49 views

Geocoding and SRID - can't get desired SRID

I want to geocode a set of addresses with GoogleMaps, store the results in a different SRID in a PostGIS table and then project it in QGIS over a layer with the identical SRID. So far, it has been a ...
4
votes
1answer
205 views

Is re-projection needed from SRID 4326 (WGS 84) to 4269 (NAD 83)SRID

I have US census data against state boundaries stored as SRID 4269, in an MSSQL DB. The input data used for calculations against that dataset is stored as SRID 4326. As far as I can infer from the ...
0
votes
0answers
57 views

Filtering out of bounds' coordinates

I have a set of coordinates, that I receive from GPS. I store them in database, its geometry is 4326. I am using the next query to calculate the travelled distance: ST_length(ST_Transform(st_makeline(...
1
vote
0answers
60 views

ESRI/SRID mismatch: How to correct?

I'm currently working with PostgreSQL and CartoDB to display X and Y coordinates converted to a geom. My shp files have been created and are displayed through CartBD. When I try and run a map view, ...
2
votes
2answers
92 views

What is the SRID for EPSG 102743?

I am trying to create a table in PostGIS for some LiDAR data and I need to set the the_geom column to my data's SRID. My data is in EPSG 102743, but when I try to use 102743 as my SRID as the_geom I ...
1
vote
0answers
112 views

SRID of geoemtry exported in PostgreSQL with ogr2ogr

I use ogr2ogr to export geometric data from EDIGEO files to some PostgreSQL table in append mode, but the output geometry SRID is always set to zero. Can I do something to specify the output geometry ...
3
votes
2answers
136 views

Which SRIDs to use for what tasks?

I try to understand the idea behind the different Spatial Reference Identifiers. I understand that the different SRIDs identify different projection views on the earth and that they are important for ...
1
vote
2answers
31 views

proj4text column blank for SRID 97688 - causing errors

So apparently a blank proj4text field causes errors when adding a record. When you enter something close to correct into proj4text, the records get inserted without error. So what is the correct value ...
0
votes
1answer
67 views

UpdateGeometrySRID and low disk space

I have imported a 508GB DB with unknown SRID with ogr2ogr, hence my geometry SRID is 900914. Now I'd like to run SELECT UpdateGeometrySRID('contours','wkb_geometry',3857); However, I'm running ...
1
vote
1answer
215 views

change SRID of shapefile and QGIS

It is possible to change the SRID from a shapefile to another SRID in QGIS ? I have a shapefile in 2100 srid and i want to change it in 4326 SRID.
1
vote
1answer
49 views

SRID awareness in Postgis functions

I have a column named position with geo data. Query: SELECT ST_SRID(position) FROM checkpoint LIMIT 1; returns 4326 If I try to simplify/compress points with SELECT st_dumppoints(st_simplify(...
0
votes
1answer
23 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 ...
4
votes
1answer
272 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 ...
1
vote
2answers
434 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. ...
0
votes
1answer
167 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 ...
0
votes
0answers
118 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')||' '||to_char(445588....
10
votes
2answers
17k views

How I get SRID from Geometry field

what is the function for getting SRID from Geometry field. I have inserted a shapefile into SQLServer table with Geometry field defined. I know the projection of shapefile is Swreff99_1800 (EPSG:3011)....
0
votes
1answer
41 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 ...
7
votes
1answer
111 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 ...
0
votes
1answer
244 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 (https://alastaira.wordpress.com/2011/...
2
votes
0answers
157 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 ...
4
votes
3answers
641 views

which map projection should I use to calculate distance in Poland

I'm using/learning geodjango + postgis, and I'm trying to calculate distance between 2 cities in Poland. First using WGS84/4326 I define 2 points, and then after transforming this points into ...
6
votes
2answers
176 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: PROJCS["NAD_1983_StatePlane_California_II_FIPS_0402_Feet"...
2
votes
1answer
142 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 ...
0
votes
2answers
102 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. ...
13
votes
4answers
12k views

How to insert a GeoJSON polygon into a PostGIS table?

I need to insert a polygon from GeoJSON to my PostGIS table. This is how the SQL query looks like. INSERT INTO tablename (name, polygon) VALUES ( 'Name', ST_GeomFromGeoJSON ( { ...
2
votes
0answers
99 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
300 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.. ...
8
votes
2answers
6k views

PostGIS Geometry Query returns “Error: Operation on mixed SRID geometries” only for certain values

I have PostGIS table with two geometry columns, both defined with SRID 4326. I can insert into the table without problem, using the following INSERT statement (where lng and lat are values passed in ...
0
votes
0answers
81 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
42 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 http://itouchmap.com/...
2
votes
0answers
150 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 = ...
5
votes
3answers
968 views

PostGis: Geometry from UTM text

I have plain data in a postgresql table which looks like this: ╔════╦═══════╦═════════════╦══════════════╦══════════╦═════════════════╗ ║ id ║ index ║ easting ║ northing ║ utm_zone ║ ...
2
votes
3answers
690 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: http://postgis.net/docs/...