Skip to content

Instantly share code, notes, and snippets.

@joshuapowell

joshuapowell/result.geojson

Last active August 29, 2015 14:24
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save joshuapowell/1f25ec149b0c5c295356 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save joshuapowell/1f25ec149b0c5c295356 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. joshuapowell revised this gist Jul 11, 2015. 1 changed file with 15 additions and 0 deletions.
    15 changes: 15 additions & 0 deletions result.geojson
    View file
    15 additions, 0 deletions not shown because the diff is too large. Please use a local Git client to view these changes.
  2. joshuapowell created this gist Jul 11, 2015.
    9 changes: 9 additions & 0 deletions gistfile1.pls
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,9 @@
    SELECT
    huc_6_name,
    ST_AsGeoJson(ST_Multi(ST_Union(CAST(t.geometry AS Geometry)))) as huc_6_dissovled
    FROM
    territory AS t
    WHERE
    huc_6_name = 'Potomac'
    GROUP BY
    huc_6_name