PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

0
votes
0answers
189 views

Can't upload files to database by Nominatim

I was trying upload geofabric's netherlands-latest file into Nominatim's database. I used bellow command and all was fine: ./utils/setup.php --osm-file maps/netherlands-latest.osm.pbf --all 2>&1 | ...
3
votes
3answers
1k 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
1answer
267 views

Is there any readily available implementation of Mapserver (or Geoserver)- Postgres-Openlayers combination?

I am developing an web GIS for map data presentation for public. Is there any readily available implementation of Mapserver (or Geoserver)- Postgres-Openlayers combination or similar? More Details: ...
1
vote
1answer
13 views

Changing projection of PostGIS data? [duplicate]

I have exported osm data using osm2pgrouting in the database, it has SRID 4326. I want to change projection of all the tables created to a particular SRID in UTM. I read the post FIrst and Second, ...
0
votes
1answer
15 views

Cannot load postgis query as layer in QGIS using create table command

I've a multilinestring object and a points object , where the points are located on the line. The user can set a start and end point on the line and my goal is to return a subset of the points that ...
0
votes
1answer
15 views

Make certain countries visible on Carto map

I want to show only APAC countries on the carto map. I re-wrote my SQL query (see below) and clicked 'create a dataset from query'. Although the countries specified were coded in colors, those outside ...
0
votes
1answer
25 views

carto.com when 2 points have the same location

Carto.com: We are mapping homicides and when two deaths occur at the same location, how do I prevent 2 points with the same lat, lon from overwriting each other? I want to be able to view each point ...
1
vote
1answer
39 views

Restoring PostGIS 2.1. dump in PostGIS 2.2

I tryed to restore my old PostGIS dumps (Postgis 2.1, PostgreSQL 9.1) at my new system (PostGIS 2.2 and PostgreSQL 9.5) I was using pgadmin3 to dump the databases and was now trying to restore it ...
0
votes
0answers
22 views

Strange behavior of ST_length and ST_difference in POSTGIS

I've a LINESTRING that represents the route between Los Angeles and Austin. I calculated the total length of this linestring using ST_Length. Then I calculated the difference between a MULTIPOLYGON ...
4
votes
2answers
220 views

Is it be possible to re-render parts of a tile pyramid when postgis table updates?

I have this idea of using postgis together with a tile renderer for serving my organization with tiled maps. As I believe my data will be partially altered almost on a daily basis it does feel like a ...
1
vote
1answer
20 views

Setting names for attributes in properties in json returned by postgresql

I am trying to make a webmapping app that uses on the server side node.js and postgresql(PostGIS). what I am doing is retrieving data from the Postgresql database using node.js and sending the result ...
6
votes
3answers
269 views

How to do a spatial join in PostGIS that returns on the minimum value of point intersecting polygon?

I have a polygon table (buffer) and a point table (dem_points), and I want to do a spatial join on them. I need to join the point with the minimum elevation (dn) to its spatially corresponding ...
0
votes
1answer
85 views

Cannot find information about my.table table in raster_columns [on hold]

I am running PostgreSQL 9.4 and PostGIS 2.1 and have loaded a small piece USGS SRTM data for North America successfully into my database. I am attempting to export a small piece of of the rasters I ...
1
vote
2answers
34 views

Unable to insert data into table using geocode()

I am new to the world of PostgreSQL. I am using PostgreSQL 9.5. I have installed PostGIS 2.2.2 plugin and along with that came Tiger, Tiger_data schemas. But the Tiger_data schema does not have any ...
1
vote
3answers
48 views

How to load the only selected features from the layer in postgresql to Qgis canvas

I am using the uri to load the layer from the postgres to qgis canvas but it is not loading the selected features without where condition it is loading the lAYER. canvas = qgis.utils.iface....
0
votes
0answers
21 views

Creating 3D Geo-Database System with QGIS

Currently I am working on a project to create a Virtual 3D City Model. I have Digital Aerial Photos, Digital Terrain Models, Geo-referenced Thematic Data, 3D Geodata, Digital Architecture Models, and ...
0
votes
0answers
12 views

