Tagged Questions
2
votes
1answer
79 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 ...
0
votes
0answers
13 views
QGIS Connection PostGIS and shapefile
I'm working on QGIS with a database created in PostGIS and a shapefile. Inside the database, I have geometry type data about location of some points, instead on the shapefile there some selected ...
1
vote
2answers
24 views
Searching planet_osm_point by longitude and latitude
I used osm2pgsql to import data into my PostgreSQL database and it put gave me the following 4 tables, planet_osm_point, planet_osm_line, planet_osm_polygon and planet_osm_roads.
I have looked at ...
2
votes
0answers
91 views
+50
Raster slightly displaced after exporting from PostGIS database
With the following queries I've exported a raster (GTiff) from my postgis database:
1.Creating a large object:
WITH buffer AS (
SELECT
id,
ST_Buffer(geom,50) AS geom
FROM ...
-2
votes
1answer
22 views
How can I draw a polygon over a mapserver map and save it into a postgresql/postgis table? [on hold]
I have to draw few polygons over a mapserver map.
How can I save it into a postgresql/postgis table?
How to do this using PHP/js? Please share any useful links.
1
vote
1answer
19 views
How to get the data type of each column from a postgis table
I need to get the column data types of all columns in a table, including the geometry types. What I wanted to know is if there is a function or SQL that gives something like this:
column_name | ...
0
votes
3answers
123 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 ...
0
votes
1answer
3 views
How to get a distinct pair of column values based on minimum of another (computed) column?
I have two tables with point geo data, one (sfc_obs) with weather stations (names), one (smos_grid) with satellite pixels (dggs), and I'm trying to find which dgg is closest to each name using ...
3
votes
0answers
23 views
Compute visibility graph on sphere
I have a PostGIS table with some polygons (stored using the geography data type). They represent regions on a spherical earth.
For each pair of vertices chosen from among all the polygons, I want to ...
2
votes
1answer
20 views
Only Draw Geometric Objects Above 8th Parallel North
I have many geometric objects (in both SRID:4326 - the_geom - and SRID:3857 - the_web_geom - in PostGIS extension tables of PostgreSQL), including country boundaries, for the country of Ghana and I ...
1
vote
2answers
55 views
How can I speed up these queries
I am trying to make some calculations using PostGIS and PostgreSQL. There are 3 important tables : wbn, wgo and wvb. These tables have about 500.000 objects in them (geometries). The problem is that ...
1
vote
0answers
27 views
Focal Mean of neighbors using ST_DWithin on points in PostGIS
I'm trying to calculate focal means on a grid of points in PostGIS.
I know that a raster calculation would be more efficient, but I only need to run the algorithm once to get the data, so I don't ...
1
vote
0answers
22 views
PostGIS 3D Extrude function
I selected buildings from OSM (which represents my city). I insterted a new column 'height' and I filled with a random number exactly number 2, so every building have 2metres altitude. Buildings are ...
2
votes
1answer
111 views
assign_vertex_id：problems when creating the node ids
Before using pgrouting, I have to create the node ids.
I loaded my polyline layer into PostGIS Manager：
I type this in SQL query：
select assign_vertex_id('split_4', 800, 'geom', 'gid')
But as ...
1
vote
1answer
70 views
What index to use in this situation
I am working with 3 tables with 3 x 500.000 rows. There is one colomn that gives each object a unique ID (UIDN), there also is a colomn with the geo data (the_geom). There also are some other columns ...
1
vote
2answers
262 views
Function for Selecting Points in a Polygon
I've been banging on this for a few hours, but since I'm relatively new to PostgreSQL and PostGIS, I can't find the solution. I'm trying to create a stored procedure (function) which will return all ...
3
votes
1answer
50 views
MS SQL Server 2012 to Postgresql
How to use MS SQL Server 2012 spatial database in postgresql using foreign data wrapper?
0
votes
1answer
276 views
SELECT assign_vertex_id('ways', 0.00001, 'the_geom', 'gid'); not work
I'm using using OSgeo 6.5 dvd and studing pgrouting workshop (link) for get shortest path. I created network topology call "pgrouting - workshop". There are three commands to execute in section 5.2 ...
3
votes
1answer
175 views
Hibernate Spatial - 'Invalid endian flag value encountered' Exception
I'm trying to run a simple query in Hibernate Spatial 4.0 on PostgreSQL 9.3. I have a number of objects in a table with latitude/longitude values, and I'm trying to query objects that fall within a ...
1
vote
1answer
30 views
3D functions with SFCGAL in PostGIS
I have this setup: "POSTGIS="2.1.2 r12389" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8" LIBJSON="UNKNOWN" TOPOLOGY RASTER" on ...
1
vote
2answers
38 views
What is the best way to take a WKB value in SQL Server Management Studio and create a PostGIS geometry in PGAdmin III?
Normally, I would just use WKT strings but I'm investigating some possible geometry weirdness with the Text methods in SQL Server. I would like to copy/paste the WKB values from the SQL Server ...
0
votes
0answers
61 views
How to save a google map direction into a postgresql/postgis database?
I have taken a direction(route) from google map.
Can I save this resultant direction/path/route to my postgresql/postgis database? How?
2
votes
2answers
40 views
Do I still have to use a template DB for PostGIS?
createdb mydb -T template_postgis
Is this -T template_postgis still necessary in new versions of PostGIS?
I never saw this db being different, it always has those 3 sql files you run there. Is this ...
1
vote
1answer
23 views
convert XML to PostgreSQL using MATLAB
In a weeks time I should be able to transfer the GIS data provided in the XML format to PostgreSQL database. I have prepared the PostgreSQL database (empty) and looking at Matlab scripts. (I am on ...
3
votes
1answer
691 views
How to use the pgRouting TSP function?
For more than two days I'm trying to make the TSP algorithm work in PostgreSQL/PostGIS. My problem seems to occur when I'm trying to take into account the road network for TSP algorithm. I know that ...
1
vote
0answers
44 views
Display postGis query result on Google maps Api [closed]
I have MULTILINESTRING Geometry in Postgis and as Google Api does not provide any way to plot
MULTILINESTRING , i'm converting MUltiLINEstring to LINESTRING through ST_Merge function.
But when i'm ...
2
votes
1answer
23 views
Update/refresh edited PostGIS table in QGIS
I imported a PostGIS table (with geometry) from my PostgreSQL database as a layer in QGIS.
Later, I edited the table using PostgreSQL UPDATE commands.
Is there a way to quickly update (like a refresh ...
1
vote
0answers
22 views
qGIS' Database Manager “Load as New Layer” Option Not Working
I'm trying to visualize some of my database queries on qGIS. I run a valid SQL query which returns a subset of my table that should be easily loaded as a layer. I then check "Load as new layer," ...
2
votes
1answer
30 views
pass an array of geometry to postgresql function
I am trying to pass an array of geometry to a postgis function using JDBC with JAVA:
CallableStatement proc = conn.prepareCall("{ ? = call somefunc(?) }");
...
0
votes
0answers
24 views
OpenStreetMap Road and Polygon Data as 1x1 Degree Shapefiles
I am working on a global project for which I want to use OSM data as a model input. I am looking for advice on the best way to produce 1x1 degree WGS84 shapefiles from either regional extracts or the ...
1
vote
1answer
215 views
pgrouting shortest path result in wrong order
I am using the Dijkstra shortest path algorithm to plot a route between two points using the latest version of pgrouting in postgresql 9.1 with postGIS 2.0.1.
I am able to get a correct result ...
3
votes
3answers
192 views
osm2pgsql --hstore
I'm working with postgreSQL 8.$ and PostGIS and I need to import osm file to database. I tried it with utility osm2pgsql, but I have problem with hstore extension. Does anyone know how to solve this ...
0
votes
1answer
31 views
PostGIS transform geometry with long crs
How do i transform a geometry to a new geometry with a crs like urn:ogc:def:crs:EPSG::25832
st_transform(geom,integer srid) obviously doesn't work since my srid is a string
found a solution
...
1
vote
1answer
49 views
Routing in MS SQL 2012
I would like to perform routing in MS SQL 2012 similar to pgRouting.
In pgRouting, I'd do the following steps to create a routable network:
Create a database routing with template template_routing
...
2
votes
1answer
47 views
polygons and lines not drawn correctly (qgis+postgis)
i am really new to this so i could use some help..
i load osm file into postgresql and then i connect to the database with qgis t to plot it and i see this
it happens to whatever file i import to ...
1
vote
0answers
19 views
Problem installing Aggregate Polygons Function in PostgreSQL 9.3
I'm new to PostgreSQL and I've been trying to run a sql function written by Dr. Horst Duester, found in http://www.kappasys.ch/cms/index.php?id=65&L=5, which is used to aggregate detached ...
0
votes
1answer
76 views
Why is ArcMap leaving connections “<IDLE> in transaction”?
The TL;DR version: When you use ArcMap Query Layers to access a PostgreSQL table, ArcMap's database connections are almost always sitting idle in unclosed transactions. Why would this be?
I have ...
2
votes
1answer
84 views
System requirement specification for Big Data Postgesql, PostGIS, and GeoServer based service
I want to start a GIS portal for around 3000-5000 visitors per day. MY database will be of an approximate size of 10 Terrabytes. The maps and layers are moderately complex, satellite-map overlay is ...
3
votes
1answer
99 views
User locking postgres/postigs table without privileges
I have a PostgreSQL 8.4.4 database with PostGIS 1.4.2 and I am experiencing a problem where an external GIS system (using embedded CadCorp SIS 7.0) is connecting to the database and taking Access ...
0
votes
2answers
193 views
I have a database in PostGIS, is possible using CartoDB? or I need another map server?
I have a data base in PostgreSQL/PostGIS, and I want to offer to my users a way of visualize it, Is it CartoDB the best option? It is possible? Or which is the best option around?
(Please provide ...
1
vote
0answers
39 views
Geoserver WFS Fails to Load in OpenLayers
I'm working with Postgis->Geoserver->openlayers on localhost. I followed a Geoserver tutorial to import some nyc sample data into my postgres/postgis database and link it to Geoserver. The layer ...
0
votes
0answers
25 views
PostGIS: calculate width/length of rectangular surface
I have rectangular shaped surfaces (multipolylines) and I need to calculate the width and/or length.. they have a rectangular shape but they're not real rectangles.
Is there a way to do this ?
0
votes
1answer
37 views
Increase Map Availability in Geoserver [duplicate]
I have an application which access same map from two geoserver using loadbalancing concept
the map is accessed using WMS service.
where the two geoserver connected to a single same POSTGIS database.
...
0
votes
0answers
7 views
PostgreSQL : send all rows of a table to a function [migrated]
I have a table with one column (double precision numbers). I also have made a function (with double precision numbers as input and output), and I want to send every value of my table to the function, ...
1
vote
2answers
202 views
Start postgresql+postgis without installation on Windows
I have used Windows7x64 and want start PostgreSQL+POSTGIS without installation process. I copy PostgresSQl\9.1 folder from other laptop to c:\opt. I need create .bat file with enviroment variables and ...
3
votes
2answers
904 views
osm2pgsql Error: operator class “gist_geometry_ops” does not exist for access method “gist”
When using osm2pgsql to import massachusetts-latest.osm.bz2 into PostGIS 2.0.1 database osm (running on PostgreSQL 9.1 on an Ubuntu 12.04), I get the error failed: ERROR: operator class ...
1
vote
1answer
415 views
Having trouble connecting QGIS with postgres database with postgis extension
I am working on Ubuntu Precise with postgresql version 9.3 and postgis 2.0.
After initially starting my postgres database and eventually getting permission errors that would prevent postgres from ...
0
votes
0answers
21 views
Double version of PostGIS installed on my server
For some reason I messed up an installation of Postgis on my PostgreSQL 9.2.8 server. I had version 2.0.3 installed and when I tried to upgrade to 2.1 it did so. The problem comes when I dump the ...
4
votes
2answers
141 views
clustering points in postgresql to create contour map
UPDATE:
To try to make this a little more simple, is it possible to create a query which selects a group of points such that each point in the group is at most X units away from at least one other ...
0
votes
0answers
28 views
PostGIS 2.1 error install with shared object (rtpostgis-2.1.so") Linux Mint
I've Installed Linux Mint 16 mate and install PostGIS with PostGreSQL (I've tried many ways in the Internet from original source to some suggestion) but all is too error: "
ERROR: could not load ...
