PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

7
votes
2answers
553 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 ...
3
votes
1answer
734 views

How to relate Non-Spatial table to Spatial table in two different Postgis DBs?

I need to relate a Non-spatial table to Spatial table, but both are in different database. Spatial_table(dbname:dist) gid district_name district_code geom Non_Spatial(dbname:census) ID ...
3
votes
0answers
536 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: ...
7
votes
1answer
2k views

Using PostgreSQL with QGIS and ArcGIS?

Is it possible to use PostgreSQL with QGIS and ArcGIS? i.e. 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 ...
0
votes
1answer
422 views

To get attribute data of polygon layer by giving Lat/Lon

Is anyone having an idea about how to get attribute data of a polygon layer by giving Coordinates with in that polygon. Here i have tried with these codes.. SELECT * FROM kar_bbmp_198 WHERE ...
2
votes
1answer
273 views

Direct DBMS sql queries and ArcSDE geodatabase

i want to make updates from Arcobjects on several tables stored on a ArcSDE 10.1 versionned geodatabase based on Postgresql 9.0.5 , none of these update require spatial data , and making these updates ...
3
votes
2answers
649 views

PostGIS: incorrect interpretation of a polygon that intersects the 180th meridian

I try to find out all geopoints which intersect the polygon set as a parameter. The problem is when I pass polygon that roughly covers an area of Bering Strait (nearby 180 longitude): So I use the ...
0
votes
0answers
549 views

Implementing custom (Vincenty/Haversine formula) functions for MySQL vs Using PostGIS?

I currently am using MySQL for all of my relational data. I have hit a crossroads with geo calculations. Since, MySQL does not have good support for spatial functions, I am contemplating on using ...
3
votes
2answers
627 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 ...
6
votes
1answer
4k views

Connect to Postgresql ArcSDE 10.1

I cannot connect to postgresql 9.0.5 with ArcSDE 10.1, using ArcCatalog 10.1 on Win 7 professional 64 bit. I followed the steps described here, and installed the Pg-Agent from Stack builder. When I ...
5
votes
5answers
507 views

Improve performances on distance coverage routing - PostgreSQL

I have to create layers of land coverage from one point to anywhere around on a given street network for a given distance (ex: FROM house, DISTANCE 30000m) An important factor to understand; I need ...
4
votes
2answers
829 views

Why does ST_Area(g.geom) + ST_Area(p.geom) - ST_Area(ST_Union(g.geom,p.geom)) produce negative result when using ST_Overlaps(g.geom, p.geom) = true?

I have two set of shape data. Let's say file gov.shp contains list of post codes and their boundaries. File post.shp contains list of government area name and their boundaries. I want to find out the ...
7
votes
1answer
122 views

Finding similar trips in a database

I have a trips table and a bus_stops table. The trips table has a from_stop_id and a to_stop_id. The bus_stops table has lat and lng information for each bus stop. How can I order the trips in ...
2
votes
1answer
183 views

Postgis nested query trouble

I am having difficulty writing a nested postgis query. I have a single table from which I need to create a view in PostgreSQL. I have created the view with the following command create view ...
8
votes
1answer
958 views

PostGIS - Calculate progressive distance between points on a GPX path

I am attempting to build an elevation profile using PostGIS-PostgreSQL only. I have imported GPX data in my PostGis database, so now I have a table full of the GPS coordinates of the track and the ...
0
votes
1answer
324 views

one row is discarded while importing shapefile into postgres

Please help me in following issue. I need to import a polyline shapefile into Postgres9.1 through shp2pgsql command.When i did like this, i got an error as "NOTICE: CREATE TABLE will create ...
1
vote
0answers
371 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 ...
5
votes
2answers
379 views

How to put 20K points on a map

I have an sqlite 3 database with 20K entries each of which has lat long data and I wanted to create a layer from that data. From what I have read I need to import it into a postrgres DB but I'm not ...
2
votes
1answer
959 views

pgRouting: unable to execute routing_core.sql

I'm unable to execute the routing_core.sql, receiving following error. I'm using pgAdmin III, Windows 7, PostgreSQL 9.1, PostGIS 2.0. ERROR: could not load library "C:/Program ...
1
vote
2answers
524 views

Geocoding like Google - how to do this?

I have Postgre database with network table that contains country, street name, numbers from left – to left, numbers from right-to right. I finished geocoding function to use like this: user fills 3 ...
5
votes
1answer
595 views

Advice on ideal server specifications

I am looking for your thoughts on ideal server specifications for a moderately sized habitat mapping project. My current server is about to reach its storage capacity, so I am researching buying a ...
1
vote
1answer
798 views

Create closest point on multilinestring to use in shortest_path()

I am working a routing based application where I need to create a route between two points of interest. The problem which I am facing occurs after calculating network topology using ...
0
votes
3answers
4k views

Get geometry from coordinates

I have a table with geometry column called point, saved in SRID 4326. I want to get the geometry by its coordinates, but something didn't work. I suspect database configuration or something. Here is ...
1
vote
4answers
2k views

Joining 2 tables to create layer in Geoserver with MultiPolygon and Point data types

I got problem when using the SQL View function. My objective is to create layer in geoserver from joining 2 tables. I have 2 tables, table_a: Table "public.table_a" ...
0
votes
1answer
322 views

How to use ST_Length?

