Skip to content

Instantly share code, notes, and snippets.

@nautilytics

nautilytics/index.sql

Created February 11, 2021 16:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nautilytics/a3bf7a80c77505718d3aa1a1e080ec15 to your computer and use it in GitHub Desktop.
Save nautilytics/a3bf7a80c77505718d3aa1a1e080ec15 to your computer and use it in GitHub Desktop.
Download ZIP
Create a GeoJSON of the disputed India Boundaries
Raw
index.sql
COPY
(
SELECT row_to_json(fc) AS json_out
FROM (
SELECT 'FeatureCollection' AS type,
array_to_json(array_agg(f)) AS features
FROM (
SELECT 'Feature' AS type,
st_asgeojson(st_transform(st_union(geom), 4326))::json AS geometry
FROM india_boundary
) f) fc ) TO '/Users/<user_name>/Desktop/india-disputed.json';
Display the source blob
Display the rendered blob
Raw
india-disputed.json
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment