PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

0
votes
1answer
57 views

PostGIS select sites within buffer

I have a WMS query (GeoServer) that returns info from my layer into a popup in Leaflet.JS.However I was wondering how would do this outside of leaflet, i.e. on a standard html/php page. I assume I ...
2
votes
1answer
77 views

Snapping points to nearest road

I have a small table of 10 cities (in one table) that I am snapping to the nearest road (in another table) with the following select and storing the table snapped_cities: Select b.id, ...
1
vote
0answers
25 views

What is the best way to manage permissions as root installing postgresql and postgis?

I've encountered an issue numerous times where I lock myself out of my postgres installation as a result of modifying my pg_hba.conf file and therefore screw up my postgres installation because I ...
1
vote
0answers
93 views

Is the postgis layer option in qgis 2.0.1 Dufour two way? Was the spit plugin built in?

I am trying to install postgresql with postgis on a remotely accessed terminal only installation of ubuntu 12.04 that I want to use to connect to qgis 2.0.1 and hopefully have a two way transfer ...
1
vote
2answers
468 views

Postgis shapefile loader 2.1 error: dbf file can not be opened

The .shp, .dbf and the rest of files are fine, I open them in QGIS, AGOL with no problem. In fact, I've tried 3 different layers, and get always the same error. Anyone can please help, as I really ...
1
vote
1answer
40 views

Transform an Irish grid reference (29903) into UK grid reference (27700) on insert

I have an insert script to input several hundred points, however some of the points use the Irish Grid Reference system. I have separated these out however was unsure how to convert or transform? ...
7
votes
1answer
400 views

Materialized View Does Not Appear In Geometry_Columns View

I have defined a materialized view in a PostGIS 2.1-enabled database running PostgreSQL 9.3.1: CREATE MATERIALIZED VIEW canvec_data.contours_m AS SELECT contours_original.ogc_fid, ...
1
vote
2answers
127 views

Extract a LineString from LineString by two Points

