New answers tagged mysql
If you can access one server from the other you can use ogr2ogr to do a direct export from PostGIS / import into MySQL. MySQL ogr driver page PostGIS ogr driver page
Please check out https://github.com/klokantech/tileserver-php/ might be helpful for you.
If you have tiled map in MBTiles format, you can serve them using ordinary PHP script. All you need is php-sqlite module, which should be included by default. You can try this: mbtiles-php - I'm using similar script in production. With some kind of URL-routing library, you can even simulate standard TMS. Actually, you also can write your own WMS ...
You could use TileMill to make tiles as MBTiles: https://www.mapbox.com/tilemill/ Then use something like python-mbtiles to serve it up: https://github.com/perrygeo/python-mbtiles.
$sql = "SELECT points.name FROM polygons, points WHERE ST_CONTAINS(polygons.geom, Point(points.longitude, points.latitude)) AND polygons.name = 'California'";
Your best performance would be obtained by storing the location as a point geometry (longitude,latitude), building a spatial index, and using a search shape which is geodetically correct (an egg-shaped 'circle', which is the search distance deprojected into a geographic reference system). 37 vertices is more than enough points to achieve 99% of the area, ...
MS SQL Server includes spatial functions, but the functions are usually named differently, for example PostGIS's intersect function is named ST_Intersect and in SQL Server it is called STIntersection. Your best bet to migrate would be to use ogr2ogr to move your data from Postgres to MS-SQL, then you'll have to re-write any queries you're using in Postgres. ...
Top 50 recent answers are included