1
vote
1answer
66 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 ...
1
vote
1answer
55 views

Problem with using a circle as polygon for querying PostGIS

I'm trying to query PostGIS and find some object features that intersect with a circular buffer created by the user using OpenLayers, JavaScript and PHP. I use the following code for creating the ...
2
votes
1answer
52 views

Problem with reading data from PostGIS as KML file using PHP

I am using the following PHP code in order to read data from PostGIS and save it in KML format as a file. When I load the page a document with ".PHP" extension is returned (not .kml) which inside has ...
2
votes
2answers
64 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 ...
1
vote
0answers
83 views

pgrouting php problem “pg_fetch_result(): Unable to jump to row 0 on PostgreSQL result index 3”

I'm trying to build a simple routing web-app using pgrouting, followed some tutorial and the latest workshop. Because I'm using PostgreSQL 9.3(x64), Postgis 2.1.1, and pgrouting 2.0 so I did some ...
0
votes
1answer
40 views

Issues with pgrouting workshop code in postgis 2.11/pgrouting 2.0

I'm having issues getting the pgrouting workshop to work on Postgresql 9.2/PostGIS 2.11 and pgrouting 2.0 on windows. How can I rewrite the following php/sql code and make it compatible with my ...
0
votes
0answers
49 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"); ...
0
votes
0answers
22 views

Find optimal path among multiple locations in PHP

I want to find the optimal path for a given number of cities. Path should be calculated using latitude, longitude of each city. Each city can be traversed only once. (Obviously I does not mean ...
1
vote
1answer
167 views

Buffer along a route

I'm using Googlemaps service to plot some marker on the map. All markers are stored in a postgresql table, named "locations" and that has a location column (data type to geometry). When the user ...
1
vote
1answer
146 views

Shortest path for a given waypoints

I have an application where the user selects some "markers" from a google maps (all those coordinates' markers are stored into a postgresql database). Right now, I can draw the route between all ...
0
votes
2answers
218 views

PHP PostGIS to geoJSON missing required parametar error

I'm using this PHP PostGIS to geoJSON script: https://gist.github.com/bmcbride/1913855 But I keep getting this error: 'missing required parameter: geotable' This is my code: # Retrive URL ...
1
vote
2answers
178 views

How to get .csv file into postGIS

I am using this: COPY data_table (col1,col2,col3) FROM 'datafile.csv' DELIMITERS ',' CSV HEADER; to get csv data into my postGIS table. It works wonderfully, except I need to have a 'pk_id serial ...
2
votes
1answer
453 views

How to get polygons from PostGIS table to PHP array best?

Currently I fetch polygons from a database table using ST_AsText(). The results are in text format, like the following. POLYGON((84 104,212 48,321 122,243 179,275 238,131 240,84 104)) I am not ...
0
votes
1answer
169 views

What should I start with WebGis Mapserver?

I'm not native English Speaker and I'm a graduated student who want to have a master degree in software engineering. I have a thesis relative with "Build a WebGis for air pollution in Vietnam's ...
-1
votes
1answer
99 views

Shp2pgsql - exec() not allowed on external server

Me and my collegue are using the shp2pgsql and psql commands in php code (a Drupal module to be precise). We put these commands in a php variable and use the exec() command to execute them. This ...
1
vote
4answers
556 views

Query Postgis Table with PHP

Would you be so kind as to help me with the following in OpenLayers. I need to be able to use the coordinates from a user click in a postgis query. To catch the coordinates of a click I built a click ...
1
vote
0answers
668 views

searching GeoJSON features

After googling for many days and reading the OL documentation, I don't understand well how the filterToParams in OpenLayers.HTTP protocol should work, what I'm trying to do is to find and display the ...
1
vote
1answer
273 views

osm2pgsql import crashed!

I am currently importing a bz2 country file into PostgreSQL 9.1 database for Nominatim 2 using its setup.php that runs osm2pgsql. After processing the nodes. it seems to be stuck at a certain spot ...
1
vote
2answers
1k views

How to display a image from Postgres database

I have Images in bytea form in PostgreSQL/PostGIS database, i want to display them in a webpage using PHP - PostgreSQL. I got lot of examples and I worked out but not getting output from them... Few ...
2
votes
1answer
1k views

How to insert google maps lat/lng into postgis in geometry datatype

I came across: https://developers.google.com/maps/articles/phpsqlinfo_v3 I've changed the code a bit and all process is well done for postgis database. I get the data from infobox when user clicked. ...
1
vote
1answer
248 views

Geographic Web Service

I was told to implement a web service which, given 2 inputs (street name, cross street name) the output is the crossing geographical coordinates. What is the best way i should go? Is there a standard ...
0
votes
2answers
1k views

How to insert a point into postgis from php?

For the following line, I received an error in my php page, but the query is OK when I run it from pgmyadmin. I am trying to insert a point into my postgis from php which contains name, address and ...
2
votes
1answer
2k views

KML PHP parser to INSERT into database

So I have a KML file which has attribute data(Inside the tag with about 12 data points). This file was generated on ArcGIS. I'm trying to write a PHP script to parse this KML file and insert the ...
11
votes
4answers
1k views

Options for displaying PostGIS rasters in OpenLayers

This question is similar to an earlier question about displaying vector data in a web-map. I want to have a basic web interface which uses OpenLayers and can display raster data that is currently in ...