I want to calculate the lenght of the line inside the polygon. If I do this: SELECT ST_Length(ST_Intersection(ST_Transform('SRID=3035;LINESTRING(4000000 3000000, ...
2
votes
2answers
1k views

Why am I unable to publish a postgis layer to geoserver?

I left arcgis and microsoft sql and now I am trying to connect Qgis+PostgreSQL (PostGIS) + GeoServer. I've brought my postgis database to the server, created a "store". And now I'm trying to publish ...
10
votes
1answer
612 views

How to get the length of a line inside a polygon

How can I get the length (brown marked part) of the "Road 7" inside the red polygon? My start: SELECT ST_Length(way) FROM lines WHERE road = "Road 7" AND ST_Intersects(line, polygon)? With that, ...
6
votes
3answers
2k views

Direct connecting to PostgreSQL from ArcGIS Desktop? [duplicate]

I am trying to connect to Postgresql database that I just installed on my server machine. As instructed by Esri I have download from postgres and installed psqlodbc. However, when I tried to add the ...
4
votes
2answers
2k views

Using PHP with a web application?

I have been working on creating a web mapping application using ArcServer 10 and the JavaScript API. Recently I was told that queries need to be run using PHP due to prior work by another team. The ...
2
votes
3answers
491 views

How to pull lat/lng from a map canvas and update a database

So if i want to pull out lat/lngs after user clicks on a map canvas (lat/lngs are pulled using any javascript API (leaflet, wax etc.) and add this to a postgresql database using a query, how do i do ...
6
votes
2answers
2k views

Can we direct connect to PostgresSQL without ArcSDE

I have postgreSQL installed on my machine.My machine already has ArcGIS 10. No Sde installed. Can we create geodatabase in PostgreSQL with out installing ArcSDE? Jay Cummins is right. I am intended ...
4
votes
2answers
737 views

Unable to create a geometric network in a PostgreSQL Spatial Database Connection

I've created in ArcCatalog a Spatial Database Connection to an PostgreSQL database server. I've imported there all my data (from a local hard drive) and now I want to edit them. But apparently I ...
6
votes
2answers
386 views

Do large vertex counts cause performance issues?

I have a table of several thousand tuples - each tuple has a geometry column. The problem is, these geometries have a large vertex count. The max vertex count is 400, while the average is 200. ...
1
vote
1answer
193 views

Interpreting the geom_way in the table created using osm2po [duplicate]

Possible Duplicate: Issues while plotting the results of pgRouting shortest path I am trying to actually figure out what this column exactly represents and how to use that in my case. I ...
0
votes
1answer
318 views

How to get points in bounding box by degrees for map

I have some concerns about working of BOX3D PostGIS function. I tried to find places in square -158.721365889063 66.09275164148659, 154.608712235937 52.56807548751039(degrees). But this where ...
4
votes
1answer
278 views

How to update attribute values of points outside an area?

I have two datasets in PostGIS 1.5 (on Postgres 9.1) one of polygons and one of points. I am hoping to create a SQL command that will select all of the points in a dataset that are not within of the ...
1
vote
1answer
122 views

How to select data inside a tile?

I have an OpenStreetMap PostGIS database and would like to select specific data (for example all shops) of each tile (on a defined zoomlevel) on the planet. Is this possible to achieve and if yes, ...
1
vote
0answers
865 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 ...
2
votes
3answers
395 views

PgRouting routing algorithm from start to end via nodes with restrictions

I have the following situation: I want to find the shortest route from A to B through nodes (C,D,E, etc.) with turn directions and road type filtering. Is there a way to accomplish this using ...
8
votes
1answer
4k views

How to create a table 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: ...
2
votes
4answers
510 views

Any pgrouting enabled hosting providers?

I am really interested if any of you know about a hosting provider that offers postgis & pgrouting pre-installed? If not, can I just go ahead and purchase a linode hosting account and do all the ...
3
votes
3answers
562 views

Which open source software to create desktop interface for Geo-processing tools?

I want to create an desktop interface to create geo-processing tool and that to using Open source GIS software. I will be using Postgresql and postgis too to save and retrieve data for operations. I ...
5
votes
1answer
731 views

How to find the two furthest points between a group of points?

I have a table with 20000 records and with those columns Shop, longitude, latitude, geom I would like to find a way to find the pair of ths farthest shops between a selection of shops For example we ...
1
vote
1answer
158 views

Is it possible to use assign_vertex_id() POLYGONs?

I'm trying to use pgrouting in order to create a graphe and I have two questions : Is it possible to use the function assign_vertex_id() with a POLYGON geometry type? I always have the following ...
-1
votes
0answers
46 views

Determine the Closest road to a GPS point [duplicate]

Possible Duplicate: Calculate distance of point from an arc/polyline I have been trying to find the road to which a GPS point is closest to. I have a postGIS database which i loaded with ...
2
votes
1answer
469 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 ...
2
votes
1answer
436 views

osm2pgsql finishes processing without creating vertices_tmp table

I am using postgresql 9.1 database with posgis installed. I also have pgroute installed on same database. I am trying to use osm2pgsql tool to import data for routing. But osm2pgsql tool finishes ...
3
votes
2answers
769 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 ...
4
votes
4answers
3k 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 ...
1
vote
1answer
4k views

Google Maps MarkerClusterer - Remove all clusters

So, I have a PostGreSQL DB with 317 datapoints - all spatially enabled through PostGIS. I have queried this using PHP as GeoJSON and overlaid it on Google Maps (using a converting routine). I have ...