Error occurred in e:\sdk\vc9\gdal-2.1\gdal\ogr\ogrsf_frmts\openfilegdb\filegdbtable.cpp at line 717

I was trying to copy feature classes from file gdb to postgresql using ogr2ogr. Although some feature classes are copied successfully, I encountered some errors while copying other feature classes. I ...
0
votes
1answer
33 views

pgrouting to calculate distance using a chosen highway system

I am working on a research to calculate the distance of firms (scattering around the nation) to several metropolises via selected national highway system. Then I overlay the highway map with firms' ...
5
votes
1answer
250 views

Error installing PGRouting database extensions

Im trying to install pgRouting and I cannot reach the end of the way because of the following error: psql:/home/user/share/postgresql/contrib/pgrouting-2.0/pgrouting.sql:2459: ERROR: could not load ...
1
vote
1answer
243 views

What is the difference between ST_GEOMETRY and WKT?

What is the difference between ST_GEOMETRY and WKT? Is ST_GEOMETRY just a database type and WKT (well-known text) is a textual representation of the data?
0
votes
1answer
21 views

How to count point attributes that fall within a polygon in postgis?

I have a point shapefile called pointA that has a field called fieldB, and a polygon file called polygonC, and I want to calculate the sum of fieldB for all the points that are within polygonC How to ...
0
votes
0answers
16 views

Upload raster to postgreSQL

