To elaborate on synecdoche’s answer, the SRID is sometimes called an “EPSG” code. The SRID/EPSG code is a defacto short-hand for the Well-Known-Text representations of projections. You can do a quick search on the SRID table to see if you can find an exact or similar match: SELECT srid, srtext, proj4text FROM spatial_ref_sys WHERE srtext … Read more
graphs databases like Neo4j are a very good fit, especially as you can add different indexing schemes dynamically as you go. Typical stuff you can do on your base data is of course 1D indexing (e.g. Timline or B-Trees) or funkier stuff like Hilbert Curves etc, see Nick’s blog. Also, for some live demonstration, look … Read more
From the manual: PostGIS has begun a transition from the existing naming convention to an SQL-MM-centric convention. As a result, most of the functions that you know and love have been renamed using the standard spatial type (ST) prefix. Previous functions are still available, though are not listed in this document where updated functions are … Read more
The KML can’t be accessed since it’s on your local machine and google can’t access that since it doesn’t know how to get to localhost:8080