PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

2
votes
2answers
805 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
217 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
155 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
519 views

PostgreSQL: 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
577 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
107 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
219 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 ...
1
vote
0answers
442 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
638 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
469 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
117 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 ...
1
vote
2answers
606 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
516 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
305 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 ...
3
votes
1answer
102 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
516 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
297 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
404 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 ...
9
votes
3answers
6k 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 ...
3
votes
2answers
2k 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 ...
2
votes
2answers
216 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 ...
3
votes
3answers
5k 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 ...
2
votes
0answers
20 views

Problem with postgres/quantum converting long/lat to suitable projection/SRID [duplicate]

I'm sure it's a simple question but this is all very new to me and after a lot of internet searching my points are still in the sea! I have a set of UK postcode data that I have converted into ...
3
votes
1answer
6k views

Transforming from SRID 900913 to 4326 with PostGis

I have two Postgres tables with different SRIDs: 4326 and 900913. I want to convert the latter to 4326. I first changed the SRID using: Select UpdateGeometrySRID('table', 'geomcolumn', 4326). I ...
0
votes
1answer
170 views

Is it possible to install the PostGIS to the PostgreSQL (binary version)?

I'm using the PostgreSQL 9.2.4 which is the no installation version.I run this by using the command "Program Files/PostgreSQL/9.0/bin/pg_ctl" -D "Program Files/PostgreSQL/9.0/data" -l "Program ...
1
vote
2answers
240 views

ArcSDE installation; “sdesetup: command not found”

I am trying to install ArcSDE component for postgresql database from A DVD file. I have copied files of following folders on the server : command_64 pg_64 in both of theses files there are ...
1
vote
1answer
525 views

How to address Geodatabase must be enabled as geodatabase admin user error? [closed]

I am trying to use "enable Enterprise Geodatabase" but I am getting the following error: "Geodatabase must be enabled as geodatabase admin user.Failed to execute " I am using postgresql 9.1.3 ...
1
vote
0answers
139 views

PostGis search query on hstore tags

I am writing a search client, to query postgis db. The search query will be, SELECT tags->'name' AS name,ST_Transform(way,4326) AS pt_lonlattext FROM planet_osm_point WHERE lower(tags->'name') ...
2
votes
2answers
2k views

“Create Enterprise Geodatabase” errors

I am trying to use " Create Enterprise Geodatabase" option in arcmap 10.1: I am getting two following errors: You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL ...
2
votes
1answer
3k views

Import database (Excel file) into PostgreSQL [closed]

In order to import my database (excel file) into PostgreSQL, I converted the Excel file into ".csv" file. Then, I used the application: "Import Data For PostgreSQL" and I could import my database but ...
2
votes
1answer
157 views

Tiger geocoder / postgis - get county from point

Looking for some help with getting the county for a lat / lon. I have postgis / tiger geocoder installed and can reverse look up a point and get the addresses. I would like to get the county the ...
1
vote
2answers
436 views

Is it real to install PostgreSQL 9 on the virtual machine Windows Server R2?

I have Virtual Box with GuestAddition. And virtual machine "Windows Server 2008 R2" When I use real computer with Windows Server 2008 R2 I can install postgresql-9.2.3-2-windows. But when I install ...
1
vote
2answers
379 views

Postgis csv and error loading into mysql

I want to load spatial data into MySQL using a CSV I have generated from a Postgres table and when loading it into MySQL database using phpmyadmin it complains "Cannot get geometry object from data ...
0
votes
1answer
2k views

Could not add the specified data object to the map

I have registered the postgresql database with arcgis desktop 10.1. In ArcMap, When I try to drag and drop one of the tables to the map I get this error: Could not add the specified data object to ...
1
vote
1answer
150 views

Is postgres 9.1.9 supported by ArcGis 10.1 Service Pack 1?

