PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

1
vote
3answers
649 views

postgresql export database with command or pgAdmin III

I want to export my postgresql db with pgadmin. I search all of its GUI, I also searched the web and I don't find some sueful information. I know how to import the db into postgresql: create a db with ...
2
votes
1answer
86 views

PostgreSQL PL/Python Function for “IF” condition

I am using OSM data to run pgr_dijkstra() for weighted-path calculation. But after importing OSM data using osm2pgsql I populated some additional columns into my ways table. So now it has gid serial, ...
2
votes
1answer
61 views

What does the values in column clazz (osm2po) mean?

I have a given table in postgreSQL with OSM data which is used for routing purposes in Java with PGRouting. There exist two columns which I don't understand. They belong to osm2po. They are labeled ...
0
votes
1answer
176 views

Why is ArcMap leaving connections “<IDLE> in transaction”?

The TL;DR version: When you use ArcMap Query Layers to access a PostgreSQL table, ArcMap's database connections are almost always sitting idle in unclosed transactions. Why would this be? I have ...
2
votes
1answer
64 views

If do not want to use pgRouting then what?

Good evening fellow GISers, I am interested in creating an online routing application. So supposing I have all the data I want into a postGIS database and loaded onto GeoServer and I am willing to ...
2
votes
1answer
76 views

Error when creating enterprise geodatabase

I'm trying to create an enterprise geodatabase. My problem is when I try to create a corporate geodatabase. The error is: Cannot connect to database because the database client software failed ...
1
vote
1answer
63 views

Query to get convex hull

Is the below query correct to get a convex hull shape: DATA "the_geom from (select ST_ConvexHull(ST_Collect(the_geom)) As the_geom FROM xyz) as foo using unique id using SRID=XXXX"
6
votes
2answers
89 views

Similarity between two or more trajectories

