PLEASE MAKE SURE YOU BACKUP YOUR PUBLIC SCHEMA ! Steps: Open up pgAdmin III and connect to PostgreSQL. Select desired database and click on schemas
read morePlease check geometry_columns table if the result return `-1`. You may change the srid value if you knew the value of the target table. Value
read moreST_AsText – represent geometry as WKT ST_Transform – transform geometry from one projection to another ST_GeomFromText – represent WKT as geometry Reference: PostGIS 1.5 Manual
read more
Android, Development, JSON, MySQL, PHP, PostGIS, PostgreSQL
Search keyword: android connect to php Here, I’m going to show the simplest way to connect to the PHP in Android – receiving JSON(JavaScript Object
read moreJust a note, do run ‘legacy.sql‘ when migrate from PostGIS 1.5 to PostGIS 2.0 because there’s functions being removed from 1.5. so we need it
read more