PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
2
votes
1answer
32 views
Are there open source solutions for travel demand modelling?
I'm looking for open source tools for travel demand modelling (eg The four-step UTMS). Preferably in a GIS environment. That works well with Qgis, Grass and Postgis.
My question is not related to ...
1
vote
0answers
38 views
save features from openlayers to postgis via nodejs and websockets
I try to save features created on a vector layer (openlayers) to postgreSQL 9.1/postGIS 2.0 via websockets.
As server I use nodejs 0.10.12 along with the pg module
I cannot fix it. Its getting so ...
0
votes
1answer
36 views
Multiple Rasters into PostGIS
This may have been asked before, but
A) what software/libraries etc do I need to
B) load multiple rasters into PostGIS?
I have Python 2.7.5, QGIS 1.9 (latest Weekly Build), PostGIS (whatever the ...
1
vote
1answer
25 views
Spatial Aggregation of attributes from line structures in polygons
maybe someone has an idea how to deal with it (or directly knows the equivalent functions in PostGIS) for the following problem:
I have a transport network (something like railways) and the ...
0
votes
0answers
16 views
execute raster2pgsql in php script
I have a geotiff Rasterimage and I want to import it to PostGIS via php. I'm using windows server 2008 with ms4w 3.0.6 installed.
My php code looks like this:
include ("db.php");
...
1
vote
1answer
43 views
nearest neighbor with postGIS and nodejs
I'm using postgreSQL 9.1 , postGIS 2.0, nodejs 0.10.12 and the latest version of node's pg module.
I use websockets on the server side. I implemented a function that tries to find the 5 nearest ...
0
votes
2answers
32 views
How to create a MultiLineString feature with a postgis layer in QGIS
I have troubles handling with MultiLineStrings in QGIS.
I added the table where I defined a column as geometry(MultiLineString, 31468) as a postgis layer in QGIS. Now I want to create features with ...
0
votes
1answer
43 views
Why won't OGR connect to my PostGIS database, but QGIS will?
Trying to connect to my PostGIS database with some success...
One hiccup is that OGR will not connect to my server from a remote machine, though QGIS can connect to it just fine from that same ...
7
votes
4answers
112 views
How to use PostGIS to handle complex geoprocessing workflows?
Our organization is considering moving our geoprocessing workflow to PostGIS. We are currently using ArcGIS, with a plethora of custom Python tools used in ModelBuilder. We're moving most of our data ...
3
votes
0answers
45 views
Maritime route prediction avoiding land masses
I am working on a project where the following functions have to be implemented:
Predicting the locations of the ships (in maritime environment) at a future time. (Can be done with Kalman filter, IMM ...
1
vote
1answer
22 views
st_intersects on postgis
I'm trying to write a command to see whether a given point lies within a multipolygon boundary (in this case, a watershed). I have a table of watershed boundaries and another table with the point I'm ...
0
votes
0answers
24 views
Getting longtitude lattitude from wfs on geoserver
i am making campus information system using geoserver, postgis and openlayers. on the javascript side i want to zoom selected classroom longtitude and lattitude (as google maps done--when you type any ...
1
vote
0answers
42 views
What is the MS SQL Spatial syntax for counting points within polygons? [duplicate]
All,
What I'm trying to do is this:
Count points within polygons
There are thousands of points and maybe 2 dozen polygons
Get a list back of the 2 dozen polygons by name and the count of points ...
0
votes
1answer
30 views
OS Vectormap GML files into PostGIS
I am having difficulty in efficiently dealing with OS Vectormap data that comes in GML format.
In the past I used the Plugin for QGIS (OS GML Tools) to batch convert folders of compressed GML (.GZ) ...
0
votes
0answers
11 views
ERROR: CASE types geomval and geometry cannot be matched
I am trying to optimise the speed of the intersection query that I am running.
However, I am struggling to find the best way to do this. And found a similar bit of sql that looks like it would do ...