I have the data of trucks (http://www.chorochronos.org/). This data are gps coordinates of multiple trajectories of trucks in Athens. I have to calculate the similarity between the trajetories, in ...
0
votes
2answers
477 views

ST_Touches for more than just one geometry

I'd like to select some neighbor polygons with ST_Touches. Therefore I found the following statement: SELECT b.name FROM layera as a JOIN layera as b ON ST_Touches((SELECT a.geom FROM layera as a ...
1
vote
2answers
79 views

take from multilinestring the start & end points

I have to use the A* algorithm and my geometry is in multilinestring and i want to take stratpoint(x1,y1) and endpoint(x2,y2) . I use this queries but the colums after the execute is still empty ...
0
votes
0answers
19 views

2.4.0-Chugiak PostgreSQL layer subset causes DB error

I have succesfully connected to pgsql layer. I got an error after trying to define feature subset in query builder. Can anybody help with this error? An error occurred when executing the query. ...
3
votes
2answers
506 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 ...
2
votes
0answers
23 views

Convert ArcGIS gdb with coded domains to Postgres / PostGIS [duplicate]

We have several file gdb's and would like to convert these to Postgres / PostGIS. We've used ogr2ogr to transfer these files; however, some of the fields are stored as coded domains and the fields are ...
1
vote
0answers
26 views

Error in querying data

I have a mapserver file as below , I get blank page with no map executing this query: NAME var DATA xyz STATUS ON TYPE POINT DUMP TRUE ...
2
votes
1answer
67 views

Order by geometry columns

I am wondering how it really works, I mean "order by" statement when it comes to geometry/geography columns in postgis/postgresql. Besides that really need a way gather rows from a table with a point ...
3
votes
0answers
52 views

Create a Shape file from Sql dump file

I am trying to map data by querying a table called xyz. I need to show the the_geom data on the map. I have below query in my mapserver .map file: DATA "the_geom from xyz using unique id using ...
1
vote
1answer
64 views

Using pgrouting and algorithms in PostgreSQL?

I am trying my first pgrouting in a roads shape file i load it in postgresql first, the table has osm_id gid name ref type oneway maxspeed after i add columns source and target in table ALTER ...
2
votes
1answer
445 views

Multipoint vs point PostGIS

Is it normal to use the geometry type 'multipoint' instead of 'point' knowing that I use it to store only one point. How can I convert from multipoint to point
5
votes
3answers
451 views

Adding a GIS feature to existing database entry with QGIS

I've built a database with postgreSQL with tables, which include geometry columns. When I add some data to my non-geometry columns, I can see them in QGIS when I connect to my database using postgis. ...
2
votes
2answers
87 views

Where to type pgsql2shp command

How to convert post gis database into shapefile, I found that I need to use pgsql2shp command on postgis database query , But how to use it and where to use it. Do I have to use it in the postgre sql ...
0
votes
1answer
60 views

Rollback error when restoring SQL dump file in postgresql using PSQL console via Pgadmin

I am trying to restore a pg_dump SQL file into my postgresql database using PSQL console , where I typed the below command: \i 'c:/../path/to/sample.sql' when I run this I get an error saying ...
0
votes
0answers
21 views

at which location to run psql2shp command in linux [duplicate]

I have linux system which I have connected remotely and I am not able to use $psql2shp command in the command line. I went to /usr/local/pgsql/data to run the command but I was unable to run. I dont ...
2
votes
1answer
49 views

How to populate geography point using ST_MakePoint(long, lat)

I have a table called customer_campaign, and there is an empty column geom(geography) in it. So I want to fill it up by using ST_MakePoint(long, lat) in PostGIS, lat and long are two columns in the ...
0
votes
0answers
62 views

Geoserver ( Java.exe ) cause server to run 100%

Our server runs at 100% CPU when using map services build on geoserver + postgresql I can not find anything in geoserver logs. It is Java.exe takes 100% CPU and because of that server can not do ...
1
vote
3answers
104 views

How to export streets in a certain area from one shapefile to a new shapefile?

I have a shapefile with the roads from Europe and I want to export in a new shapefile only the roads from Greece. I tried to delete the other roads but there are too many and I have no attribute to ...
1
vote
1answer
303 views

Setting up PostGIS: Postgres can't see the PostGIS extensions?

I've just installed Postgres 9.3.4 and PostGIS 2.1 on OSX Mavericks using the very latest versions of the KyngChaos libraries. This is a new machine, and I deliberately haven't installed Postgres ...
3
votes
1answer
390 views

Python Postgres Multiprocessing speed increase

I'm trying to speed up my PostGIS queries using multiprocessing. My current setup is using python and psycopg2 such as below. Although this has given a speed increase, it still seems like there are ...
1
vote
0answers
96 views

All map services display pink tiles

I have implemented mapserver in Ubuntu 14.04 with postgresql 9.3, postgis and imposm using GitHub tutorial. After completing the tutorial all map services display pink tiles not map info. i was not ...
0
votes
1answer
37 views

Lost Foreign key during conversion of SQLite to PostgreSQL using ogr2ogr

I want to centralise several small sqlite databases into a single, big, postgresql database. I am using ogr2ogr to convert my sqlite / spatialite (v3.7.17 / v4.1.1) databases, each one consisting of ...
2
votes
2answers
68 views

Did I set up Tiger Geocoder incorrectly?

I set up Tiger Geocoder in PostGIS on my local box (PostGIS 2.1.3, PostgreSQL 9.3.5, Tiger 2013 data). The problem I'm running into is that on almost every street most of the points are clustered, ...
1
vote
0answers
43 views

Does qgis support postgresql range types?

I added a postgis layer with date range column in Qgis but that field is not listed in Qgis.
2
votes
1answer
223 views

Creating 3D terrain from point data in PostgreSQL?

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 ...
1
vote
1answer
62 views

problem in pgRouting with data from google earth

Hello i am new in forum an in Postgesql,postgis and pgRouting. I try to make a pgrouting for my city roads. I use googlemaps to make a lines with coordinates of the roads and export the results in ...
7
votes
2answers
862 views

vehicle tracking system in postgresql performance

I am developing the vehicle tracking system using postgresql. When the data comes from device to my DB server, I am calling the following functions after inserting data into log table. Distance ...
9
votes
1answer
261 views

Can PostGIS and QGIS provide dependable multi-user editing?

After considering a few options, I'm trying to give my 15-20 QGIS 2.2 users the ability to concurrently view/edit one or two basic point PostGIS layers, largest one has just 16,000 records. I've ...
0
votes
1answer
54 views

Geoserver to PostGres database using a hostname

I am trying to connect GeoServer to a PostGres Database with PostGIS extensions installed, but I need to use the host name becauuse the IP address may change. I am running geoserver and postgis in ...
3
votes
2answers
21 views

Inside/Outside Local Jurisdictions

Does anyone know of a software or service that can define whether a location is inside or outside of city and county jurisdictions? Our company is getting hit with huge tax audits because we did not ...
1
vote
1answer
95 views

Configuring SFCGAL to PostGIS Db

I was using PostgreSQL with PostGIS and Pgrouting. Recently I needed to install SFCGAL for some extra functions for my PostGIS db. After installing SFCGAL, now I don't know how to update my PostGIS db ...
0
votes
1answer
505 views

SELECT assign_vertex_id('ways', 0.00001, 'the_geom', 'gid'); not work

I'm using using OSgeo 6.5 dvd and studing pgrouting workshop (link) for get shortest path. I created network topology call "pgrouting - workshop". There are three commands to execute in section 5.2 ...
0
votes
0answers
49 views

R PostGIS convert SpatialPolygon to PostGIS table

I've been having some success in scraping some webdata and converting it from HTML to spatial data as originally asked here: Parse PHP/HTML to shapefile or similar I've been using R to both fetch the ...
9
votes
2answers
1k views

Huge point cloud laser data in PostGIS - Storing and Processing it

I wonder, how it's possible to store huge sets of laser scanned point cloud data in PostGIS, with the time-aspect for processing it in mind. I know, there exists a geometry-object Point in PostGIS. ...
1
vote
1answer
98 views

How to install postgis extension using an existent version on postgresql on OSX 10.9.4

I'm trying to install postgis using my existent version of postgresql. I tried doing: brew install postgis. But I'm getting the following error trying run create extension postgis; query ...
2
votes
2answers
141 views

PHP examples to replicate FeatureServer capabilities

I used FeatureServer before and I liked it. The only thing I didn't like, though, is that it needs some other dependencies to work. That's why I want to try PHP instead. I know that there are already ...
1
vote
0answers
60 views

How to count the number of coordinates within x meters grouping by distinct ids?

I have a table "items" of about 1 million rows and 40.000 distinct ids like the following: idx | id | point | lat | lon | the_geom 1 | 1 | 76 | 51.463388 | -0.16869856 | 0101000020E... 2 | 1 | 53 | ...
4
votes
2answers
986 views

Convert KML to shapefile without losing attribute data

So I want to convert KML files to SHP shapefiles to load it onto PostGIS. Currently I'm using ogr2ogr to do the conversion for me, but it wipes out all the attribute data. How do i preserve this ...
1
vote
1answer
62 views

PostGIS - How to do ST_UNION on each feature of a geojson FeatureCollection

I have a simple geoJSON featureCollection composed of 2 features: featureCollection = {u'type': u'FeatureCollection', u'features': [{u'geometry': {u'type': `u'MultiPolygon', u'coordinates': ...
1
vote
1answer
138 views

Display data from geoserver on click map with openlayers

I tried to display data with popup from Geoserver or Postgres to my map, but it dosen't work at all. Can anyone please help me? I used this code: function Info(e) { if ...
2
votes
1answer
49 views

Error in installing PostGIS 1.5?

I am installing PostGIS 1.5. After giving the command ./configure, it is showing that: pQserverversion in -lpq not found. configure: error: could not find libpq. What does it mean? I am ...
1
vote
1answer
41 views

Error while installing PostGIS 1.5

After giving the command ./configure, it is showing that: pQserverversion in -lpq not found. configure: error: could not find libpq. What does it mean? I am using Red hat Linux (32 bit) version ...
1
vote
1answer
46 views

What date was a table loaded into PostGIS

Is it possible to find out the date a table was loaded into a PostGIS schema using PgAdmin3? The tables are usually supplied from varying external sources.