0
votes
1answer
67 views

QGIS to solve projection mystery in Postgresql

I downloaded some data from local agency. Per QGIS 2.2, I defined the projection to 'EPSG:3587 - NAD83(NSRS2007) / Michigan Central' in postgresql (maybe ArcMap). Data is in Postgresql 9.3. I am ...
1
vote
1answer
114 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 ...
0
votes
1answer
76 views

How to provide a WFS in multiple projections

I would like to set-up an editable web feature service (WFS-T) for serving my geospatial data. The data tables are in a PostGIS database on the same server. For security reasons my server admin ...
1
vote
1answer
428 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) ...
2
votes
1answer
595 views

GeoTools and PostGIS with ESPG:3857

I'm trying to use both PostGIS and GeoTools with the same ESPG:3857 projection, however, it looks like the projections in PostGIS and GeoTools differ. This is what I have in PostGIS: PROJCS["WGS 84 ...
2
votes
1answer
2k views

Transforming from SRID 900913 to 4326 with PostGis

I have two Postgres tables with different SRIDs, 4326, and 900913. I want to convert the latter to 4236. I first changed the SRID using: Select UpdateGeometrySRID('table', 'geomcolumn', 4326). I ...
3
votes
1answer
346 views

When trying to convert lon/lat (curved) coordinates to projected (flat) coordinates with ruby, the second (y axis) projected coords are inaccurate

So I have created a polygon using Google Earth pro. I've exported it into a kml file, which I can then parse using ruby's XML/HTTP-parsing Nokogiri gem into an array of WKT points (LinearRing) thats ...
0
votes
1answer
100 views

I have line strings in points and need to conver them to lon/lat degrees

I need to convert line strings back to latitude & longitude coordinates. Here are is an example, please keep in mind that they do NOT reference the same point. I have included the values to ...
2
votes
0answers
281 views

Geoserver - empty native SRS field

I'm converting layers from shape files to postgis with the below command: shp2pgsql -s 22175 -c -W "latin1" path/file.dbf' table_name db_name | psql -d db_name Next, I add this layer to the ...
2
votes
2answers
1k views

KML from EPSG:4326 to EPSG:900913

im trying to create KML files manually (XML format) by extracting data from a postGIS database with "geography" values in a column. But i belive i need to transform the projection of each row in the ...
0
votes
1answer
523 views

Geoserver WFS GetFeature returns no features when reprojecting PostGIS layer

I may be misunderstanding the GeoServer documents, but when accessing a GeoServer 2.2 WFS 1.1 layer, should I be able to reproject to an arbitrary SRS via the SRSNAME parameter? I'm generating a ...
11
votes
4answers
4k views

How to reproject all geometries in a PostGIS table?

I created a spatial table with SRID:4326. Now I want to change total projection to SRID:32644 into a new table. The old table should remain unchanged.
1
vote
1answer
249 views

Why is my PostGIS transformation not working?

I am using a PostGIS query to find the intersection of two streets, and then transform the results into lat/lon. The street database's current SRID is 6856, a projection I added to PostGIS myself; and ...
1
vote
1answer
135 views

Get relative north aligned point 2163 (US Equal Area)

What I'm trying to do is create a grid where the y axis is north aligned. I have a origin Lat/Lon point which is the bottom left corner of the grid and each cell should be 100 by 100 meters. So I ...
3
votes
1answer
220 views

Unexpected Result After Reprojection Attempt

I'm a member of a student team that is currently researching how to query raster information using PostGIS v2.0. Our raster's coordinate system is EPSG 2236 (NAD 83 / Florida East) and as we will be ...