I want to install Postgres and Postgis. Now we use ArcGis 10.1 So I install Postgres 9.0.5 But there is not exist Postgis for this version. I try install postgis 2.0.3 But I fail(it is only 32 bit ...
0
votes
1answer
168 views

Create Layer editing/Analysis in an ArcGIS web map application using Javascript API

I want to make an ArcGIS web map application in which user can select different layers of the published map (data of the layer in Postrgresql) and do some analysis based on layer data.import data to ...
3
votes
1answer
208 views

Select linestrings containing points with duplicating M coordinates in postgis

I have a table of LineStringM geometries. Some of lines have points with same measure (M coordinate). This is a bug in initial data, that I want to clean somehow. So I need to: 1. Select all records, ...
3
votes
1answer
624 views

Database connection failed

I am trying to connect from Arc Cataloge (version 10.1) to postgresql 9.2. But every time I try to make "Database Connection" I am getting this error: Failed to connect to the specified server. ...
0
votes
1answer
626 views

Best way to store polygon geospatial data in postgreSQL?

I have to store longitude and latitude coordinates for several places in a PostgreSQL db table. Each row in this table has a field with a set of pairs {latitude1, longitude1, ....latitudeN, ...
0
votes
2answers
909 views

connection from ArcMAP to Postgresql, Is ArcSDE required?

I wan to make a direct connection form Arcmap to Postgresql. I have ArcGIS for Desktop 10.1 on windows (64bit). So I need to put "pg_client_windows64" libraries in C:\Program Files ...
1
vote
1answer
408 views

Is there any instructions to download OSM in postgres database?

Is there any instructions to download OSM in postgres database? I use geosuite (geoserver, postgres, postgis). I'd like to download USA and Russia (1-12 levels). I also want to download sld styles. ...
3
votes
0answers
399 views

Finding poi using st_dwithin in postgis

I am not familiar with gis or writing sql, so my understanding in this field is lacking. I have a hundreds of lat/lng geographic coordinates stored in a single table called Places like this: ID | ...
1
vote
1answer
391 views

connection to postgresql; From ArcGIS for Desktop 10.1 OR ArcGIS for Server 10.1

As it is mentioned in ArcGIS Resources "PostgreSQL client libraries are required on the ArcGIS client application from which you will connect to the database". My questions are: by ArcGIS client ...
0
votes
1answer
857 views

How to fix “Connection failed - Check settings and try again” when connecting to PostGIS?

I have Postgres running via Postgres.app on rails already and am trying to connect QGis to the database. PostGIS is working already. (questions already found online deal with this issue only) I do ...
1
vote
1answer
173 views

Three table postgres sql join query

I'm having trouble getting my SQL query to work with three tables. I'm new to SQL to I've already spent considerable time trying to understand the documentation and making some sense of it. I'm using ...
1
vote
1answer
139 views

How can I relate the osm2po osm_source_id to data in OpenStreetMap?

I created and imported OpenStreetMap (OSM) data into Postgres using osm2po: e.g. java -Xmx8g -jar osm2po-4.6.9/osm2po-core-4.6.9-signed.jar config=osm2po.config.eu_xc prefix=eu tileSize=x,c ...
5
votes
3answers
3k views

Using PostgreSQL with ArcGIS

Have mercy ... with Stackexcachange I'm not yet so familiar, so this is initially somewhat opaque. I try to do my best to organize this thread as well as possible. Recently I've started to get WFS ...
1
vote
1answer
221 views

Calculating area of MultiPolygons within 250m buffer of points

I am using using PostgreSQL 9.2 and PostGIS 2.0. I have two tables: 1) a geocoded table of home addresses (address_list) and 2) a table containing data on tree density in the same geographical area. I ...
2
votes
1answer
267 views

Points to paths

I have a set of lat/long points which represent positions along a set of paths (the points are generated by satellite collars on several animals that we are tracking), and I want to link the points ...
2
votes
1answer
757 views

WFS & Feature Access -> Database connection / Database support (ArcGIS 10.2)

Over the last two days I've tried to set up and to use a postgreSQL database to use WFS and Feature Access. I've also started a thread in the esri forums, but I hope that I can reach a wider audience ...