PostgreSQL is an open source object-relational database system.
1
vote
1answer
25 views
PostGIS : I want to use ST_OffsetCurve with MultiLineStrings
I need to use the function ST_OffsetCurve for a multilinestring, but PostgreSQL gives me the error that the function is only for Linestrings. Is there a way arround?
I want to use the function ...
0
votes
0answers
15 views
CartoDb - Aggregate and Infowindow
I'd like to use CartoDb to map historic addresses of a city (link to demo). Individual addresses are mapped as points on the map. Detailed information for each address point should be displayed in the ...
0
votes
0answers
33 views
Need some help with this PostgreSQL/PostGIS matter [on hold]
I am trying to do something in PostgreSQL/PostGIS but I need some advice for a workflow, as I'm quite new in the PostgreSQL world.
I have a table called lenghts, with 4 columns (an ID and 3 values), ...
4
votes
1answer
48 views
pgAdmin vs psql
I have downloaded postgreSQl 9.3 and Postgis 2.1 recently as an educational adventure and have been working with both through the pgAdminIII interface. I haven't used psql yet when working with my ...
1
vote
1answer
33 views
Update postgres/postgis point data attribute from another enclosed polygon shapefile in QGIS
I have
a placename point table in postgis with 'district' column.
a districts polygon shapefile with district name in 'Name' column.
See the image below.
I would like to update the 'district' ...
0
votes
3answers
29 views
GeoServer create layer from PostGIS (data type point)
(Several days ago a user on gis stackexchange suggest that I should use OpenGeo (I was using geojson before). I succeed at what I was doing at that time, but now I have a different problem.)
I was ...
1
vote
2answers
43 views
Is it possible to run a spatial query in QGIS 2.0 across multiple layers using a user-specified radius from a point?
I would like to be able to click on a point on a map to select all vector features (from multiple layers) within a specified radius of the point. Can anyone point me in the direction of how to do this ...
1
vote
0answers
20 views
How to define Z dimension on table with PostGIS for import in TileMill?
I'm trying to reproduce the idea behind this blogpost from Mapbox, but with other data, for example the ne_10m_populated_places_simple dataset from Natural Earth. By adding a z-dimension to the data ...
2
votes
1answer
48 views
Length of a line within a surface
I need to find out the lengt of each line within a surface. I have approx. 20'000 diferent lines and around 10'000 different surfaces. what kind of SQL-sentences do I need to use? I've tried things ...
2
votes
1answer
24 views
ST_ZMax() does not exist in PostGIS
I'm trying to follow this example on Mapbox blog, about using 3D shapes in PostGIS.
The database-query is this:
DROP TABLE tilemill_buildings;
CREATE TABLE tilemill_buildings
AS SELECT
ogc_fid,
...
2
votes
1answer
59 views
How to create a buffer on a linestring with varying or increasing/decreasing width
I want to buffer rivers/streams for a topographic map. I'm using a PostgreSQL/PostGIS database. Usually, I create buffer with ST_Buffer with a constant width.
For example, the width of a river buffer ...
1
vote
0answers
25 views
QGIS loads PostGIS layers but DBManager can't connect
DB Manager can't connect to PostgreSQL, but "Add PostGIS Layer" can.
My eventual goal is to save created layers to PostGIS. I assume I can do this using the DBManager Tool. I can alternatively use ...
2
votes
1answer
46 views
PostgreSQL : total length of roads in polygon
I have 2 tables : wgo (lines) and wbn (polygons)
With this code, I can display the length of each road inside a polygon. If I have a polygon with 2 roads in it, as a result I get 2 rows with the 2 ...
2
votes
1answer
51 views
PostgreSQL : finding all lines intersecting with a polygon
I am totally new in the world of GIS but as a student surveyor I am working on a project using postgreSQL and PostGIS.
I have one database with all the roads of my country (lines), and one database ...
2
votes
2answers
87 views
Postgres Log Error
I am using Geoserver + GeoWebCache + Postgres for an application. On the application side there is no bugs but on postgres I am getting this log. Please explain and help me to solve this
...
0
votes
0answers
24 views
pgrouting shortestpathfromAtoB multiple pairs
I've got to solve a shortest path problem between multiple location pairs. E.g.:
A to B
C to D
E to F
etc.
These pairs are stored in a table routing_basis like
hkey; A; a.lat; a.lon; B; b.lat; b.lon
...
1
vote
0answers
58 views
How do I catch PostGIS/PostgreSQL RAISE messages in QGIS?
I have a trigger set up in PostGIS/PostgreSQL which will show a RAISE WARNING when an inserted or updated polygon is within a certain distance of some predefined planning constraints. I want this ...
0
votes
2answers
19 views
How to set the tolerance value in pgr_createTopolgy function of pgrouting?
I am making a map based on the floor plan of a building.
I made the shapefile and added it to the postgresql database.
I created the topology for the map using the following code:
SELECT ...
1
vote
1answer
32 views
PostGIS ST_Within returns zero data
I am using PostgreSQL 9.3.3 & PostGIS 2.1.1 and I have a table Entries which has a column called "latlng" of geographic type (this column stores entry's latitude and longitude coordinates).
I am ...
0
votes
3answers
103 views
Faster routing algorithm on pgrouting
I have downloaded data for india as a dbf file then converted it using osm2po to make it routable but the problem is when i make any routing query it takes a lot of time around 300 seconds and these ...
2
votes
2answers
47 views
how to Find n nearest lines for the given points from a collection of lines?
I have two tables, points and lines. For each point in point table, I want to find out nearest 3 points in the nearest 3 cables.
I almost developed a query, but it is best suitable for single point, ...
2
votes
1answer
79 views
Postgresql table won't display in QGIS 2.2
I just downloaded QGIS 2.2 to check it out and now one (just the one) of the tables from one of my PostgreSQL database won't display.
It loads just fine in 2.0. The records are all there (there's ...
0
votes
0answers
35 views
Speed drastically reduced when including geometry, is there a way to improve?
-- EDIT: Issue is that the shape files being used are at too small of a precision and way too large, output was 488M total, looking for different source --
I'm having some speed issues with a complex ...
7
votes
1answer
126 views
Replacing a corporate GIS [closed]
I'm looking at replacing our corporate GIS, this is the first time that I have had the responsibility of such a task despite my years of experience with the software as an end user.
We will be ...
2
votes
2answers
37 views
self intersecting polygon SQl
I am trying to write a sql to query one land parcel for intersections between itself. I can do this fairly easy in QGIS using topology checker but i don’t know why this does not produce the correct ...
1
vote
1answer
49 views
Monitoring Geoserver for Production Environment
Is there any opensource server monitoring is available for Geoserver ? Like watchdog and nagios?
Suppose if geoserver is stopped working whether mapmeter will automatically start it..Like the ...
0
votes
0answers
10 views
Postgres self self intersecting polygons and error
I have a land parcel which has self intersecting polygons and I am trying to create a view to select all the distinct polygons but sql query does not generate correct results. The polygon has 500 ...
1
vote
1answer
27 views
How to make osm2pgsql import a tag?
I loaded OSM data into PostgeSQL with Osmosis&Osm2PgSQL, and see many tags are missing. I need to make it import lanes tag. How can I make it save this tag too?
edit: my solution was to copy ...
1
vote
1answer
37 views
Problem with runing a loop in a query in PostGIS
I am new to PostGIS and I have a question which can't solve. I have a table of buildings each having a value for number of people living in it. I would like to calculate the total value (sum of number ...
1
vote
1answer
56 views
Problem with nested query in PhP and PostGIS
I have a simple problem regarding a nested query. I would like to select all buildings in a given circular buffer and create a kml file of those selected objects. The following query does the job very ...
2
votes
3answers
84 views
Problem with result of query in PostGIS
I run the following query and irrelevant of the point coordinates and radius I always recieve all the records of the table I'm querying. Can anyone point out what the problem could be with this query?
...
2
votes
1answer
124 views
Installing Postgis on Ubuntu 12.04: unmet dependencies libgdal1
After sudo apt-get install postgresql-9.1-postgis I got that massage:
The following packages have unmet dependencies: postgresql-9.1-postgis
: Depends: libgdal1 (>= 1.9.0) but it is not going to ...
-3
votes
2answers
45 views
How can i create the spatial queries in QGIS? [closed]
please, Help me. i'll really appreciate your answers.
3
votes
3answers
37 views
Open Street Map: converting to country -> administrative unit -> city database
To moderators: If you think this question is too broad, please point me into right direction before closing, I'm desperately looking for help.
I'm stuck on my task and I don't know what to do. The ...
1
vote
1answer
45 views
ST_Transform not converting from utm to lat/lon
This line:
ST_AsText(ST_Transform(the_geom, 4326))
Returns the "coordinates" as utm coordinates. Although, I thought ST_Transform was supposed to convert the coordinates from utm to lat/lon. I ...
-1
votes
1answer
35 views
plypython set-up
I am trying to set up plypython on the following system:
Windows 8.1
PostgreSQL 9.2 64-bit
PostGIS 2.0
Python 2.7.05
I have added plpython2.dll to \PostgreSQL\9.2\lib
When I run:
CREATE ...
2
votes
0answers
34 views
How do I simplify the straight sections of (multi)Linestring in PostGres/PostGis leaving the curved sections untouched
I have (multi)linestrings containing upwards of 5000 points and I want to perform two simplifications possibly using Ramer Douglas Peucker or alternative methods in PostGis
The (multi)linestrings ...
0
votes
0answers
28 views
display route from database(postgresql) on
For first part: Link
i have postgresql9.1,postgis2,pgrouting2 and qgis2.2
this is the second part of what i need to do:
Search in a database (postgresql with pgrouting) for a line from public ...
1
vote
2answers
45 views
Problem in running query on PostGIS using PHP
Would you kindly help me solving this problem. I'm trying to use the PHP code provided here in order to read geo-data from PostGIS. The code seems clear without any problem (also nobody has ...
2
votes
1answer
62 views
How to write a new layer to PostgreSQL from QGIS plugin
The PyQGIS cookbook states that QgsVectorFileWriter can write vector layers to any format supported by OGR:
https://www.qgis.org/en/docs/pyqgis_developer_cookbook/vector.html#writing-vector-layers
...
1
vote
1answer
47 views
Most Efficient method of Storing Point Data in PostGres/PostGIS to later re-create a track
I am trying to determine the most efficient way to store point data in PostGIS to later re-create tracks
Criteria:
1 second updates
100- 200 tracks active at any one time
1 hour max ...
0
votes
1answer
20 views
How to connect ArcMap 10.0 query layer to a different port?
I have an instance where I have a server that has postgres 8.3 and postgres 9.2 on it. I have the 8.3 version on port 5432 and 9.2 on port 5433. I want to connect to the 9.2 instance, here is a ...
1
vote
1answer
50 views
Add PostGIS spatial functions to a custom schema other than “public” in PostgreSQL
I am new to PostgreSQL and PostGIS.
Recently, I created a PostGIS 2.0.3 database on a PostgreSQL 9.1 database server using pgAdmin. The "PostGIS" extension was found installed in "Extensions". Al ...
3
votes
0answers
52 views
Python Postgres Multiprocessing speed increase
I'm trying to speed up my PostGIS queries using multiprocessing. My current setup is using python and psycopg2 such as below. Although this has given a speed increase, it still seems like there are ...
1
vote
1answer
38 views
How to get mouseposition (openlayers) in decimal degrees?
I want to display the mouseposition in Degree Decimal rather than in meters.
See my code:
<script type="text/javascript">
var map, ia_wms;
function init(){
map = new ...
3
votes
1answer
114 views
Loading Shapefiles into PostGIS using shapefile import/export manager
I am a complete beginner with PostGIS. I've started learning it using the tutorials provided by Boundless. In section 4 of this tutorial where I want to import shapefile in PostGIS, I do not have the ...
0
votes
0answers
34 views
PyQGIS + PostGis: FATAL: sorry, too many clients already
I searched for questions regarding this problem and hadn't find one. I'm developing a custom application with a map canvas to show some geographic information from a PostGis database. After some ...
2
votes
1answer
37 views
How to properly establish a PostgreSQL connection using QgsCredentials
I'm trying to establish a Postgres connection using QgsCredentials as described here:
How to access user credentials in database connection?
The only problem is that I cannot establish a working ...
0
votes
0answers
9 views
Prepare OSM file for PGROUTING use [duplicate]
Well I am new in the GIS World :p
well I have a webGIS to realise and I want use OpenStreetMap.
well the region I need wasn't vectorised so I modified it with JOSM ( Added Roads and buildings) and ...
0
votes
1answer
34 views
Is it possible to render POIs/landmarks from Postgres/postgis DB using google Map like icons?
Is it possible to render POIs/landmarks from Postgres/postgis DB using google Map like icons? Any readily available icon sets?