I am using PostGIS2.0 and PostgreSQL9.3. I have LineString in Spatial-Ref 4326 like geom:= ST_GEOMETRYFROMTEXT('LINESTRING(60.7014631515719 56.8441322356241,60.7023117507097 ...
2
votes
3answers
261 views

How to access qgis, postgis, etc in ubuntu through Amazon AWS

I'm new to programming; however i have been able to read and research the programs i need to set-up for a GIS system. I chose to use Geoserver (as WMS) Postgresql, postgis, Qgis and Openlayers. I am ...
2
votes
1answer
508 views

Problem with loading OSM planet into PostgreSQL

I try download OSM planet into PostgreSQL database. I do all steps from instruction http://switch2osm.org/serving-tiles/manually-building-a-tile-server-12-04/ I also modify string "kernel.shmmax" ...
2
votes
2answers
414 views

pgrouting 2.0 package for postgresql 9.3

I'm trying to install pgrouting 2.0 on a postgresql 9.3 database (with postgis 2.1). Are there any packages on ubuntu 12.04 or do I have to install from source? Is postgres 9.3 supported at all in ...
3
votes
3answers
190 views

osm2pgsql --hstore

I'm working with postgreSQL 8.$ and PostGIS and I need to import osm file to database. I tried it with utility osm2pgsql, but I have problem with hstore extension. Does anyone know how to solve this ...
3
votes
3answers
134 views

A linestring merger algorithm

I'd like to merge linestrings which touch, but do not cross. The linestrings share the same SRID and come from a PostgreSQL 9.2/PostGIS 1.5 database. Within the table I query are several line strings, ...
3
votes
0answers
47 views

Why are date vaules displaying a trailing 'Z' when layers are published with Geoserver and a PostGIS data store?

I have published various layers using Geoserver 2.2.x with a PostGIS 2.0.1 (PostgreSQL 9.1.x) data store. Fields that only have date values and not time/timestamp related values are stored as date. ...
1
vote
3answers
131 views

How to register as versioned using SDELayer?

This is the normal process using ArcCatalog : I want to automate this process using sdeLayer or any tools - does anybody have an idea as to how to do it? there is an application sdelayer ...
2
votes
0answers
105 views

Loading postgresql tables in Arcgis for Desktop 10.1

I have postgresql version 9.0.5 installed and configured. Also in my ArcGIS for Desktop 10.1 in "Add Database connection" I have my postgresql connected and I can see all the tables in it (figure1). ...
1
vote
0answers
104 views

Smoothing Lines in PostGIS

I want to smooth Lines in postgis, to be more specific, I want to smooth road data from OpenStreetMap. Basicly I thought of something like this scenario. This would be a possible road segment. I ...
0
votes
2answers
89 views

Convert the_geom to text and then transform

I have this query that returns the_geom as text. However how could I also apply a transform to the same query. I can do this separately with the second example. Though I would like to do this to all ...
4
votes
3answers
186 views

How to number polygons according to their spatial relationships?

I have, for example, this layer in postgresql (polygons): table : poly (objectid: integer, num: integer, shape: geometry) I want to enumerate the polygons from left to right and top to bottom ...
0
votes
1answer
234 views

PHP/MySQL, PostgreSQL spatial queries. Find a polygon that contains a coordinate? [closed]

I am building a non mapping javascript app and I am wanting to take a lat/long coordinate and query a MySQL table of polygons for the one that contains the point. I have looked into MySQL spatial ...
2
votes
0answers
553 views

Error when register database with ArcGIS server

I am using Arcgis 10.1(x32) and I have successfully connect postgresql(x64) as geodatabase. When I try to register database with Arcgis server 10.1(x64), I followed the instruction on the esri' ...
0
votes
2answers
88 views

Installing QGis such that it will work with the Postgres.app implementation of PostgreSQL on Mac (Lion) (open to alternative implementations)

I just got a new mac and am getting everything installed on it (postgres, postgis, qgis, grass, gdal, brew, ruby, etc) and am about to install QGis. QGis is a great tool for me, except for that with ...
1
vote
1answer
259 views

Export Postgis Geometry POINT as Label text to DXF or DGN

I really need to export, by the ogr2ogr command or similar, text information related to a geometry position from my PostgreSQL(with PostGIS) database to an AutoCAD DXF layer file or to a Microstation ...
0
votes
1answer
90 views

Problem with ArcGIS annotation

i have a problem with annotation (ok i will explain) : in database i have : parcelle : a geometry table that contain polygons personne : a table contain parcel's owners pll_personne : is the ...
1
vote
0answers
37 views

Upgrade Postgres/Postgis

I have Postgres 8.4 and postgis 1.5.3 installed on centos6. Now I need to upgrade both to postgres 9.x and postgis 2.x. Is there somewhere a good tutorial how to upgrade without removing the old ...
2
votes
0answers
154 views

Migrating from PostGIS to Oracle Spatial

We are now using a solution based on PostGIS extension of Postgresql database for various spatial queries. But we are now thinking about data security. This is why we have a plan to migrate existing ...
2
votes
1answer
119 views

PostGIS 2.0 function returns pseudo-type record rather than table

I'm writing a PL/pgSQL function to take a geography column and output a fishnet that bounds the extent of the shapes. I've tried to emulate the examples in docs and tutorials, but the function ...
2
votes
1answer
229 views

Open Failed - Attribute Column Not Found

I'm running a PostgreSQL database on my local machine and have set up an connection to it from ArcMap 10.1. I can see all of my tables in the Catalog pane. There is one table that I cannot seem to ...
1
vote
1answer
139 views

Why can't I connect to my new local PostGIS database?

I'm trying to connect to local PostGIS instance (PostgreSQL.app on mac) with QGIS 2.0, and it gives general connection errors. Connection with same parameters with other clients (psql, PGAdmin) is ok, ...
1
vote
1answer
100 views

Computing altitude from contour table - slow ST_Dwithin query

I am using PostgreSQL 9.2/PostGIS 2.0. I have a table of house addresses and a table of contour lines which are as follows: address_list house_id | geom (point, 4283) ---------+--------- 1 | ...
4
votes
1answer
236 views

How to use more than one CPU?

I'm creating a real time traffic application. I read the AVL car data from a web service and insert the records in a PostgreSQL table Then a trigger calculates the closest link and if there is a ...
2
votes
1answer
225 views

Create isochrone from multiple start points

I want to create an isochrone. For this I could use the pgr_drivingDistance function with pgRouting (http://docs.pgrouting.org/dev/src/driving_distance/doc/index.html) but it only takes one start ...
5
votes
4answers
92 views

uDig window to change between historical dates?

I'm new to uDig, but I'm experienced Java developer. I have points with temperature measurements that change overtime in SQL database. I would like to give user ability to change between historical ...
0
votes
1answer
103 views

geodatabase with multiple projection

I have a geodatabase (ESRI/PostgreSQL) I'm working in an application for digitizing : in my country we have 4 coordinate system(projection), so I'm looking for a way to switch projection or any other ...
0
votes
0answers
41 views

Solve the following error in PostGreSQL query

Hi can you explain about the following code: SELECT Count(*) FROM geonames_load; -- Strip out columns we want, and create a point geometry. CREATE TABLE geonames AS SELECT geonameid AS id, name AS ...
1
vote
0answers
236 views

Using PostGIS with Postgres.app (9.3)

I'm trying to run CREATE EXTENSION postgis; on a fresh 9.3 Postgres.app install. I get this as a return: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION ...
5
votes
2answers
220 views

How to detect duplicates and keep only one?

I've got a table with lots of points (200.000). Some of them are duplicates (not exactly but e.g. a metro station has eight entrances) and I want to keep only one of these metro entrances. I am able ...
0
votes
1answer
307 views

PostGIS upgrade 1.5->2.1 on OSX

i'm struggling updating my installation of PostgreSQL/PostGIS, from 9.1/1.5 to 9.2/2.1. I'm on OSX Mountain Lion and using the very useful ports from W. Kyngesburye. I followed the procedure : ...
0
votes
0answers
76 views

Error while executing Populate_Geometry_Columns() Postgis

I loaded data into postgis using easy loader(MAPINFO). Now when I run SELECT * FROM Populate_Geometry_Columns() I get error : WARNING: Could not convert '"SP_GEOMETRY"' in ...
0
votes
2answers
173 views

How to perform a buffer analysis in PostGIS?

Need to Implement Spatial Analysis in Postgresql. Can Any one guide me to accomplish the spatial analysis eg) 2 km buffer for road network layer.
2
votes
2answers
234 views

Possible to downgrade Postgresql and PostGIS versions and still be compatible with latest OpenGeo Suite?

I'm trying to connect ArcGIS Desktop 10.1 to PostGreSQL/PostGIS tables. I have PostGreSQL 9.2/PostGIS 2.0, which was installed with the latest OpenGeo suite. Unfortunately ArcGIS direct connections to ...
1
vote
0answers
154 views

Download OSM data using “ArcGis Editor for OSM”

My actions: 1) Add Basemap -> OpenStreetMap 2) zoom to area (in this area about 300 nodes) 3) OpenStreetMap Toolbox -> PostgreSQL Download, Extract and Symbolize Tools -> Download, Extract and ...
2
votes
1answer
47 views

