Tagged Questions
PostgreSQL is an open source object-relational database system.
0
votes
0answers
9 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 ...
-1
votes
0answers
30 views
How to update PostgreSQL rows using php [on hold]
I tried to update a table in PostgreSQL by using this code but it doesn't work , can anyone help me please
< ?
php
session_start();
try
{
$dbconn = pg_connect("host=localhost ...
1
vote
0answers
13 views
Bad SRID or Tiger Geocoder Inaccuracies?
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, ...
0
votes
0answers
30 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 ...
1
vote
0answers
47 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 | ...
2
votes
1answer
28 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
29 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
31 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 ...
2
votes
2answers
107 views
+150
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
1answer
32 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 ...
1
vote
0answers
32 views
Get a single cluster from cloud of points with maximum diameter in postgis
I have on the order of 2M Geometry Collections with N (median: 2, stddev: 6.6, 75th: 6, 95th: 21) Point objects (repeated points allowed and important) in a PostGIS table. I want to identify clusters ...
1
vote
0answers
55 views
Unable to edit PostgreSQL/PostGIS layers in ArcMap 10.2.2
I am connected to the database, have added a layer, started edit session, but I am unable to edit the attributeeo table of said layer. ArcMap tells me that it is not an editable layer. When ...
1
vote
1answer
22 views
Display data from postgresql on click map [duplicate]
I work with openlayers and geoserver. I'm searching for code that when I click on a point of a layer on the map, a popup window appears that contains information from the database (postgres) for this ...
1
vote
1answer
37 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
...
1
vote
1answer
44 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.
1
vote
0answers
37 views
Limited number of entities exported with ogr2ogr?
I generate shapefiles with a php script that launches ogr2ogr commands. The ogr2ogr commands look like :
"C:\OSGeo4W64\bin\ogr2ogr.exe" --config PGCLIENTENCODING LATIN1 -overwrite -f "ESRI Shapefile" ...
1
vote
1answer
41 views
Copy tables from one server to another in PostgreSQL
I am trying to copy a number of tables from one server to another using PostgreSQL as part of reorganising our data structure. I am pretty new to PostgreSQL so haven't much experience with it. Is ...
2
votes
1answer
46 views
Polygon from line creation problem
I have a problem transforming a linestring into a polygon.
The error is:
ERROR: lwpoly_from_lwlines: shell must be closed
So I checked but firstpoint and endpoint are the same.
I tried to use ...
4
votes
1answer
98 views
Connection property set error on registering PostgreSQL geodatabase with ArcGIS for Server?
We're in the middle of a migrating process.
We've imported a geodatabase on a new Linux machine and we're trying to publish some map services to this new ArcGIS Server (that resides on the same ...
0
votes
1answer
48 views
Calculate shortest path between each lat/lon point in one table and each lan/lon point in another in Postgresql
I have two tables, both of them have only 2 columns. The first one contain only latitude and longitude coordinates of my source points and the other one only latitude and longitude coordinates of my ...
1
vote
0answers
43 views
How to load style from postgresql?
Is there any way to load a postgresql style for a vector layer using python?
There is a function:
loadNamedStyleFromDb (const QString &db, const QString &theURI, QString &qml).Does it ...
1
vote
1answer
38 views
PostGIS - ST_Difference query returns a dissolved result
I am using the ST_Difference to erase multipolygon feature by a mask. However, the query returns a dssolved multipolygon.
The query is the following:
'''SELECT ST_AsGeoJSON(ST_Collect(geom))::json
...
1
vote
0answers
25 views
Pgrouting, pgr_dijkstra function error
I'm starting to use the Pgrouting function on my database Postgresl. I have the table of links (id, source, target, cost) which contains the set of edges of my graph. I want to calculate the shortest ...
2
votes
1answer
48 views
Installed PostGIS extension not listed for database
I have a PostgreSQL database with the PostGIS extension enabled.
I know that this extension is enabled, since I am using PostGIS functions, and I can actually see the PostGIS functions.
However, ...
2
votes
1answer
45 views
Find nearest distinct features to a point
I am trying to select a single distinct features closest to an XY point in PostGIS.
So I can find a single record for each distinct code by using:
Select Distinct ON (code) * FROM table;
Which ...
1
vote
0answers
22 views
Performance issues Tilemill with PostgreSQL and large datasets
I have a Tilemill project the size of europe. I developed my style-sheet by using a smaller dataset (size auf Austria) and everything was perfect. But now I did apply the same styles to my big europe ...
1
vote
1answer
40 views
Postgres Performance with Radius Searches
Im porting an application from mysql to postgres, and have several tables with 500k+ rows in each of geo points (lat, lon). In mysql i used a bounding box query with haversine to select rows within a ...
0
votes
3answers
96 views
What Open Source Packages are available to provide routing
I am looking for ways to validate mileage charged by our contractors. They are paid from a central location to a customer, and then from the customer to a drop off location.
I use QGIS for a bunch ...
0
votes
0answers
24 views
insert row into postgis query table in QGIS
I find I am using QGIS (2.4) more and more as a client for PostGIS database tables with geometry, but also for tables without geometry, partly because it's good just to use the one application and ...
1
vote
1answer
27 views
Minimum Information to be kept on importing OSM data to use it for creating random start and ent points
I want to only import the minimum of data from OpenStreetMap, to be able to distribute random start and end points for a simulation in administrative areas in germany. I found this file ...
1
vote
2answers
59 views
Split lines into non-overlapping subsets based on points
Given a table with line geometry, and one or more points that are snapped to this line in a separate table, I would like to split each line with one or more intersecting points at each of the ...
2
votes
1answer
45 views
Python script fails on stand alone but works in ArcMap as a toolbox
I have a fresh install of ArcGIS Server and ArcGIS for Desktop both 10.2, latest patches applied. The data is served in this application from a PostgresSQL enterprise geodatabase.
The problem is that ...
1
vote
3answers
84 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
55 views
SQL query to have a complete geojson feature from PostGIS
I would like to get a geojson feature with properties from PostGIS. I have found an example to have a feature collection but I can't make it works for just a feature.
so far I tryed to modify the ...
1
vote
1answer
44 views
where styles from QGIS are saved in PostgreSQl
I can save style of a layer in DB PostgreSQL. But where it is stored in Postgres? How can I found It?
4
votes
3answers
80 views
From PostgreSQL to QGIS
I have conected to PostgreSQL and imported the layer to QGIS.
The names of columns are written using English letters.
Can the names of columns be automatically renamed using another language?
0
votes
1answer
18 views
Road displays up to node, not up to starting point and ending point
SELECT id FROM table ORDER BY st_distance(the_geom, st_setsrid(st_makepoint($slng,$slat), 4326)) limit 1
; get source and similar for target
; and then apply in dijkstra algo
SELECT pgr_a('SELECT id ...
1
vote
0answers
40 views
PostGIS - Intersects feature to split into linestring
I would like to know if it's possible to intersect feature datasets (multipolygon, polygon, multilinestring and linestring) to get a result as a set of linestrings being split at each intersection ...
1
vote
2answers
56 views
select intersection of 2 geometries, polygon and polyline
I'm searching how to have a result of 2 geometries (villages and wetland) which don't intersect.
When I write:
select distinct v.name
from villages v , wetland w
where ST_intersects(w.geom,v.geom) ...
0
votes
0answers
43 views
Google Streetview Images in infowindow
I have followed the instructions on this blog post on adding streetview images to the infowindow:
http://blog.cartodb.com/a-picture-is-worth-1-000-attributes-infowindows-with/
I can do it without a ...
1
vote
1answer
124 views
create the postGIS table error No such driver: PostgreSQL
I'm trying to create the postGIS table with spatial features I can do it by:
library(RPostgreSQL)
library(spacetime)
library(rgdal)
dbname = "geodatabase"
user = "postgres"
password = "***"
#password ...
0
votes
1answer
40 views
How to update a CartoDB table at a certain time of day
I have a table in CartoDB 'inland' that I would like to have automatically update each day at 8pm PST. I know that PostgreSQL has no internal function to run an UPDATE COLUMN function at a certain ...
0
votes
0answers
34 views
Connect to PostgreSQL from ArcMap 10.2 failed [duplicate]
I have a database server PostgreSQL and Postgis. I want to connect to database from ArcMap 10.2 , I tried Add Database Connection from arcmap menü.
I typed my connection informations and clicked ...
1
vote
3answers
62 views
How can I insert a bounding box or polygon in a PostGIS geometry field?
I have a field in my table called 'geometry' that was created thus:
CREATE TABLE "public"."sites" (
"id" int8 DEFAULT nextval('sites_id_seq' :: regclass) NOT NULL,
#... A few MORE fields
...
0
votes
3answers
138 views
Import shapefiles on my postgis table using R
Using R, I would like to import shapefiles that are in a directory on a geometric table i have on postgresql / postgis.
What is the instruction that allows me to do it?
EDIT: here is my code to ...
3
votes
1answer
46 views
Problem in Backing up a database in PostgreSQL
I need to create a backup from my database (in PostgreSQL 9.3). I have used the pg_dump tool, gives me an error. I have also used pgAdmin III for backing up which also gives me the following error:
...
3
votes
1answer
78 views
Using OpenStreetMap for simulation of commuter routes
I'm seeking some advice on how to build a simulation based on OpenStreetMap Data for my masterthesis. My knowledge of spatial data is very limited, since I come from another field of science, namely ...
2
votes
2answers
104 views
Problem with running PostgreSQL 9.3 after installing pgRouting
I have PostgreSQL 9.3 installed on the server. It worked just fine. I also had a webservice which connected to a database. That also worked like a charm. Later, I decided to install and use pgRouting. ...
5
votes
2answers
60 views
Working with address data extracted from *.osm
My goal is get all the addresses from a certain country, ideally - from all countries, but for now - only from one.
I downloaded an *.osm file from here http://download.geofabrik.de/ for a certain ...
3
votes
1answer
32 views
PostGIS ST_ConvexHull for cube corners not as expected
I'm new to PostGIS and am wondering whether ST_ConvexHull will be of use in a particular work problem. Trying out some simple cases to make sure I understand what it's doing, I didn't expect this:
...
