superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
22 rows where MNG_AGENCY = 223
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14580 | 14580 | 14579 | {"type": "MultiPolygon", "coordinates": [[[[-122.53824, 37.9098], [-122.53811, 37.91024], [-122.53771, 37.91092], [-122.53761, 37.91119], [-122.5375, 37.91182], [-122.53741, 37.91193], [-122.53625, 37.91209], [-122.53593, 37.91232], [-122.53582, 37.91252], [-122.53582, 37.91274], [-122.53589, 37.91294], [-122.53605, 37.91313], [-122.53622, 37.91344], [-122.53697, 37.91408], [-122.53712, 37.91411], [-122.53711, 37.91421], [-122.53738, 37.91449], [-122.53757, 37.91462], [-122.53731, 37.91502], [-122.53732, 37.91572], [-122.53736, 37.91629], [-122.53645, 37.91631], [-122.53631, 37.91634], [-122.53626, 37.91612], [-122.53601, 37.91621], [-122.53609, 37.91554], [-122.53607, 37.91525], [-122.53524, 37.91444], [-122.53503, 37.91432], [-122.53464, 37.91425], [-122.53426, 37.91434], [-122.5339, 37.91459], [-122.53371, 37.9142], [-122.53341, 37.91408], [-122.53296, 37.91405], [-122.53295, 37.91402], [-122.53268, 37.91401], [-122.53266, 37.91357], [-122.53191, 37.9128], [-122.53141, 37.91255], [-122.53075, 37.91226], [-122.53095, 37.91187], [-122.53235, 37.91209], [-122.53374, 37.91212], [-122.53375, 37.91211], [-122.53435, 37.91212], [-122.53486, 37.91172], [-122.53601, 37.91086], [-122.53611, 37.91066], [-122.53608, 37.91063], [-122.53608, 37.91038], [-122.53621, 37.91015], [-122.53625, 37.91003], [-122.53634, 37.9099], [-122.53645, 37.90978], [-122.53645, 37.90976], [-122.53632, 37.90974], [-122.53648, 37.90975], [-122.53636, 37.90988], [-122.53627, 37.91001], [-122.53623, 37.91013], [-122.53609, 37.91036], [-122.5361, 37.9106], [-122.53612, 37.91062], [-122.53645, 37.90998], [-122.53668, 37.90977], [-122.53688, 37.90954], [-122.53756, 37.90977], [-122.53801, 37.9095], [-122.53824, 37.9098]]], [[[-122.53584, 37.91055], [-122.53572, 37.91072], [-122.53547, 37.91088], [-122.53533, 37.91089], [-122.53531, 37.91087], [-122.53548, 37.91085], [-122.53573, 37.9107], [-122.53584, 37.91055]]], [[[-122.53627, 37.90979], [-122.53623, 37.90985], [-122.53614, 37.90997], [-122.53615, 37.90995], [-122.53624, 37.90982], [-122.53627, 37.90979]]], [[[-122.53908, 37.91023], [-122.53887, 37.91043], [-122.53862, 37.91048], [-122.53853, 37.91083], [-122.53805, 37.91063], [-122.53825, 37.91026], [-122.53838, 37.90977], [-122.53807, 37.90931], [-122.53797, 37.90894], [-122.53801, 37.9085], [-122.53816, 37.90926], [-122.53845, 37.90915], [-122.53853, 37.90935], [-122.53871, 37.90949], [-122.53881, 37.90962], [-122.53887, 37.9098], [-122.53905, 37.90996], [-122.53908, 37.91023]]]]} | Restricted Access 2 | Mill Valley Golf Course | 33001 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 43.863 | Mill Valley GC | ||
14705 | 14705 | 14704 | {"type": "MultiPolygon", "coordinates": [[[[-122.56224, 37.92015], [-122.56224, 37.92028], [-122.56226, 37.92044], [-122.56223, 37.92056], [-122.56217, 37.92062], [-122.56209, 37.92066], [-122.56199, 37.92075], [-122.56193, 37.92084], [-122.56189, 37.92095], [-122.56179, 37.92095], [-122.5618, 37.92085], [-122.56185, 37.92076], [-122.56193, 37.92067], [-122.56206, 37.92059], [-122.56213, 37.9205], [-122.56215, 37.92043], [-122.56213, 37.92018], [-122.56214, 37.92014], [-122.56224, 37.92015]]], [[[-122.56332, 37.91992], [-122.56332, 37.91998], [-122.56329, 37.92003], [-122.56318, 37.92008], [-122.56309, 37.92008], [-122.56301, 37.92004], [-122.56306, 37.91996], [-122.5631, 37.92], [-122.56317, 37.92002], [-122.56323, 37.91999], [-122.56325, 37.91994], [-122.563, 37.91967], [-122.56288, 37.91957], [-122.56283, 37.9195], [-122.56276, 37.91934], [-122.56277, 37.91915], [-122.56275, 37.91907], [-122.56268, 37.91901], [-122.56226, 37.91887], [-122.5622, 37.91883], [-122.56244, 37.91885], [-122.56271, 37.91895], [-122.56281, 37.91903], [-122.56285, 37.9191], [-122.56284, 37.9193], [-122.56289, 37.91945], [-122.56297, 37.91955], [-122.56329, 37.91986], [-122.56332, 37.91992]]], [[[-122.56908, 37.91911], [-122.56818, 37.91978], [-122.56823, 37.92036], [-122.56853, 37.92056], [-122.56858, 37.92055], [-122.56861, 37.92056], [-122.56857, 37.92066], [-122.56858, 37.92081], [-122.56849, 37.92112], [-122.56851, 37.92116], [-122.56848, 37.92118], [-122.56844, 37.92119], [-122.56842, 37.92117], [-122.56836, 37.92118], [-122.56831, 37.92117], [-122.56807, 37.92098], [-122.56794, 37.92092], [-122.56761, 37.92084], [-122.56755, 37.92079], [-122.5674, 37.92058], [-122.56732, 37.92051], [-122.56721, 37.92046], [-122.5671, 37.92044], [-122.56698, 37.92044], [-122.56613, 37.92059], [-122.56602, 37.92059], [-122.56589, 37.92055], [-122.56568, 37.92041], [-122.56542, 37.92033], [-122.56535, 37.92028], [-122.56528, 37.9202], [-122.56584, 37.91984], [-122.56622, 37.91979], [-122.56638, 37.91986], [-122.56658, 37.91896], [-122.56682, 37.91892], [-122.56669, 37.91865], [-122.56653, 37.91848], [-122.56651, 37.91817], [-122.56908, 37.91911]]], [[[-122.56783, 37.909], [-122.56785, 37.90917], [-122.56781, 37.9097], [-122.56717, 37.91127], [-122.56658, 37.91154], [-122.56674, 37.91068], [-122.56696, 37.91075], [-122.56712, 37.91067], [-122.56715, 37.9105], [-122.5671, 37.91026], [-122.56732, 37.91018], [-122.56742, 37.91003], [-122.56739, 37.90983], [-122.56761, 37.90972], [-122.56769, 37.90946], [-122.56779, 37.90904], [-122.56783, 37.909]]], [[[-122.56823, 37.90789], [-122.5679, 37.90843], [-122.56774, 37.90886], [-122.56763, 37.909], [-122.56747, 37.90954], [-122.56673, 37.90922], [-122.56684, 37.90914], [-122.5668, 37.90889], [-122.56683, 37.90879], [-122.567, 37.90862], [-122.56699, 37.90839], [-122.56701, 37.9083], [-122.56714, 37.90813], [-122.56714, 37.90795], [-122.567, 37.90776], [-122.56712, 37.90762], [-122.56722, 37.90745], [-122.56732, 37.90756], [-122.56759, 37.90776], [-122.56796, 37.90791], [-122.56811, 37.90792], [-122.56823, 37.90789]]], [[[-122.57378, 37.91163], [-122.57242, 37.91272], [-122.57245, 37.91276], [-122.57243, 37.91281], [-122.57312, 37.91332], [-122.57215, 37.91414], [-122.57141, 37.91359], [-122.5715, 37.91347], [-122.57222, 37.91288], [-122.57222, 37.91286], [-122.57095, 37.91229], [-122.57015, 37.91242], [-122.57047, 37.91186], [-122.5699, 37.91163], [-122.56982, 37.91174], [-122.56821, 37.91104], [-122.56813, 37.9112], [-122.56802, 37.91123], [-122.56752, 37.91102], [-122.56744, 37.91106], [-122.56796, 37.90979], [-122.56799, 37.90935], [-122.57059, 37.90904], [-122.57101, 37.91026], [-122.57367, 37.90969], [-122.5732, 37.91138], [-122.57378, 37.91163]]]]} | Open Access 1 | Cascade Canyon Open Space Preserve | 16934 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 54.214 | Cascade Canyon OSP |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);