Version 2.0 of PostGIS brought a heavy set of new extensions for the PostgreSQL object-relational database, adding greater support for spatial objects.
0
votes
0answers
5 views
Get Complete Details Of Raster Column in the Raster Table
i'm having the geotiff files containing the details of the temperature of the specific co-ordinate value along with it.
Configuration details:
Postgresql 9.2,
Postgis 2.0,
GDAL 1.9.2.
Here my ...
3
votes
3answers
38 views
Snapping start- and end nodes of lines to other lines in PostGIS
There are plenty examples that show how to snap lines to points, but I haven't been able to find any (fast!) way of snapping the start- and end nodes of line strings to nodes of other lines.
...
0
votes
1answer
53 views
Emergency Services: How to optimize routing by measured travel time?
I would like to optimize the service areas / catchment areas for an emergency service. Therefore, I have several measurement points on the streetmap, where people have stopped the travel time from ...
3
votes
0answers
43 views
How to install PostGis on EC2 micro-instance
I tried to install PostGIS on my Amazon EC2 microinstance using sudo yum install postgis2 and got following error message:
$ sudo yum install postgis2
Loaded plugins: ...
2
votes
1answer
54 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):
...
1
vote
1answer
18 views
Getting a “java.lang.OutOfMemoryError” error while importing raster files from PostGIS to Geoserver
I am trying to import raster data from PostGIS to GeoServer.
I follow the instructions given on this link.
...
1
vote
0answers
32 views
operator does not exist: geometry <#> geometry
I'm running PostGIS 2.0 for PostGreSQL 9.2, and I have a customer who wants to know how close a provided geometry is to the nearest feature in a table. So I'm playing around with the "<->" and ...
2
votes
1answer
25 views
Are there strategies for dealing with TopologyException errors in PostGIS 2?
Are there strategies for dealing with TopologyException errors in PostGIS 2? Nearly every function I run against two geometries results in a TopologyException (e.g. ST_Intersection, ST_SymDifference).
...
0
votes
1answer
30 views
Postgis 2: Polygon/MultiPolygon in a single column
Storing MultiPolygon and Polygon features in a single column used to be as simple as not creating or removing the geometry type check constraint.
Is there a similar simple fix in PostGIS 2?
0
votes
1answer
19 views
ImageMosaic-JDBC Error
I'm trying to get postgis raster layers in geoserver-2.3.1, with postgresql-8.4, postgis-2.0 and gt-imagemosaic-jdbc-9.1.jar support. I'm going through the tutorial with a PNG raster that i have. In ...
3
votes
1answer
33 views
How can I check if a multipolygon can be represented as a simple polygon?
I have a large (30m+ records) spatial data set I have imported into a PostGIS database. I did not expect to find multipolygons in the data set, but it does have a few of them. I'd like to take a ...
0
votes
0answers
18 views
not able to import raster data through raster2pgsql [closed]
I'm new to postgis and I'm not able to get through raster2pgsql. The problem is:
I want to import a raster (.tif) file using raster2pgsql. But after running the command:
raster2pgsql -s 4326 -I -C ...
2
votes
2answers
79 views
PostGIS: Convert meters to arbitrary spatial reference units?
I'm writing a query that needs to be able to work with data of any SRID. The basic problem is very simple - I get two pieces of information:
A point (SRID = 900913)
A distance (unit = meters)
I ...
2
votes
1answer
48 views
How can I make a Postgres/PostGIS ST_Distance_sphere query more efficient?
Within Postgres/PostGIS I have written an SQL query to get the closest distance for each element within a point coordinate table from a polyline table. The query comes back and works correctly, but ...
0
votes
0answers
31 views
tinyows failing to connect to postgresql - Ident authentication failed for user “postgres”
I'm getting the above error on a new and local tinyows installation on Centos 6. Postgresql 9.2, PostGIS 2.0.
I can connect to PostGreSQL locally and from my LAN using several other methods (psql, ...
