Star this Gist to indicate preference for the deeper form (with "when" and "@type") of GeoJSON-LD Time (geojson/geojson-ld#9).
Keith Jenkins kgjenkins
rustprooflabs
/ srid_units.sql
Last active
May 18, 2021 17:32
Creates view in PostGIS enabled database to make it easier to find what units each SRID is in.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE VIEW public.srid_units AS | |
| SELECT srid, CASE WHEN proj4text LIKE '%+units=%' THEN True | |
| ELSE False | |
| END AS units_set, | |
| CASE WHEN proj4text LIKE '%+units=m%' THEN 'Meters' | |
| WHEN proj4text LIKE '%+units=ft%' THEN 'Feet' | |
| WHEN proj4text LIKE '%+units=us-ft%' THEN 'Feet' | |
| WHEN proj4text LIKE '%+units=link%' | |
| OR proj4text LIKE '%+units=%' | |
| THEN 'Set, not caught properly' |