PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

1
vote
0answers
7 views

Are there naming rules for direct connections from ArcGIS to PostgreSQL?

I don't have problem direct connecting arcgis to postgresql if my database name contains only letters, but when the name contains dashes or underscore e.g:"gisdb-dev", I receive an error when setting ...
1
vote
2answers
46 views

PostGIS syntax (function()).*

Whilst reading the documentation about using the PostGIS function ST_PixelAsCentroids() I was confused somewhat by this (ST_PixelAsPoints(rast, 1)).* syntax and as a newbie to SQL I was wondering if ...
0
votes
1answer
9 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
72 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
37 views

What options are there for geolocation-aware SQL databses?

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
30 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
14 views

PostgreSQL StackBuilder 3.1.1 error [on hold]

While installing PostgreSQL 9.3, after Completing the PostgreSQL Setup Wizard dialog advises you that you've completed the setup it opens a StackBuilder Welcome dialog box. There you need to select ...
0
votes
0answers
28 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
28 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
28 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
48 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 ...
-1
votes
1answer
25 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
40 views

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

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 ...
0
votes
0answers
4 views

OpenLayers gx_geocodercombo returns syntax error

I try to implement a gx_geocoder combobox... { xtype: "gx_geocodercombo", hideTrigger: true, emptyText: 'Enter address (streetname housenumber municipality)', width: 350, layer: ...
1
vote
1answer
16 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
24 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
10 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 ...
3
votes
0answers
39 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
28 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
57 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
32 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
23 views

how to open shapefiles in web interface using mapserver and postgresql?

As I am new to coding I am unable to understand how to connect postgresql database to mapserver in asp.net and to display the shapefiles in web interface.
0
votes
0answers
42 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
49 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
69 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
47 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 ...
1
vote
1answer
36 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
55 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, ...
0
votes
0answers
45 views

Project with Postgresql and PHP and GoogleMaps

i like to make samething like this https://sites.google.com/site/mapperzmapdemo/ put i stack in the conection database and web application I try to explane my problem i make a code to read first ...
1
vote
1answer
351 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 ...
1
vote
1answer
11 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.
3
votes
0answers
30 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 have ...
2
votes
1answer
75 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
38 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 ...
2
votes
1answer
49 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
43 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
69 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
15 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
57 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 ...
2
votes
1answer
51 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
22 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 ...
3
votes
0answers
47 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 ...
2
votes
1answer
59 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
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 ...
0
votes
1answer
42 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 ...
2
votes
2answers
66 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 ...
1
vote
1answer
45 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
34 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
35 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
100 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 ...