Version 2.0 of PostGIS brought a heavy set of new extensions for the PostgreSQL object-relational database, adding greater support for spatial objects.
2
votes
1answer
36 views
How to connect Postgis database with/in Remote Servers…?
I am preparing a 'Web based map' application using 'Geoserver-Openlayers-Postgis'...
Now,
I am trying to connect my Postgis database(located at 10.50.110.11 location) with the following command from ...
2
votes
1answer
28 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).
...
2
votes
1answer
59 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 ...
2
votes
1answer
363 views
Can POSTGIS 2.0 be install with POSTGRES 9.2 on Ubuntu 12.04 OS at the moment?
This question is more about environment set up.
At the current moment, March 4th 2013, can POSTGIS2.0 be install with POSTGRES 9.2?
I check their website out and to my understanding it is not ...
2
votes
1answer
126 views
generate height data from DTED maps
I have 16 DTED maps of (1 degree x 1 degree). I have to generate combined height matrix of maximum 4 (1 degree x 1 degree) DTED maps in my C++ application.
Can someone suggest to me which open source ...
0
votes
1answer
23 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 ...
0
votes
1answer
78 views
How to properly use PostGIS with Maps
First time using PostGIS in an app.
Target:
- Get Heat Map of customers from address table using leaflet.js and heatmap.js
Have DB called store_dev.
Installed OSM Bright from Mapbox in it.
Have a ...
10
votes
0answers
507 views
How to publish PostGIS Rasters in Geoserver?
What is the best solution to publish postgis rasters using Geoserver?
I have spent a lot of time trying to create a Raster datasource using Image Mosaic JDBC but with no luck.
Steps performed:
1. ...
3
votes
0answers
57 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: ...
3
votes
0answers
66 views
PostGIS 2.0 st_geomfromgml using LineString fails with invalid GML representation
I am attempting to insert a geometry into a table using the st_geomfromgml function.
The GML is being sourced from a Geoserver WFS request.
The function call looks like this
...
2
votes
0answers
67 views
Are geotiffs with the embedded georeferencing information supported?
I am able to load raster data into my postrgreSQL data base however when I display in Quantum GIS the pixel height and width of the image is being translated into real world lat/lon coordinates, as a ...
2
votes
0answers
52 views
How to convert FROM Navit to PostGis or SHP?
I have a Navit BIN file which I want to use in PostGis or QGis, so I need to import it to PostGis or convert it to a shapefile. I have found a lot of information on how to convert data TO the Navit ...
1
vote
0answers
27 views
Joining layers with respective elements with PostGIS Topology
Recently I have started using PostGIS topology extension, but I have some difficulties in understanding how the structure works:
One of the key points is the use of "layer"s: as of what I understand, ...
1
vote
0answers
19 views
error in loading raster tiles on postgreSQL
I am trying to import raster data from PostGIS to GeoServer.
I follow the instructions given on this link.
...
1
vote
0answers
35 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 ...
1
vote
0answers
105 views
How to import 3D geometries from DXF, VRML or X3D into PostGIS 2
we plan to develop a webbased 3D GIS using PostGIS 2 and GeoServer with a W3DS. The architecture works fine, but i have problems to import 3D geometries into PostGIS. The geometries come from AutoCAD ...
1
vote
0answers
64 views
Renaming Columns in Geotools FeatureType
I am attempting to build a simple java program that loads shapefiles into a Postgis 2.0 database. Everything is working out great except that I would like to be able to modify the FeatureType in the ...
1
vote
0answers
39 views
given sets of vehicle passing on each edge, how to get most used vehicle to avoid transition?
I have two tables: one, the resulting table from converting osm.xml via osm2po so I can use pgRouting, and another one that contains information on what edges each public vehicle passes through ...
1
vote
0answers
49 views
blank preview image for ImageMosaicJDBC (postgis raster) layer
In geoserver, while publishing ImageMosaicJDBC layer seems no problem, the preview of this layer does not give me an meaningful overview image, only a blank image with the correct lat lon extend. Also ...
1
vote
0answers
112 views
How could I make this PostGIS query run faster?
SELECT st_band(rast, 1), st_width(rast), st_height(rast),
st_bandpixeltype(rast, 1), st_bandnodatavalue(rast, 1),
st_scalex(rast), st_scaley(rast), st_upperleftx(rast),
st_upperlefty(rast) FROM ...
1
vote
0answers
56 views
Make a thumbnail of a raster in PostGIS
I'm fiddling around trying to create a thumbnail of a fairly large (originally 27MB) raster, chunked into 64x64 blocks. I've got the following and it works, quite well, but I'm wondering if there is a ...
0
votes
0answers
16 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 ...
0
votes
0answers
35 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, ...
0
votes
0answers
57 views
ST_intersects and shortest_path to optimize routing in respect to (de-)acceleration
Is there a way to consider a more complex cost field in the PG_Routing algorithm?
I am currently trying to get more realistic routing costs. I have a map based on the German ATKIS standard with road ...
0
votes
0answers
21 views
Weird behaviour of ST_Project with PostGIS2
somehow I can't understand the results of ST_Project, but maybe this problem is just me being stupid (again):
Note:
I use geography-type here, but the results are the same for geometry.
I use a ...
0
votes
0answers
54 views
Create Polygon Overlay Handling Holes
How can I create a polygon overlay that correctly handles holes? This answer provides a method of creating a polygon overlay that does not handle holes. Can it be modified to correctly handle holes?
...
0
votes
0answers
16 views
Aggregation operation on raster files inside a raster database in postGIS Raster
I have a raster database in PostGIS Raster. I want to merge a number of raster files that are imported to the database using average to create another file. In the other words, the mean value of ...
0
votes
0answers
50 views
how to group interconnected edges inside a table?
Given a table and a random set of edges with source and target columns, how can I find out which edges connect with each other and then group them together using PostgreSQL?
0
votes
0answers
223 views
PostGIS data visualization
I have dump my data in PostGIS from shapefile successfully. I made a postgres connection through PHP and that also returning the data of other field. But the main problem is GEOM field visualization. ...
0
votes
0answers
53 views
Can't drop table with geography column
I imported shp to postgis 2.0.1 with shp2pgsql and chose to use geography instead of geometry. However, now when I try to drop the table, the pgadmin/sql console/phpPgAdmin freezes. I can't neither ...
