PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

0
votes
1answer
51 views

Is it possible to label a postgis Query Layer in ArcMap?

I've created a PostGIS query layer and I can't label it. I'm trying to work out if I'm dealing with a bug that I can't workaround, a bug that I can workaround, or if it is operator error. After ...
5
votes
2answers
221 views

Need Help Converting Shapefile coordinates into lat/lon

I'm having a little trouble importing a shapefile into PostgreSQL. Using shp2pgsql, I'm able to import the non-geometry data just fine. However, the geometry data is coming in based on some ...
1
vote
1answer
661 views

What options are there for geolocation-aware SQL databses? [closed]

I need to implement an SQL database that can make queries using geo-location based logic. e.g. select rows within 500m of coordinate x, y What options are available to do this with sqlite, mySQL, ...
2
votes
1answer
55 views

View with sequence in QGIS 2.4

In postgres, I created a view with a sequence nextval() to have an unique id (called vid). I tried to vizualise this view in QGIS but it failed. It seems that nexval() causes some issue according to a ...
0
votes
0answers
165 views

PostgreSQL Visual Coordinates

Hello I am making a web map application. I use PostgreSQL, PHP, HTML and JavaScript and I extract the coordinates from the database with PHP and pass it to my JavaScript. Here is my code: ...
2
votes
1answer
138 views

Storing the GML application schema in postgres

I have to store the application schema for a GML file which is in Xsd format in PostgreSQL table. I want to use the ISO standards for that. From what I have searched I think ISO 19109 has to be ...
1
vote
1answer
246 views

Can I visualize MultiLineStrings in Google Maps

I have made a web application which retrieves roads coordinates from a Postgres database and I when I attempt to visualize this using Google Maps API nothing shows. I am trying to plot ...
-1
votes
1answer
353 views

US Census Geocoder returns different city that TIGER Shapefile data

When I geocode an address using PostGIS+TIGER 2013 I get a different city than what Census Bureau Geocoder reports. The Long/Lat are identical in both cases, but the PLACEFP is different although both ...
0
votes
1answer
288 views

Google Maps and Postgresql

I am looking for a way to visualize data from Postgres in Google Maps, but I have only figured out how to do this for Markers. I am using PHP to retrieve the data in JSON, which I then request from ...
1
vote
0answers
77 views

Why do pgadmin III views show up as empty ArcSDE geodatabase tables in ArcCatalog? [closed]

I have an SDE geodatabase connection set up in a server with data stored in a postgres database. I have successfully created views using pgadmin III but they show up as empty tables in ArcCatalog ...
1
vote
1answer
255 views

Aggregate functions not allowed in trigger

I need help with a postgres/postgis trigger. I have a table of retaining walls, each of which is associated with the adjacent road, except where the wall abuts a junction, where it will be split and ...
2
votes
1answer
61 views

Interpolating mobile signal data

I have collected the signal strengths for the mobile operator at some places in my college campus. Now I want to spatially interpolate this data for the entire campus. I am using PostGIS. I am ...
2
votes
0answers
49 views

How to Create Query Status Table Postgres

I am currently a user of a Postgres database (I am not the DBA). Within my sandbox I run several business critical scripts every day and currently track their status by first in a log text file on my ...
6
votes
0answers
149 views

Postgis database query optimisation

I have a set of rasters in DTED format which I load into postgis database using raster2pgsql command line tool. Each of rasters is simply stored in a row and described by rid and a value of raster ...
1
vote
3answers
63 views

problem to use openstreetmap data file with pgrouting2.0 on PostgreSql9.3

I'm a newcomer on pgrouting, and I want to test its functionalities. I've installed and configured my computer with Postgresql9.3, pgrouting2, and PostGIS. I've downloaded from openstreetmap the ...
3
votes
1answer
782 views

Drawing isochrones on map?

I am a fourth year graduation student of the Amsterdam University of Applied Sciences. I am currently working on my final thesis for which I am doing research on the Amsterdam Airport catchment area. ...
1
vote
1answer
149 views

How can I render the postgis layer to the openlayers map viewer?

I have a postgres table which is storing the dynamic GPS point data. The geom column has been created. Is it possible to render the last 10 mins GPS data to the OpenLayers map? Is there an example?
0
votes
0answers
322 views

GeoJSON and php i cant visualy roads from postgres database

I am make a json file with geometry MultiLineString from the posgresql but when i try to load the file in map.data.loadGeoJsonis not visually the roads but if i take the link from google api example ...
1
vote
2answers
121 views

Viewing large set of polygons in PostGIS using OpenLayers?

I am prety new to GIS. I have set up a postgis database with al large dataset and a openlayers front-end to display it. But since the dataset is getting prety big I am looking for a way to only load ...
1
vote
1answer
185 views

How to change the postgresql table to support postGIS?

I have a postgresql database which there is the table have lat & long columns. The postgresql does install the postgis extension. My question is how can I change the table with lat & long ...
0
votes
0answers
216 views

Importing a Raster into PostGIS 2.1 (Windows 7)

I am trying to learn how to import rasters into PostGIS (2.1). I have read through all the material I can find on doing this and know that the recommended tool for this is the raster2pgsql tool. I ...
2
votes
1answer
289 views

Loading raster in postgis and link it with an existing table

Relatively new to PostGIS and I am currently exploring the options to make one of my PostgreSQL Tables spatial. Essentially I want to store a raster object in a table that also contains essential ...
1
vote
1answer
449 views

How to migrate Postgres table having Lat Lon columns to an existing PostGIS database?

I am having Postgres database table with Lat Lon columns (degree, minutes, seconds) as shown below : CREATE TABLE population ( id double precision, idno text NOT NULL, place text, state text, ...
2
votes
2answers
478 views

Why use a database when you can have all of your data in javascript/openlayers?

I have a really simple and basic question. First of all, I have to mention that I am pretty new to web applications and GIS. I am working on a web application using Openlayers, Postgresql/postGIS and ...
2
votes
1answer
306 views

Close linestring to linering in PostGis

is there a function which closes a linestring to a linering? I couldn't found such a function in the documentation. Thanks.
4
votes
0answers
102 views

Adding data from PostgreSQL to Query Layer of ArcGIS for Desktop warns that given coordinate references are incompatible?

When adding data from PostgreSQL in a Query Layer I get the warning: The given coordinate references are incompatible I have added many other layers with the same properties no problems, but I ...
2
votes
1answer
246 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, ...
3
votes
2answers
340 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 ...
3
votes
1answer
232 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 ...
3
votes
1answer
621 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 ...
6
votes
2answers
427 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
0answers
32 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. ...
1
vote
2answers
777 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 ...
1
vote
1answer
155 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"
1
vote
0answers
30 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 ...
7
votes
1answer
141 views

Create a Shapefile 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 ...
2
votes
1answer
420 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 ...
0
votes
1answer
212 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 ...
3
votes
2answers
1k 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 ...
2
votes
1answer
243 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 ...
3
votes
1answer
250 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 ...
1
vote
0answers
264 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
168 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 ...
0
votes
1answer
122 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 ...
1
vote
0answers
280 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 ...
1
vote
0answers
62 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.
14
votes
1answer
980 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 ...
1
vote
1answer
167 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 ...
0
votes
1answer
520 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
32 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 ...