PostgreSQL is an open source object-relational database system.
4
votes
2answers
758 views
Is Shooting Star broken in PGRouting 1.05?
I'm using pgrouting DLL 1.05 with postgresql 9.1.
All required function installed.
Astar and Dijkstra work fine with sample data but "SHOOTING STAR" is not considering "reverse_cost".
Also if i try ...
23
votes
5answers
5k views
ArcGIS and PostGIS
Has anyone successfully used PostgreSQL with PostGIS successfully? I am a semi-experienced ArcGIS user and want to build out a database and connect it to ArcCatalog. I've scoured the internet for ...
4
votes
4answers
1k views
Calculate distance of point from an arc/polyline
Using Postgres/PostGIS, I am trying to query the database for the closest arc to a particular GPS point. Each Arc is made up of two nodes that are GPS points on a map. Is there a way I could query ...
7
votes
2answers
7k views
How to insert a point into postgis?
I have created one table in my Postgis. But I can not insert point. I do not know what's wrong with my query?
CREATE TABLE app (
p_id INTEGER PRIMARY KEY
);
SELECT ...
6
votes
1answer
816 views
Postgresql for Qgis and Arcgis - What to do/What not to do
Is it possible to use postgresql with QGIS and ArcGIS? One database for different clients. Is it anything that I have worry or any problems to use the DBMS from two different software? I know that I ...
29
votes
7answers
2k views
Best practices for PostGIS production environments?
What PostGIS documentation have you come across that has been helpful when tuning PostGIS for a production environment?
I would like to get together with my DBA to setup a Postgresql/PostGIS ...
13
votes
3answers
2k views
In PostGIS is it possible to create a View with a unique ID?
When I create a view in PostGIS is there any way to add a unique ID to that view? Just like the "gid" field in any other PostGIS table?
Edit: Sorry I should have included this in the original post. I ...
8
votes
2answers
1k views
How do you display related records in QGIS?
Coming from an esri background I have always used relationship classes in a gdb to display records related to a feature. Eg. Relate 1 survey point to many documents, photos etc.
Does any one know how ...
13
votes
2answers
1k views
Identifying road intersections using PostGIS
I'm trying to identify where roads intersect each other, and to make a point at this intersection, with the number of roads that form the intersection listed.
I was wondering if there was some way ...
5
votes
1answer
2k views
How to create a tables from existing tables (applying new schemas) in postgis DB?
I have a table that is geospatially enabled; that contain world borders. I want to break it down to different schemas (global, europe etc..) . My thought is to use use something that looks like this:
...
4
votes
1answer
2k views
How to import a raster into PostGIS?
I'm trying to follow the instructions here to load a raster into a PostGIS database:
python raster2pgsql.py -s 4269 -I -r *.tif -F myschema.demelevation -o elev.sql
I understand that I replace * ...
5
votes
2answers
1k views
GDAL Python bindings not picking up OGR PostgreSQL driver
I have a windows server (Microsoft Windows Server 2003) with:
Python 2.7,
PostgreSQL 9.04-1,
GDAL 1.8.1 (installed from the windows installer
(gdal-18-1500-core.msi) hosted at
...
4
votes
1answer
1k views
Loading a raster using QGIS into a PostGIS2.0 enabled database
Following on from my attempt to install a postgresql 9.1 db with postgis 2.0 on windows 7, I am trying to figure out how to load a raster. I have successfully loaded a shapefile, and am trying to do ...
5
votes
1answer
666 views
How to perform a spatial join of point and polygon layers in PostGIS?
I have a point dataset representing households that I want to associate with a parcel layer (i.e. assign its parcel_id). With ArcMap, I could spatially join the polygons to the points and specify that ...
4
votes
3answers
65 views
GIS QUERY on point and buffer
I have a point table and the buffer geometry is created around the point.
I have defined the if the point is within the buffer_distance then its value is =1
and if it is outside the buffer its value ...
3
votes
0answers
261 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
1answer
137 views
3d terrain from data in postgres
I am quite new to arcgis and I would like to create a 3d terrain. Now I have a postgresSQL table containing a list of points with their geometry data and the Z value for each point.
What I would ...
2
votes
1answer
163 views
update tables data dynamically
Can u help me in creating a trigger and function so that every time i change the flag in table A the buffer distance should get changed and also its geometry field also , ie the polygon area?
I have ...
2
votes
2answers
330 views
Why does Mapserver throw “msQueryByPoint(): Search returned no results.”?
I have been trying to configure a QUERY using mapserver. Below is the mapfile:
MAP
NAME "Fourth"
UNITS dd
EXTENT 58.206740 5.756104 ...
11
votes
1answer
407 views
Nearest Neighbor Grouped Selection in QGIS
OK - so I have an interesting problem I am trying to solve. I have a list containing over 100,000 points in lat/long format which I have imported into qgis.
Now, what I am trying to do here is group ...
13
votes
3answers
2k views
How can I optimize pgrouting for speed?
I am using pgrouting on a postgis database created through osm2pgrouting. It performs very good on a limited dataset (3.5k ways, all shortest path A* searches < 20 ms).
However since I have ...
4
votes
3answers
754 views
Developing Web Application For Map
I have huge data of maps usually most of the table are co-ordinates and the other are raster maps stored in SQL server 2008 and PostGres Server. I am using desktop application to analyse the data. ...
9
votes
1answer
998 views
How to change the SRID of exisisting data in PostGIS?
While importing my shapefile data to PostGIS, I did not select the proper Projection.
How do I now change the SRID of the data, without transforming the Coordinates?
4
votes
3answers
1k views
Can I connect (& edit) to a postgresql database with arcgis without arcSDE?
After trying in vein to get spatialkit and zgis working with my postgresql database in arcgis 9.3 and 10 , I was wondering if anyone has had any luck with these products.
My postgresql database has ...
11
votes
5answers
3k views
How to use ST_Intersection?
Here's a quick summary about what I'm trying to do: I have 3 tables in Postgres, 'a' and 'b', each have a Polygon column, and 'c' has a Point column. What I'm trying to do here is to get the ...
5
votes
4answers
1k views
Will PostgreSQL 9 work with ArcGIS 10?
I realize it is not listed as a supported Database. I am interested to see if anyone has tried to install and use it.
4
votes
3answers
935 views
How to make pgRouting faster?
I have table network which has about 2 million records (only 3 countries in Europe). When I run Shorthest-path it is very slow, it takes 3 min to take records only.
I tried with ...
3
votes
2answers
1k views
How to connect to Postgres with QGIS?
Oddly, it should be simple, but I can't connect to a local PostGIS database. My installation is with Mac OS X (10.8), Postgres.app (in doc it's said to hava PostGIS included) and Quantum GIS 1.8.
...
2
votes
1answer
3k views
How to install PostgreSQL 9.2 with PostGIS 2.0 on Ubuntu 11.10 (or higher)?
I have read this question: Install PostGIS v2 for PostgreSQL v9.2, but it didn't resolve my problem.
I added the PostgreSQL backports PPA and installed the postgresql-9.2 package, but there is no ...
7
votes
3answers
191 views
Why doesn't pgRouting return the best path?
Let the next portion of a graph:
When I use the function shortest_path between the points A and B, I got the blue path. Why does this happen?
7
votes
2answers
261 views
How to catch PostgreSQL/PostGIS errors in GDAL/OGR Python bindings?
Is it possible to catch PostgreSQL output error messages in OGR after a query has failed?
For example
conn.ExecuteSQL('SELECT * FROM non_existing_table;')
In Postgres this returns an error ...
6
votes
1answer
334 views
Data visualization and maintenance tool
Background
Looking to leverage an existing GIS system for exploring organizational data.
Architecture
The following figure represents a high-level overview of the system's desired features:
The ...
6
votes
3answers
1k views
How to load OSM data into PostGIS preserving all Tags?
I am new to the field of GIS and am trying to view source tags in OSM. I have downloaded the shapefiles from http://downloads.cloudmade.com and have loaded them into Postgres. When I view the data, I ...
6
votes
2answers
2k views
Creating spatial tables with PostGIS
In the PostGIS documentation it says that there are two steps to creating a spatial table with SQL:
Create a normal non-spatial table.
Add a spatial column to the table using the OpenGIS ...
5
votes
2answers
1k views
How to get multiple shortest paths with PgRouting in one query?
I want to run shortest path algorithm on multiple source&target pairs at once and get a result as a table and process it then.
How do I do this? This query does not work:
SELECT a.source, ...
4
votes
2answers
128 views
Which spatial DBMS should I select?
I found there are a number of RDMS have the spatial capability e.g. mysql, postgreSQL
I considering which I should go forward!
I would like to store the lat lon coord from the tracker to the db ...
3
votes
2answers
445 views
Merging polygons that intersect by more than a specified amount
I am working with a dataset that contains a subset of property boundaries in a local government area, thus my dataset is made up of several thousand properties but not all are touching. Since it is a ...
3
votes
1answer
797 views
How do I perform a proximity search with Postgis?
OK, so I downloaded the Geonames database (cities1000) and wrote a small Ruby program to import them into my table (geo_cities). I then added geography column called geog.
So after all of that, I ...
2
votes
2answers
101 views
What does 'DBMS table not found' message mean?
I have a plain postgressql table (version 8.2). I am trying to connect to it to it from ArcGIS desktop 10.0, and use as a query layer, as given in this document: ...
1
vote
2answers
799 views
Adding shapefiles to PostGIS database
I was able to create a Postgresql database and then I executed,
createlang plpgsql geospecies
psql -d geospecies -f postgis.sql
psql -d geospecies -f spatial_ref_sys.sql
So now can I directly ...
6
votes
1answer
718 views
QGIS WKT Raster Plugin error, what does this mean?
I have been playing with the WKT Raster plugin. I have installed the WKT Raster experimental binaries in PostGIS successfully and followed the instructions in the read me to the letter.
When i am in ...
4
votes
1answer
109 views
Is there a way to select what to import from planet-latest.osm.bz2 to database?
Is there a way to select what to import from planet-latest.osm.bz2 to database?
I want to do something like :
osm2pgsql ... --place='city' --admin_level='2'
My goal is to use only cities and ...
4
votes
3answers
2k views
Arcgis server not showing map service
I have a map service enabled in my server and have kml and wms as well as mapping and feature access capabilities turned on.
I can view the wms in qgis, I can veiw the kml in google earth. However ...
3
votes
1answer
846 views
Postgis 2.0 - public.geometry_columns view does not contain correct info for views
We have recently updated our database to Postgis 2.0.
In our system we used to create views for tables containing a geometry column. After creating the view we also manually updated the ...
3
votes
1answer
165 views
How to connect a PyQGIS plugin with Postgres?
I have some questions for you:
I created a python-plugin in QGIS,
then I created a Qt gui fom my plugin
and at last I created a Postgres DB
now I need to make a connection between Qt-gui and ...
3
votes
1answer
766 views
How to get the coordinate system from a PostGIS database?
My question is probably amazinlgy stupid, but I can't find the answer myself.
I would like to extract from a database the latitude and longitude of points. For now, I'm getting x(the_geom) and ...
3
votes
3answers
2k views
How to fix performance problem in PostGIS ST_Intersects?
I'm a newbie in postgis and I have a problem in query performance.
This my query:
SELECT DISTINCT ON (userid) userid ,ST_AsText(position), timestamp
FROM table1
WHERE ST_Intersects ( ...
2
votes
1answer
261 views
Error creating a spatial database. ERROR : could not load library “/usr/pgsql-9.1/lib/rtpostgis-2.0.so”
I am running PostgreSQL 9.1 with Postgis 2.0 on Fedora 15.
When trying to install the raster support,
psql -d mydb -f rtpostgis.sql -v ON_ERROR_STOP=1
I get the following error
...
2
votes
1answer
237 views
Error while rendering a layer from postgresql in mapserver
I got a point layer into QGIS from postgresql database. After this I used a plugin to export it to a map file.After exporting the following is the starting of the map file.
NAME "QGIS-MAP"
# Map ...
2
votes
2answers
1k views
Problem when calculating longitude and latitude for points
I have a PostGIS database with SRID=900913 (Google Mercator) and I would like to know the latitude and longitude of points.
I use this command:
ST_X(ST_TRANSFORM(the_geom,4283))
Following what is ...
