Skip to content

Instantly share code, notes, and snippets.

@smnorris
Last active June 16, 2021 18:41
Show Gist options
  • Select an option

  • Save smnorris/94a31f511a78f5d99c487046ff9e16eb to your computer and use it in GitHub Desktop.

Select an option

Save smnorris/94a31f511a78f5d99c487046ff9e16eb to your computer and use it in GitHub Desktop.
Display the source blob
Display the rendered blob
Raw
{
"type": "FeatureCollection",
"name": "sql_statement",
"crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
"features": [
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004602514.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Harmer Creek", "blue_line_key": 356553439 }, "geometry": { "type": "Point", "coordinates": [ -114.785384062829721, 49.791749753893292 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004606545.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "DISTRICT MANAGER ROCKY MOUNTAIN (DRM)", "stream_name": "Cummings Creek", "blue_line_key": 356565258 }, "geometry": { "type": "Point", "coordinates": [ -114.986055311888038, 49.821571198316477 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004606284.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "CANADIAN FOREST PRODUCTS LTD.", "stream_name": "Fording River", "blue_line_key": 356568903 }, "geometry": { "type": "Point", "coordinates": [ -114.852686328838018, 50.279842929898102 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 61504.0, "assessment_requirements": "confirmation", "pscis_road_name": "Coal Creek Rd", "ften_client_name": null, "stream_name": "Coal Creek", "blue_line_key": 356563802 }, "geometry": { "type": "Point", "coordinates": [ -114.993536460103854, 49.488411464375162 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004601280.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": null, "blue_line_key": 356562108 }, "geometry": { "type": "Point", "coordinates": [ -114.785012652555167, 49.789520930876272 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004607022.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "McCool Creek", "blue_line_key": 356564642 }, "geometry": { "type": "Point", "coordinates": [ -114.948046046201767, 49.633268831483079 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1024735049.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Weigert Creek", "blue_line_key": 356568905 }, "geometry": { "type": "Point", "coordinates": [ -114.91018708828156, 49.921152961338109 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004603413.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Henretta Creek", "blue_line_key": 356563941 }, "geometry": { "type": "Point", "coordinates": [ -114.828796971188055, 50.238784848237181 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004602646.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": null, "blue_line_key": 356556324 }, "geometry": { "type": "Point", "coordinates": [ -114.976915602084262, 49.203920285313032 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004606347.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "DISTRICT MANAGER ROCKY MOUNTAIN (DRM)", "stream_name": "Bean Creek", "blue_line_key": 356565601 }, "geometry": { "type": "Point", "coordinates": [ -114.930660963625243, 49.308569123280343 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004603480.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Bean Creek", "blue_line_key": 356565601 }, "geometry": { "type": "Point", "coordinates": [ -114.928640606367779, 49.315921074174405 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004605499.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "DISTRICT MANAGER ROCKY MOUNTAIN (DRM)", "stream_name": null, "blue_line_key": 356564861 }, "geometry": { "type": "Point", "coordinates": [ -114.935680215627713, 49.30617714978424 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004601984.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": null, "blue_line_key": 356563915 }, "geometry": { "type": "Point", "coordinates": [ -114.879205990192531, 49.261391776488672 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004602949.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Weigert Creek", "blue_line_key": 356568905 }, "geometry": { "type": "Point", "coordinates": [ -114.947671944788681, 49.944905004489598 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004601995.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Rabbit Creek", "blue_line_key": 356570443 }, "geometry": { "type": "Point", "coordinates": [ -114.867760799521776, 49.019917251591892 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004605937.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "CANADIAN FOREST PRODUCTS LTD.", "stream_name": null, "blue_line_key": 356437959 }, "geometry": { "type": "Point", "coordinates": [ -114.781106528012842, 49.013188715350211 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1024734790.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Brûlé Creek", "blue_line_key": 356563721 }, "geometry": { "type": "Point", "coordinates": [ -114.913109270931031, 49.885665892983525 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1100002606.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Boivin Creek", "blue_line_key": 356568601 }, "geometry": { "type": "Point", "coordinates": [ -114.944428000293939, 50.011979183155368 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 197527.0, "assessment_requirements": "confirmation", "pscis_road_name": "Elk River FSR", "ften_client_name": "DISTRICT MANAGER ROCKY MOUNTAIN (DRM)", "stream_name": "Crossing Creek", "blue_line_key": 356557682 }, "geometry": { "type": "Point", "coordinates": [ -114.921801550697211, 50.067429280543962 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004600533.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Chauncey Creek", "blue_line_key": 356559840 }, "geometry": { "type": "Point", "coordinates": [ -114.805336599325386, 50.118927437560941 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004603334.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Fording River", "blue_line_key": 356568903 }, "geometry": { "type": "Point", "coordinates": [ -114.876230274127082, 50.233095310112745 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004605216.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "CANADIAN FOREST PRODUCTS LTD.", "stream_name": null, "blue_line_key": 356565821 }, "geometry": { "type": "Point", "coordinates": [ -114.972842829536745, 49.180648762025619 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004603793.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Lodgepole Creek", "blue_line_key": 356565430 }, "geometry": { "type": "Point", "coordinates": [ -114.749790478099072, 49.290940049661764 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004602163.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Morrissey Creek", "blue_line_key": 356562350 }, "geometry": { "type": "Point", "coordinates": [ -114.909729893262011, 49.414723707495263 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1024735443.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Abruzzi Creek", "blue_line_key": 356564701 }, "geometry": { "type": "Point", "coordinates": [ -115.04359666455592, 50.458352218220639 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004606398.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "DISTRICT MANAGER ROCKY MOUNTAIN (DRM)", "stream_name": null, "blue_line_key": 356565430 }, "geometry": { "type": "Point", "coordinates": [ -114.719909081733618, 49.28960201098365 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004606370.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "DISTRICT MANAGER ROCKY MOUNTAIN (DRM)", "stream_name": "Lodgepole Creek", "blue_line_key": 356565430 }, "geometry": { "type": "Point", "coordinates": [ -114.731982217107927, 49.293529218179273 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1100001086.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Harmer Creek", "blue_line_key": 356553439 }, "geometry": { "type": "Point", "coordinates": [ -114.816167880101077, 49.830910613673339 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004601993.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Rabbit Creek", "blue_line_key": 356570443 }, "geometry": { "type": "Point", "coordinates": [ -114.857360876430675, 49.018473487548391 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004606129.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "CANADIAN FOREST PRODUCTS LTD.", "stream_name": null, "blue_line_key": 356569293 }, "geometry": { "type": "Point", "coordinates": [ -114.949862696101277, 49.155196599953221 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004606926.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": null, "blue_line_key": 356566756 }, "geometry": { "type": "Point", "coordinates": [ -114.749960747955399, 49.138059469352775 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004601704.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Morrissey Creek", "blue_line_key": 356562350 }, "geometry": { "type": "Point", "coordinates": [ -114.930296408600285, 49.398820515874085 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1024733953.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": null, "blue_line_key": 356563915 }, "geometry": { "type": "Point", "coordinates": [ -114.906738049451135, 49.286695742400738 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004600762.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Fording River", "blue_line_key": 356568903 }, "geometry": { "type": "Point", "coordinates": [ -114.880384486739842, 50.196004847939001 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004607449.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": null, "blue_line_key": 356539063 }, "geometry": { "type": "Point", "coordinates": [ -114.774633066616218, 50.058826641099664 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004604677.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Henretta Creek", "blue_line_key": 356563941 }, "geometry": { "type": "Point", "coordinates": [ -114.867062504679311, 50.23039227486246 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004603432.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": null, "blue_line_key": 356548332 }, "geometry": { "type": "Point", "coordinates": [ -115.039057565154067, 50.456072162006016 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004603553.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Bighorn Creek", "blue_line_key": 356566756 }, "geometry": { "type": "Point", "coordinates": [ -114.761159533707726, 49.157960797655697 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004603791.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": null, "blue_line_key": 356539479 }, "geometry": { "type": "Point", "coordinates": [ -114.791874008260834, 49.282682967680465 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004606007.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "DISTRICT MANAGER ROCKY MOUNTAIN (DRM)", "stream_name": "Weigert Creek", "blue_line_key": 356568905 }, "geometry": { "type": "Point", "coordinates": [ -114.948877231797482, 49.946297046471081 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004604696.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Henretta Creek", "blue_line_key": 356563941 }, "geometry": { "type": "Point", "coordinates": [ -114.863926321333381, 50.230664083644143 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1024706614.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Henretta Creek", "blue_line_key": 356563941 }, "geometry": { "type": "Point", "coordinates": [ -114.852130283057207, 50.232889138573185 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004605338.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "CANADIAN FOREST PRODUCTS LTD.", "stream_name": null, "blue_line_key": 356526127 }, "geometry": { "type": "Point", "coordinates": [ -114.831936011092907, 49.058039489800819 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004602359.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": null, "stream_name": "Rabbit Creek", "blue_line_key": 356570443 }, "geometry": { "type": "Point", "coordinates": [ -114.871533816527347, 49.018734776699361 ] } },
{ "type": "Feature", "properties": { "aggregated_crossings_id": 1004606411.0, "assessment_requirements": "assessment", "pscis_road_name": null, "ften_client_name": "CANADIAN FOREST PRODUCTS LTD.", "stream_name": null, "blue_line_key": 356551813 }, "geometry": { "type": "Point", "coordinates": [ -114.817561065336307, 49.26805826414121 ] } }
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment