PostgreSQL is an open source object-relational database system.
1
vote
1answer
9 views
How to use st_touches to find polygon touching each other
I want to compute number of neighboring states for each state. I know st_touches() has to be used but I am not able to form the exact query. I think it should be something similar to below:
I am not ...
0
votes
1answer
17 views
How do you combine multiple spatial functions in one query?
I want to find out the intersection and difference in the same query using postgresql.
How can I combine both st_intersect and st_Difference in same query and return the result.I want to compute the ...
0
votes
0answers
8 views
TileStache some vector tiles failing / postgis connection error
I have TileStache running fine with NGINX/uWSGI on my server. Problems start when I try to render data as vector tiles from a postgis datasource. A few tiles will normally work fine, but at some ...
0
votes
0answers
16 views
Capturing points slightly out at sea
I have two tables one containing points (points) and the other polygons (polygons). I want to generate a two-columns table identifying for each point of the first table the polygon containing it. So ...
0
votes
0answers
14 views
OpenGeo Suite and External Gui [on hold]
I am creating an application using Open-Geo Suite. I have already created a war file from ol3edit template and it worked just fine. Now If I was to create an external GUI perhaps with JAVA or any ...
1
vote
1answer
19 views
How to import geometry data from csv file to postgres?
I have geometry file in *.xls file, but when I save in *.csv it say "some feature in your workbook might be lost if you save it as CSV (Comma delimited)" however I keep that file anyway and when I ...
0
votes
0answers
50 views
How to compute “how many points present in each square mile area”
I am using postgressql. I am searching psql command - to find out number of points that lie in every square mile of an area.
the SRID is 2263.and I have some information: Extent West -74.257159 East ...
2
votes
0answers
37 views
Arcpy cannot connect to SDE on PostgreSQL with 32-bit version
So I've been banging my head against a wall for awhile with this one.
I recently setup an SDE database in Postgres, and all seemed good. I am able to connect to it from both ArcMap and ArcCatalog, ...
3
votes
1answer
43 views
Postgis is Broken after installing Nominatim
I followed Nominatim Tutorial to install PostGIS and after that I can't access PostGIS at all
I already trying reinstalling and installing everything over and over again with no success.
Everytime I ...
2
votes
0answers
37 views
Inserting coordinates from Google Maps into a Database
My question is pretty basic. I am using Android Google Maps to take the coordinates off a location on the map and I want to insert it into a PostgreSQL database. I know I have to use PostGIS but how ...
1
vote
1answer
24 views
importing shapefiles to postGIS on QGIS1.8
I am trying to import a shapefile into postgis from within QGIS 1.8.
The QGIS is based on a server that is not managed by myself. I have requested an upgrade to QGIS 2.0 ...but this may take ...
0
votes
1answer
46 views
Google Maps Api , PHP, Javascript and Postgresq-Postgis
I'm trying to make a web application, where I take the start/end city from a text box, geocode the city, use the coordinates to query my database in PHP, and return the features to be drawn in the ...
0
votes
1answer
34 views
st_startpoint(the_geom) returning empty values
When I upload a shapefile to PostgreSQL using the QGIS tool I can create the routing topology following this tutorial without any problem.
But when I use the PostGis Shapefile Import/Export Manager ...
0
votes
0answers
35 views
Live serving tiles from Tilemill: Easiest way?
I have set up Tilemill on a Ubuntu server and I have imported OSMBright as a starting point. In general it seem to work good. I have imported the planet file (took a long time but now it is done and ...
5
votes
1answer
105 views
TileMill fails to load Europe data from PostGIS. What am I doing wrong?
The Problem:
Using OSM-Bright in combination with an imported (osm2psql) Europe shapefile, tiles won't load unless I have 2-3 layers active (of the total of 29). I don't have this problem with an ...
5
votes
1answer
99 views
What controls the direction of TopoGeometry Linestrings?
In PostGIS, what if anything controls the direction that topogeometry LINESTRINGs will have when converted to geometry?
It doesn't appear to be the order in which the edges are listed in the call to ...
0
votes
1answer
11 views
return state of point from postgis / mapnik pgsql db
I realize that I can confirm whether or not a point lies within a state like this:
SELECT ST_Contains(poly,pt) As testr
FROM
(
SELECT ...
2
votes
1answer
49 views
Export PostGIS line to AutoCAD with graphical direction information
Some time ago I managed to export from PostgreSQL to AutoCAD DXF format a line (LINESTRING) using ogr2ogr program with a PostgreSQL Query, and it works (I can visualise it by the QuantumGIS).
Now I ...
2
votes
2answers
27 views
PostGIS 2.0 and Self Intersecting Features
I have a polygon feature class created by open streetmap that is returning a self intersection error. Is there a way to filter out these feature? Can I just use a sql statement to find the error ...
1
vote
0answers
30 views
Error creating a spatial database. ERROR
I have been trying to get Postgis set up for a while now, I am stuck on one error and have not found a solutions yet. This is on Ubuntu 14.04.1.
I am trying to run:
CREATE EXTENSION postgis
But am ...
1
vote
1answer
32 views
How to modify a PostGIS function?
I wish to modify a PostGIS function ST_PixelAsCentroids. What is the best way to go under-the-hood of PostgreSQL/PostGIS functions and modify and customize them as you wish?
I'm not hitting the right ...
0
votes
0answers
25 views
Adding data to PostgreSQL geodatabase using ArcGIS for Desktop?
I installed and configured PostgreSQL
perform the settings in this link
http://resources.arcgis.com/es/help/main/10.2/index.html#/na/002p000000t4000000/
My problem is I cannot upload feature class
...
1
vote
1answer
13 views
No route calculated when using direction=true
I am using pgr_dijkstra to calculate routes on OSM data.
When using this call:
SELECT *
FROM pgr_dijkstra('SELECT id, source, target, cost FROM referentie.ref_osm_edges '
,768576
...
0
votes
0answers
27 views
Insert several gtfs feeds into the same postgis/pgrouting database
I want to import sevaral gtfs feeds into my postgis/pgrouting database so that I can route over all my gtfs feeds.
The problem is that the sources / destinations ids of my gtfs are likely to ...
0
votes
0answers
35 views
Apply raster contraints on single table with multiple files
I have a raster table (pre-created using CREATE TABLE) containing multiple individual raster files that I append piece by piece to a final table. The table itself is in its own tablespace 'gisdir' and ...
0
votes
2answers
108 views
Unable to connect to PostGIS databases after Mac OS X Yosemite upgrade
I upgraded to Mac OS 10.10 Yosemite and am unable to connect to PostGIS databases (PostgreSQL version 9.3 and PostGIS installed from KyngChaos). Typing psql my_database returns this message:
psql: ...
1
vote
0answers
26 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
59 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
12 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
85 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
55 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
34 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
38 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
34 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
35 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
56 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
32 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
42 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 ...
0
votes
0answers
7 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
18 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
34 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
14 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
42 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
37 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
72 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
39 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
27 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
57 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
57 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
74 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 ...