I have a raster and I need to upload it via web interface into PostgreSQL table when I need to upload my file CREATE TABLE public.eau_param_hydro ( rid integer NOT NULL DEFAULT ...
0
votes
0answers
23 views

QGIS crashing when trying to open PostGIS layer

I'm trying to open a fairly large dataset from a postgres database in QGIS. The table contains over 100 million rows, and it about 60gb in size. When I try to open this table in QGIS (have tried 2.8 ...
2
votes
1answer
46 views

CityGML: Calculate orientation and inclination angles from a polygon's LinearRing coordinates

I have multiple CityGML files of different cities. Only one of them is in such a good condition that it includes the orientation and inclination angles of every roof polygon (as a gen:stringAttribute)....
0
votes
1answer
48 views

CartoDB JQUERY function init() fail

Simply attempting to toggle layers using cartdb and jquery much like this tutorial. After sniping the console I get init() is not defined? However this only occurs after adding the 4th button (#...
0
votes
1answer
13 views

Problems with conversion of multilinestring to linestring

I'm trying convert a column of datatype multilinestring to linestring using it sql ALTER TABLE streets_nordeste ALTER COLUMN geom TYPE geometry(linestring,3857) USING ST_GeometryN(geom, 1); But the ...
2
votes
1answer
54 views

Shapely & RTree vs. PostGIS/PostgreSQL?

I would really like some insight to the pros and cons of one approach versus the other. I recently wrote some python code that inspects two layers of the same test ESRI GDB file using RTree (bounding ...
8
votes
2answers
3k 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
2answers
35 views

Creating a table that stores Distances and other column

I am looking to run a query to calculate the distance from a polygon to other features (will use this query on point, polygon, and line features) within 2 miles and create a table that will display ...
1
vote
3answers
32 views

Calculating the area of polygons within bigger polygons

I work with PostGreSQL and have 2 tables, both in EPSG 2950: Table 1 has a couple of big polygons and table 2 has smaller polygons that INTERSECTS with the polygons of table 1. I am looking for a ...
1
vote
1answer
32 views

shp2pgsql-gui not work after Ubuntu update

I'm using Ubuntu 14.04 with postgres-9.5 and postgis 2.2.2. Previously I performed shp2pgsql-gui to access the interface, but now, the terminal shows me this message: the program shp2pgsql-gui not ...
1
vote
1answer
605 views

How to insert Google Maps API Lat/Long into PostgreSQL Postgis GEOMETRY(GEOMETRY, 4326)

I'd like to begin by saying that I have very little knowledge and understanding when it comes to GIS (despite extensive experience with Google Maps API). PostGIS appears to be a whole new ball game on ...
0
votes
1answer
35 views

In cartodb, how to automatically update the_geom with new longitude and latitude?

I am currently posting new table row using the cartodb sql api with the following commands: update {table_name} set geom = ST_Transform(ST_SetSRID(ST_MakePoint(latitude, longitude),4326) latitude and ...
1
vote
1answer
176 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 ...
1
vote
1answer
58 views

From a lat/lng point, load data clusters of other lat/lng points within radius using PostGIS

Very similar to how Zillow's mobile app mapping search works, I'm trying to pass in the lat/lng points & radius (meters) of a single user and then, on the fly, generate clusters to enable passing ...
0
votes
0answers
20 views

Node Mapnik PostgreSQL vector tiles Question

I am pretty new to Mapnik and Node. I don't understand much so far thats why I have some questions and it would be nice if someone who knows the topic has time to answer. I set up a an OSM database ...
0
votes
1answer
197 views

pg_dump Database that was populated with osm2pgsql

Is it possible to dump a postgres database that was created with osm2pgsql and a .osm.pbf file with pg_dump and import this into a remote postgres database? After running osm2pgsql the database is ...
1
vote
0answers
23 views

Using Postgresql/PostGIS/Pgrouting in PYQGIS Processing Scripts

I have started exploring PYQGIS scripts and learning writing PYQGIS user scripts in python. I want to use pgsql/postgis/postgresql in the script. Please suggest Also Can anyone suggest That the ...
0
votes
0answers
33 views

Is ST_Geom included in AWS RDS postgres 9.5?

I have a database instance on AWS RDS using postgreSQL 9.5. I am using ArcGIS desktop 10.4 and connecting to this database. The Arc docs mention needing to place the ST_Geometry.dll in the postgres ...
3
votes
1answer
201 views

GROUP BY on geography in postgres 9.4.0 returns wrong/different results

table definition: CREATE TABLE search ( id bigserial NOT NULL, location geography(Point,4326) NOT NULL, location_aggregated geography(Point,4326) NOT NULL, created timestamp with time zone ...
0
votes
1answer
43 views

Problem with loop for pgr_Dijkstra

I try to use pgr_Dijkstra through Postgis and Pgadmin to find the shortest path in a network between a lot of nodes. So I thought I could to "automate" the process with a PLSQL query. Here is a query ...
0
votes
1answer
257 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
27 views

ST_Contains. Check for true/false in Python cursor

I would like to create a list of toponyms, which are within some distance from a point. I have calculated a buffer (dbrows_transf_back) and now I am checking if toponyms from a gazetteer (dbrows_os) ...
1
vote
2answers
248 views

Utilizing OSM Data in a Postgres/PostGIS database in ArcMap

I've been trying for over a week now, and I'm not sure what i'm doing wrong and I haven't found the answer yet. I am trying to display and symbolize the OSM dataset over Jordan in ArcGIS for Desktop ...
1
vote
1answer
22 views

How to load specific PostGIS features from a given table into QGIS?

I have a table in my database built like this: contour_id / (INT) project_id / (INT) contour_lvl / (INT) contour_geom (MultiLineString Geom) Each row in this table is a contour feature associated ...
2
votes
0answers
28 views

Error editing 'editable' view in QGIS

Taking some code from this post, I've been trying to create an 'editable' view in PostGIS. I'd like to store label placement properties in a separate table, build a view of the data I want to use for ...
0
votes
0answers
41 views

Timezone map including territorial waters

I have a project that requires timezone lookup for given coordinates. http://efele.net/maps/tz/world/ is an awesome resource however the polygons only cover land. Sydney Harbour is considered seas in ...
3
votes
1answer
347 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.
4
votes
1answer
4k views

How to import QGIS Raster into PostGIS

I have created a IDW heatmap using QGIS 1.8.0 and need to import the raster into PostGIS 2.0.1. QGIS saves the raster layer as a .asc file. How do you import the raster into PostGIS as a Raster? What ...
0
votes
0answers
41 views

Read a vector layer from a Postgres/PostGIS database via a SQL query with QGIS and ogr in a python script

I have a treatment table for different aggregation stategies on a geospatial table in a PostgresSQL/PostGIS database. The aggregation strategies addressing temporal and species specific pre-selections ...