Tag Info

New answers tagged

1

All four of the databases you listed have the capability to support the type of query you're asking about. SQLite and Postgres through extensions (Spatialite & PostGIS respectively), mySQL and MariaDB have some basic GIS support built in natively. As to which to use, it depends on your needs. Personally I go with SQLite for simple in house ...


2

The actual answer is a mixture of the other answers/comments you've already received. MySQL is limited I see from the tags you're using MySQL, the problem is, it can only do bounding boxes until 5.6, not the actual geometries. http://dev.mysql.com/doc/refman/5.0/en/spatial-relation-functions.html If you want to use the bounding box: SELECT * FROM `test` ...


2

From the longitude and latitude coordinates, you can create spatial structures (Points) in your (spatial) database, like PostGIS. (see ST_GeomFromText) Instead of your bussId | longitude | latitude, you would have a bussId, Point database called BussSpatial. You can then just query the following var request = 'SELECT bussID FROM BussSpatial ...


1

The bounding box query for SQL is(Using PDO) $sql ="SELECT bussid FROM tablename WHERE(latitude BETWEEN ? AND ? )AND (longitude BETWEEN ? AND ?)"; $stmt = $dbh->prepare($sql); // Assign parameters $stmt->bindParam(1,$minLat); $stmt->bindParam(2,$maxLat); $stmt->bindParam(3,$minLng); $stmt->bindParam(4,$maxLng); WHERE parameters come from ...


0

thank you for your attention, i am newbie with geotiff and i'm sorry about my questions, i cant install php-gdal,and cant work with that , i think this plug in is for linux OS , but i worked on SRTMGeoTIFFReader and this is what i give i just want the coordinate of 4 corner of my geotiff pic like this : Corner Coordinates: Upper Left ( 69.7357061, ...


0

there is a php extension called php-gdal I found some install instructions: https://www.drupal.org/node/2133103 the main site: https://github.com/geonef/php5-gdal helpful? http://dl.maptools.org/dl/php_ogr/php_ogr_documentation.html I looked at scruss' suggestion: ( How to read GeoTIFF using PHP? ) and downloaded the code to take a look at. I'm not ...



Top 50 recent answers are included