PostgreSQL is an open source object-relational database system.
11
votes
0answers
516 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
53 views
Where can I find PostGIS error codes?
Using ST_Contains in where clause sometimes gives me error messages like
ERROR: GEOSContains: TopologyException: side location conflict at 37.3706 55.7882
For now I can't guarantee validity for ...
3
votes
0answers
180 views
How to save table from PostgreSQL to MapInfo File?
I have two tables:
1 with geometry in WGS
2 with geometry in Local System
I tried this:
ogr2ogr -f "MapInfo File" output2.tab PG:"host=localhost user=postgres password=123456 dbname=postgis" -sql ...
3
votes
0answers
266 views
How can I properly add PostGIS data into MapGuide Maestro?
I am having trouble connecting a PostGIS database to MapGuide Maestro. Actually, I have added the PostGIS data into Maestro, but when I click to validate the layer it shows an error message:
...
2
votes
0answers
24 views
Clustering table on geohash index and geohash ordered table
I wonder if there could be a performance gain to re organize the rows in a table by Geohash and then CLUSTER this table on the Geohash index of the geometries.
CREATE TEMPORARY TABLE tmptbl AS
SELECT ...
2
votes
0answers
47 views
Installing knn on PostgreSQL for windows
I am trying to install the extension KNN for clustering as an extension on my PostgreSQL database.
I have downloaded the file
http://www.pgxn.org/tag/analysis
I found instructions on how to ...
2
votes
0answers
50 views
assign_vertex_id：problems when creating the node ids
Before using pgrouting, I have to create the node ids.
I loaded my polyline layer into PostGIS Manager：
I type this in SQL query：
select assign_vertex_id('split_4', 800, 'geom', 'gid')
But as ...
2
votes
0answers
49 views
Get Multiple Shortest Path using PgRouting in One Query
I am trying to get multiple shortest path using A* Algorithm available in PgRouting.
I referred Solution given by UnderDark ( Link of the Stakoverflow Post ) . But it is not giving me proper Output.
...
2
votes
0answers
85 views
Adding polygon to existing database column
I've built a database with postgreSQL with a few geometry columns.
When I add some data to my non-geometry columns, I can see them in QGIS when I connect to my DB using postgis. Now, I want to add ...
2
votes
0answers
55 views
Pgrouting can't find postgresql (on Mac)
I've installed both postgreSQL 9.0 and postgreSQL 9.1 on my mac, using binaries from http://www.kyngchaos.com. I also have postgis 1.5 installed.
I tried to install pgrouting, again using binaries ...
2
votes
0answers
123 views
Projecting PostGIS in Openlayers
I have a layer(base layer) with MultiLineString Geometries and now I need to project the layers(overlays) in the base layer from PostGIS using OpenLayers.
However, I got an idea how to project table ...
2
votes
0answers
108 views
Is there a way to start the route on pgrouting from a coordinate that is not a node?
After execute all steps from this pgRouting tutorial, now I have a map that creates and displays routes, but as the routing methods rely on parameters representing vertex Ids that was created using ...
2
votes
0answers
127 views
Postgresql Query Plugins Not Returning Results in QGIS
I'm using the Fishnet function as described here to create a grid.
If I use the following SQL to call the function to position a grid where I want it (I'm using NZGD2000 SRID = 2193) the query ...
2
votes
0answers
225 views
How to solve postgreSQL error when using QGIS Cloud plugin?
I created a qgis cloud account and installed the plugin. When I attempted to Upload Data using the plugin, I got the following error:
postgreSQL exception:
ERROR: "MD5" authentication with pgpool ...
1
vote
0answers
20 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
54 views
Creating polygons for a choropleth map using PostGIS
I have a grid of points, each with a value to it as shown in the image below. The data was retrieved from PostGIS and rendered in Quantum GIS. The final result should be a polygons of a choropleth map ...
1
vote
0answers
65 views
I can't connect QGIS with postgresql
I can create a connection to the database in qgis and the test connection is successful. However when I actually connect to the database to export shape files I get the following error:
the ...
1
vote
0answers
143 views
Is there workaround for very slow ArcSDE 10.1 editing
I'm suffering from very slow editing in SDE from an Arcgis engine application, the SDE database is in local so there's no network issues. but i still ignore the reasons neither how to solve this ...
1
vote
0answers
44 views
New geographical point won't show on map
I did recently ask a question about how to add a new point to a PostGIS table. Now when I've got the new point in the table it should be visible on my map, but it isn't.
I'm using Mapnik together ...
1
vote
0answers
31 views
Do I need to deal with warnings about row count and spatial index to use pgRouting?
After read this nice post from underdark A Beginner’s Guide to pgRouting, although I still have some little problems, I think I can begin the "Creating a routable road network" stage right now.
I got ...
1
vote
0answers
102 views
Function for Selecting Points in a Polygon
I've been banging on this for a few hours, but since I'm relatively new to PostgreSQL and PostGIS, I can't find the solution. I'm trying to create a stored procedure (function) which will return all ...
1
vote
0answers
55 views
How can I snap 2 lines in QGIS so the st_distance between them is 0?
Sometimes when I snap the ends of 2 LineStrings together and I check the st_distance between those endpoints I get a value in the order of 1.1E-10 while at the same time when I check for equality of ...
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
116 views
pgrouting shortest path result in wrong order
I am using the Dijkstra shortest path algorithm to plot a route between two points using the latest version of pgrouting in postgresql 9.1 with postGIS 2.0.1.
I am able to get a correct result ...
1
vote
0answers
68 views
Convert native box to geometry
I have an old table that contains bounding boxes of lat long coordinates in a "box" type.
How do I convert them to PostGIS geometry ?
I tried using ...
1
vote
0answers
114 views
How do I find the pgAdmin connection parameters?
I need to create a connection from arcmap to pgadmin using a python module because of an arcpy script, but I am unsure of how to get the pgadmin connection parameters. I think it may be some kind of ...
1
vote
0answers
82 views
Calculating spaces between roads from PostGIS database
Is it possible to calculate the spaces between the roads using a select statement in a PostGIS/PostGre Database? I tried using some combinations of the predefined functions as ST_Intersects & ...
1
vote
0answers
120 views
How to view error feedback in qgis when testing connection to postgres database?
Using qgis 1.8 on Ubuntu 10.04 with Postgres 8.4.13
I am creating a new (and my first) Postgresql connection in qgis.
I can connect to the user and the db using the pgsql client.
...
1
vote
0answers
132 views
Qgis Plugin development with postgres data
can someone help me with initial developing on qgis plugin that displays postgres data table on a QTTableView or QTTableWidget?
So far:
I can connect to database using psycopg2 or using ...
1
vote
0answers
56 views
Database has duplicate values after running pgrouting
I am a newbie with postgresql and sql statements so maybe it is a trivial question, I'm sorry for that.
I am working on a postgis database and try to use the pgrouting function. My goal is to store ...
1
vote
0answers
80 views
Is this pgRouting perfomance acceptable for my tiny server?
I'm testing pgrouting functions in a tiny server with 2GB of RAM and a dual core processor.
I wrote a program that create client process and they connect to the server in a specific hour to perform a ...
1
vote
0answers
190 views
add description to a new polygon and save -> postgres + geoserver + openlayers -> wfs-t insert
actually it is possible to draw a new polygon with openlayers and save it over WFS-T-insert (geoserver wfs-t 1.1.0) in my postgres-db:
var save = new OpenLayers.Control.Button({
title: "Save ...
1
vote
0answers
341 views
Geometry contains non-closed polygon: GeoServer output from PostGIS
I have imported a shp file using PostGIS shapefile loader plugin for pgAdmin3. The geometry type of the table created is MultiPolygon. I have cross checked the same using the following query.
SELECT ...
1
vote
0answers
203 views
Live KML Feeds - From the Ground Up, How Would You Build It and Why?
I found the "Live KML from PostGIS to Google Earth" post very informative but a bit daunting for someone new to the open source world of products like PostGIS and GeoServer.
If I am building the ...
1
vote
0answers
173 views
OSM Database created: now what happens?
I imported an OSM file into a Postgres DB using the Osmosis tool. Now, I need to extract some data but I can't find any schema description (I'm really a newbie in GIS). Where can I find it? Do you ...
1
vote
0answers
84 views
Getting started with storing LoST and GML searching
I am working on a logging and search database application.
The application will receive event records containing XML LoST values (RFC5222 Location-To-Service-Translation). These records will be ...
0
votes
0answers
13 views
Which all columns should I add in postgresql table so that it stores elevation values and displays them in Geoserver?
I am using geoserver and postgresql. I imported raster (.tif) file to postgresql using raster2pgsql. The file thus imported creates a new table in postgresql. But when that file is previewed in ...
0
votes
0answers
30 views
Is QGIS OGR plug-in data provider (based on Postgres) limited to 500 features in layer?
I developed a plug-in based on OGR. It works fine but when I want to add a vector data (using my plug-in) I get 1449 features (with 76 columns) in my layer. Then I select this layer and load it.
...
0
votes
0answers
23 views
How to use for loop to make driving_distance more efficiently？
I use driving_distance function in pgRouting to work with my river network. There are 159 nodes in my river network, and I want to get the distance between all of the nodes. This is my code so far：
...
0
votes
0answers
39 views
Shooting star algorithm in postgres 8.4 and postgis1.4 showing fatal error and remaining are working fine
When I try to run this shooting star algorithm, the postgis suddenly loosing connection to postgres and showing error no connection to server
SELECT * FROM shortest_path_shooting_star('
SELECT gid ...
0
votes
0answers
13 views
Can driving_distance return all sets of distance from different starting points at one time？
I'm now using the extension of pgRouting, driving_distance, to search for the distance along the river system：
In the figure, the starting point is 3, but I want to get the distance starting from ...
0
votes
0answers
17 views
driving_distance does not return all sets of distance
As title, I am working with pgRouting, trying to get the distance matrix along the river system.
I use driving_distance function and it seems like I am getting what I want：
But when I check the ...
0
votes
0answers
61 views
QGIS SPIT errors loading shapefile into PostGIS
With QGIS 1.8 on Windows 7, I just installed PostgreSQL / PostGIS and tried to load my first data into it, a shapefile using SPIT, but failed:
ERROR: Geometry type (Polygon) does not match column ...
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
52 views
QGIS cannot view raster loaded to PostGIS through raster2pgsql
I tried to load a raster GeoTIFF image to a PostGIS database using "raster2pgsql" following the OpenGeo Suite Manual. The command I used is:
C:\>raster2pgsql -s 4283 -I -C -M "C:\Program ...
0
votes
0answers
40 views
Table for feature layer in PostGIS database cannot be published and enabled on GeoServer
I have tried to publish a table for feature layer in a PostGIS database to GeoServer 2.2.5. The layer was added and published. However, the layer has got a yellow exclamation mark in the "Enabled?" ...
0
votes
0answers
64 views
geoserver PointStacker
I'm trying to implement a clustering solution using geoserver (version 2.3.0 ), for this I'm using the Rendering Transformation Point Stacker and the clustering itself works fine.
However I have ...
0
votes
0answers
99 views
How to pass parameter postgres sql to Map file - java
I am new to GIS. I want to pass a parameter map file dynamically. Or how map file fetches the data from the database. I can't find out the solution. This is my map script.
LAYER
CLASSITEM ...
0
votes
0answers
47 views
How to Draw a Point on a Geotiff in Android and Put it in the Postgresql Database?
I need to:
Open a geotiff in my phone (android) {offline)
Draw a point
Get it's coordinates (X,Y)
Fill in the data attributes (name of the point, ...)
Put the data and the coordinates in my ...
0
votes
0answers
133 views
ajax not working with postgresql
I know is a silly question but I thought I should ask since you guys know more about postgresql. Sorry for being analytical, but I think its the only way to make my question clear.
I'm using ...
