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
19 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
39 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
26 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
31 views

Equal Area SRID for Finland?

Does anyone know the SRID for an equal area projection that is suitable for Finland?
0
votes
0answers
45 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
87 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
56 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
44 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, ...
0
votes
0answers
35 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
73 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
44 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 ...
2
votes
3answers
134 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
97 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
80 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
113 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. ...
2
votes
1answer
86 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
94 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
240 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
219 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
93 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 ...
8
votes
1answer
307 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
110 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
195 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
1answer
113 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
641 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) ...
0
votes
0answers
113 views

How can I ensure srid is properly set on Postgis when importing shapefile?

I am uploading a shapefile to Postgis via Geoserver rest api but I end up with querying issues especially with srid i.e "ERROR: XX000: Operation on two geometries with different SRIDs". The import has ...
0
votes
1answer
333 views

Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type

After import some data from OSM file into Postgre, the coordinates numbers are too big and having trouble to cast to Geography: Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY ...
2
votes
0answers
20 views

Problem with postgres/quantum converting long/lat to suitable projection/SRID [duplicate]

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 ...
0
votes
2answers
571 views

Override “ERROR: Operation on mixed SRID geometries” and force PostGIS to do the query

I'm trying to do an st_intersects query in postgis for two shapes (a point and buffer zone) which are of the same projected coordinate system. Unfortunately, one of the tables seems to have its ...
1
vote
1answer
274 views

PostGIS is rejecting an srid code for my projection. I've found a nearly identical projection w/ a legit srid. Will it work?

My projection is this: NAD 1983 StatePlane North Carolina FIPS 3200 Feet, which has a proj4 string that looks like this: +proj=lcc +lat_1=34.33333333333334 +lat_2=36.16666666666666 +lat_0=33.75 ...
0
votes
1answer
120 views

cartodb: query for the points within a radio from another point - postgis

I've georreferenced a couple of points in a CartoDb table, so now I have a the_geom column of type point I'd like to get all the points that are x meters away from a certain x,y point. So far now, ...
5
votes
1answer
101 views

Is there a way to determine the datum used when all you have is a lon and lat?

I have a dataset of US intersections from 2011 that I'm going to be using in a project together with data based in WGS84. Included in the CSV file is a variety of fields two of which are the lat and ...
1
vote
2answers
2k 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 ...
3
votes
1answer
124 views

Strange exposure of a PostGIS layer in QGIS after importing OSM data into a database

I've imported a osm layer into my postgres/postgis database. osm2pqsql -E 3857 -c -S /usr/share/osm2pgsql/default.style -H localhost -W -d landslide -U postgres oberpfalz-latest.osm.bz2 During the ...
0
votes
1answer
205 views

What SRID is this projection?

Anyone know what the SRID is for the following projected coordinate reference system: { PROJCS [ "Florida 0901, Eastern Zone [1983, US Survey feet]", GEOGCS [ "NAD 83 ...
1
vote
1answer
1k views

PostGIS - Geometry or Geography find points within distance in meters

I have a requirement where I need to store lat/long coordinates for locations all around the world. I then need to query for those locations that are within a specified distance (in meters) from ...
4
votes
1answer
351 views

PostGIS spatial reference ID (SRID) for regular cartesian coordinate system?

I would like to store a polygon as a set of 2D points represented as x, y coordinates of a Cartesian coordinate system. Which spatial reference can I use? Looking at my spatial_ref_sys table, all the ...
4
votes
2answers
661 views

ST_Distance is not delivering right results

I want to calculate the distance between lat/lon points. I tried the following queries: Select ST_DISTANCE(ST_GeomFromText('POINT(-73.97923 40.75571)', 4326), ST_GeomFromText('POINT(-73.974509 ...
8
votes
3answers
4k 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 ( { ...
0
votes
1answer
88 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 ...
1
vote
1answer
442 views

PostGIS not converting GIS data into latitude/longitude values

I am running PostgreSQL and PostGIS. I am trying to do something mind-numbingly simple: determine the latitude and the longitude of a point. Unfortunately, PostGIS stubbornly refuses to transform the ...
2
votes
1answer
205 views

Calculating points in the USDA's Cropland Data Layer coordinate system

I need to integrate against the USDA's cropland data layer. They've got a demo and some API docs. The important query I need to run is this, given an (x, y) of say (1551459.363, 1909201.537): ...
2
votes
1answer
400 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> ...
1
vote
0answers
85 views

How to import multiple shapefiles each with different source projections to postgis

I have a couple thousand .zip files each with a .shp, .dbf, .shx, and .prj inside them that I want to load into postgis. The problem is, they have many different source projections (each defined in ...
3
votes
1answer
947 views

add new SRID to sql server

Is it possible to add a new SRID to sql server 2012? I've tried insert into sys.spatial_reference_systems values (4938, 'GEOCCS["GDA94",DATUM["Geocentric Datum of Australia 1994",SPHEROID["GRS ...
1
vote
4answers
885 views

finding the definition of missing srid in postgis

I am converting a spatial Oracle database to POSTGIS, and one of the problems I encounter is that we use SRID in Oracle that do not exist in POSTGIS. I am talking about the following SRID: 90112 : ...
3
votes
0answers
245 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 ...
1
vote
1answer
1k views

SRID 4326 and geometry conversion

From this line: SELECT ST_AsEWKT(geom) FROM buildings LIMIT 1; I get this result: "SRID=4326;MULTIPOLYGON(((404269.308014269 4543087.6184561,...)))" I'm wondering if the coordinations are ...
2
votes
1answer
2k views

How to fix incorrect SRID of the geometry column? [duplicate]

I've been told to use AddGeometryColumn to properly add a column with correct/preferred SRID. however I wonder if it's possible to fix/change the current column instead of adding a new? If there's no ...
0
votes
1answer
167 views

Why does Find_SRID return zero?

using SELECT Find_SRID('public', 'myTable', 'myColumn'); I get zero as the result, what does it mean? Regards,