Nearest neighbour for every row

I'm relatively new to PostGIS and postgresql . I'm trying to build a simple query containing two relations as follows : I've two relations R1 and R2 both of which contains geometries(Points) . I ...
0
votes
1answer
222 views

Connecting PostgreSQL/PostGIS and MapGuide Maestro

This is less a specific question, but hopefully more of an open question. There is little documentation regarding connecting the excellent OS web mapping software MapGuide Maestro ...
0
votes
1answer
151 views

Full instruction for download OSM data in Ubuntu 12.04 LTC

Is there instruction for: 1) install software 2) download OSM data in Postgis database 3) set styles 4) generate tiles 5) initilaze MapProxy (all in OS Linux) 6) View map (generated tiles) ...
1
vote
1answer
165 views

Mimimum distance between points (Postgres/PostGIS)

I have a table (tab_Cities with cities which own more than 50000 inhabitants. The table also contains lat, long and the_geom as columns. I can already see the points via QGIS. Now I want to write a ...
1
vote
1answer
2k views

Error when trying to run Create Extension postgis

I have installed PostgreSQL 9.x and PostGIS 1.5/2.0 several times and have never had this problem. I just got a new CentOS 6.3 server up and running and and I have Postgres 9.3 functioning as ...
2
votes
2answers
502 views

Split Line at intersection and attach attributes

I want to slit line at intersection and attach attributes and export I have roads table with columns id,road_name,road_type,geom with 2115 records. I try using this query - select ...
1
vote
2answers
110 views

How to create a network from nodes and boundaries?

I have a table of nodes (points) and i wish to route between the points. Its my understanding that i first need to build a pgrouting compatible topology (graph ?) that connects all the nodes using ...
0
votes
3answers
873 views

How to create a new 'gis' database in PostGIS?

I'd like to create a new database in PostGIS, so I can load stuff into it while the current database is being used. According to the docs Some packaged distributions of PostGIS (in particular the ...