superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AGENCY = 631 and YR_EST = 1999
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14693 | 14693 | 14692 | {"type": "Polygon", "coordinates": [[[-122.17947, 37.27223], [-122.17063, 37.27223], [-122.16621, 37.27221], [-122.16623, 37.27584], [-122.1618, 37.27583], [-122.1617, 37.28221], [-122.17082, 37.28225], [-122.17084, 37.28664], [-122.17076, 37.29062], [-122.16751, 37.29053], [-122.166, 37.29165], [-122.16598, 37.29246], [-122.16439, 37.29246], [-122.16469, 37.2937], [-122.16469, 37.29391], [-122.16463, 37.294], [-122.16453, 37.29406], [-122.16415, 37.29414], [-122.1642, 37.29419], [-122.16427, 37.29414], [-122.16444, 37.29429], [-122.16453, 37.2944], [-122.1642, 37.29425], [-122.16416, 37.29426], [-122.16435, 37.29444], [-122.16447, 37.2946], [-122.16459, 37.29479], [-122.16466, 37.29497], [-122.1647, 37.29518], [-122.16471, 37.29537], [-122.16469, 37.29558], [-122.16465, 37.29575], [-122.1646, 37.29577], [-122.16466, 37.29554], [-122.16468, 37.29531], [-122.16466, 37.29508], [-122.16459, 37.29485], [-122.16447, 37.29463], [-122.16432, 37.29443], [-122.16412, 37.29424], [-122.16392, 37.29411], [-122.16371, 37.294], [-122.16348, 37.29392], [-122.16166, 37.29346], [-122.16046, 37.29317], [-122.16046, 37.29315], [-122.15993, 37.29301], [-122.15814, 37.29234], [-122.15686, 37.29182], [-122.15643, 37.2916], [-122.15601, 37.29137], [-122.15386, 37.28999], [-122.15368, 37.28984], [-122.15347, 37.28965], [-122.15328, 37.28944], [-122.15312, 37.28922], [-122.15294, 37.28889], [-122.15279, 37.28849], [-122.15273, 37.28824], [-122.15259, 37.28737], [-122.15279, 37.28675], [-122.15255, 37.28669], [-122.1526, 37.28443], [-122.15258, 37.28443], [-122.1525, 37.28615], [-122.15227, 37.28465], [-122.15221, 37.2844], [-122.15209, 37.28403], [-122.15197, 37.2838], [-122.15184, 37.28358], [-122.15156, 37.28322], [-122.15135, 37.28301], [-122.15111, 37.28282], [-122.15082, 37.28261], [-122.15059, 37.28248], [-122.14994, 37.28217], [-122.14971, 37.28202], [-122.14957, 37.2819], [-122.14933, 37.28165], [-122.14918, 37.28144], [-122.14908, 37.28122], [-122.14901, 37.28098], [-122.14898, 37.28075], [-122.14899, 37.28051], [-122.14902, 37.28035], [-122.14909, 37.28012], [-122.14912, 37.28004], [-122.14973, 37.27916], [-122.14979, 37.27898], [-122.14979, 37.27884], [-122.14959, 37.27791], [-122.14959, 37.27775], [-122.14961, 37.27765], [-122.14968, 37.27754], [-122.14989, 37.27736], [-122.15021, 37.27715], [-122.1505, 37.27688], [-122.1507, 37.2766], [-122.15076, 37.27648], [-122.15082, 37.2763], [-122.15084, 37.27617], [-122.15078, 37.27579], [-122.15065, 37.27552], [-122.15044, 37.27528], [-122.15029, 37.27515], [-122.15011, 37.27504], [-122.14977, 37.2749], [-122.14957, 37.27485], [-122.14889, 37.27487], [-122.14853, 37.27483], [-122.14836, 37.27478], [-122.14816, 37.2747], [-122.148, 37.27461], [-122.14787, 37.27451], [-122.14779, 37.27443], [-122.14655, 37.27239], [-122.14602, 37.27175], [-122.14458, 37.27028], [-122.14432, 37.27005], [-122.1441, 37.26993], [-122.1438, 37.2698], [-122.14096, 37.26906], [-122.14055, 37.26891], [-122.14022, 37.26876], [-122.13993, 37.26859], [-122.13972, 37.26845], [-122.13952, 37.2683], [-122.13928, 37.26808], [-122.13917, 37.26797], [-122.13824, 37.26685], [-122.13802, 37.26664], [-122.13749, 37.26627], [-122.13626, 37.26576], [-122.13603, 37.26562], [-122.13589, 37.26548], [-122.13578, 37.26533], [-122.13475, 37.26309], [-122.13458, 37.26288], [-122.13438, 37.26271], [-122.13424, 37.26261], [-122.1339, 37.26243], [-122.13412, 37.26206], [-122.13383, 37.26194], [-122.13335, 37.26157], [-122.13282, 37.26099], [-122.13139, 37.2602], [-122.13112, 37.26034], [-122.13097, 37.26024], [-122.13075, 37.26015], [-122.13029, 37.26004], [-122.12991, 37.2599], [-122.12966, 37.25977], [-122.1295, 37.25967], [-122.12911, 37.25932], [-122.12889, 37.25918], [-122.12859, 37.25904], [-122.12824, 37.25895], [-122.12795, 37.25893], [-122.12767, 37.25894], [-122.12739, 37.259], [-122.12698, 37.25912], [-122.12668, 37.25916], [-122.12644, 37.25915], [-122.12594, 37.25907], [-122.12554, 37.25907], [-122.1253, 37.25911], [-122.1251, 37.25916], [-122.12449, 37.25941], [-122.12432, 37.25946], [-122.12417, 37.25948], [-122.12401, 37.25948], [-122.12377, 37.25944], [-122.12362, 37.25938], [-122.12348, 37.25931], [-122.12287, 37.25882], [-122.12214, 37.25806], [-122.12472, 37.25606], [-122.12519, 37.25641], [-122.12587, 37.25629], [-122.12635, 37.25541], [-122.12688, 37.25482], [-122.13248, 37.2549], [-122.13467, 37.25383], [-122.13517, 37.25301], [-122.13519, 37.25244], [-122.13634, 37.25243], [-122.13688, 37.25055], [-122.13679, 37.24891], [-122.13809, 37.24809], [-122.13874, 37.24716], [-122.13873, 37.24681], [-122.13932, 37.24588], [-122.14222, 37.24416], [-122.14321, 37.24414], [-122.14347, 37.24428], [-122.14362, 37.2569], [-122.13481, 37.25682], [-122.13483, 37.26132], [-122.14415, 37.26194], [-122.15276, 37.26223], [-122.15286, 37.26525], [-122.15287, 37.26505], [-122.15741, 37.26505], [-122.15744, 37.26326], [-122.16183, 37.26333], [-122.16184, 37.26507], [-122.16628, 37.26509], [-122.16626, 37.26859], [-122.17067, 37.26862], [-122.17944, 37.26914], [-122.17947, 37.27223]], [[-122.15184, 37.27456], [-122.15174, 37.27389], [-122.15155, 37.2737], [-122.15137, 37.27373], [-122.15124, 37.27372], [-122.1505, 37.27352], [-122.15037, 37.27351], [-122.15013, 37.27354], [-122.14996, 37.27351], [-122.14986, 37.27345], [-122.14978, 37.27338], [-122.14972, 37.27328], [-122.14968, 37.27318], [-122.14965, 37.27313], [-122.1494, 37.27304], [-122.14917, 37.27291], [-122.14946, 37.27363], [-122.14925, 37.27425], [-122.14933, 37.27469], [-122.15035, 37.27507], [-122.15083, 37.27539], [-122.15095, 37.27581], [-122.15142, 37.2763], [-122.1521, 37.27648], [-122.15238, 37.27616], [-122.15184, 37.27456]], [[-122.16033, 37.28852], [-122.16122, 37.28852], [-122.16121, 37.2879], [-122.16031, 37.2879], [-122.16033, 37.28852]], [[-122.16434, 37.29401], [-122.1644, 37.29402], [-122.1644, 37.29398], [-122.16435, 37.29397], [-122.16434, 37.29401]]]} | Open Access 1 | Long Ridge Open Space Preserve | http://www.openspace.org/preserves/pr_long_ridge.asp | 6516 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 1811.05 | Long Ridge OSP | 1999 |
14722 | 14722 | 14721 | {"type": "MultiPolygon", "coordinates": [[[[-122.0034, 37.1636], [-121.9999, 37.1636], [-121.99829, 37.16357], [-121.99809, 37.16437], [-121.99716, 37.1649], [-121.99717, 37.16478], [-121.9973, 37.16468], [-121.99798, 37.16428], [-121.99813, 37.16378], [-121.99793, 37.1634], [-121.9977, 37.16325], [-121.99731, 37.16321], [-121.99731, 37.1635], [-121.99738, 37.16356], [-121.9959, 37.16353], [-121.99591, 37.16265], [-121.9959, 37.16264], [-121.99504, 37.16283], [-121.9949, 37.16351], [-121.99443, 37.16351], [-121.99441, 37.16268], [-121.99527, 37.16241], [-121.99524, 37.16191], [-121.99439, 37.16163], [-121.99549, 37.16147], [-121.99522, 37.15992], [-121.99893, 37.15991], [-122.00335, 37.15994], [-122.0034, 37.1636]]], [[[-122.02664, 37.16976], [-122.02663, 37.16981], [-122.02638, 37.16998], [-122.02637, 37.17003], [-122.02631, 37.17002], [-122.02606, 37.1702], [-122.02605, 37.17032], [-122.02619, 37.1705], [-122.02631, 37.17057], [-122.02615, 37.17071], [-122.02596, 37.17041], [-122.02171, 37.17042], [-122.02152, 37.17765], [-122.02166, 37.18115], [-122.02163, 37.18481], [-122.0173, 37.18486], [-122.01723, 37.18483], [-122.01733, 37.18449], [-122.0173, 37.18447], [-122.0173, 37.18337], [-122.01511, 37.18337], [-122.01509, 37.18495], [-122.01494, 37.18492], [-122.01452, 37.1847], [-122.01345, 37.18522], [-122.01295, 37.18522], [-122.01246, 37.18535], [-122.01223, 37.18545], [-122.01205, 37.18555], [-122.01165, 37.1858], [-122.0114, 37.18593], [-122.01112, 37.18603], [-122.01084, 37.18609], [-122.01054, 37.18613], [-122.01025, 37.18614], [-122.00987, 37.18602], [-122.00897, 37.18586], [-122.00865, 37.18548], [-122.00813, 37.1855], [-122.00604, 37.18491], [-122.00569, 37.18521], [-122.00538, 37.18527], [-122.00478, 37.18508], [-122.00429, 37.18508], [-122.0041, 37.18495], [-122.00371, 37.18496], [-122.00371, 37.18435], [-122.00396, 37.18428], [-122.00428, 37.18415], [-122.00443, 37.18414], [-122.00499, 37.18417], [-122.00511, 37.18415], [-122.00521, 37.18407], [-122.00524, 37.18392], [-122.00504, 37.18334], [-122.00482, 37.18308], [-122.0047, 37.18276], [-122.00368, 37.18222], [-122.00327, 37.18175], [-122.00277, 37.18111], [-122.00279, 37.18089], [-122.00302, 37.18054], [-122.00375, 37.18032], [-122.00408, 37.18036], [-122.00426, 37.1805], [-122.00464, 37.18096], [-122.00498, 37.18123], [-122.0053, 37.18131], [-122.00579, 37.18122], [-122.00631, 37.18095], [-122.00662, 37.18062], [-122.00692, 37.18062], [-122.00726, 37.18047], [-122.00782, 37.17997], [-122.00842, 37.18016], [-122.00896, 37.18008], [-122.00937, 37.18006], [-122.00973, 37.17988], [-122.00989, 37.17933], [-122.00989, 37.17906], [-122.00954, 37.17869], [-122.00987, 37.1784], [-122.01013, 37.17839], [-122.01024, 37.17828], [-122.01032, 37.17808], [-122.01027, 37.17785], [-122.01012, 37.17767], [-122.00998, 37.17753], [-122.00992, 37.17716], [-122.01035, 37.17668], [-122.01044, 37.17636], [-122.0106, 37.17605], [-122.01053, 37.17558], [-122.01067, 37.17527], [-122.01126, 37.17487], [-122.01138, 37.17453], [-122.0114, 37.17405], [-122.01186, 37.17359], [-122.0119, 37.17295], [-122.01203, 37.17275], [-122.0123, 37.17254], [-122.01254, 37.1725], [-122.01319, 37.17264], [-122.01366, 37.17248], [-122.01395, 37.17199], [-122.01461, 37.17182], [-122.01466, 37.1713], [-122.01548, 37.17102], [-122.01619, 37.17052], [-122.01633, 37.17015], [-122.01606, 37.16983], [-122.01622, 37.16956], [-122.01628, 37.16926], [-122.01642, 37.16902], [-122.01643, 37.16869], [-122.01662, 37.1689], [-122.01646, 37.16937], [-122.01685, 37.16947], [-122.01748, 37.16971], [-122.01777, 37.16986], [-122.01811, 37.17005], [-122.01836, 37.17022], [-122.01844, 37.17042], [-122.01855, 37.17041], [-122.01847, 37.17017], [-122.01818, 37.16997], [-122.01784, 37.16978], [-122.01753, 37.16963], [-122.0169, 37.16938], [-122.01659, 37.1693], [-122.01675, 37.16888], [-122.0165, 37.1686], [-122.0166, 37.16843], [-122.01676, 37.16794], [-122.01687, 37.16778], [-122.0171, 37.16753], [-122.01714, 37.16745], [-122.01714, 37.16736], [-122.01707, 37.16724], [-122.0166, 37.16684], [-122.01624, 37.16634], [-122.01595, 37.16602], [-122.01592, 37.16595], [-122.01591, 37.16587], [-122.01616, 37.16587], [-122.01698, 37.16541], [-122.01713, 37.16564], [-122.01726, 37.16575], [-122.0176, 37.16589], [-122.01807, 37.16614], [-122.01833, 37.16613], [-122.0187, 37.16607], [-122.01899, 37.16611], [-122.01938, 37.16608], [-122.01976, 37.16613], [-122.02003, 37.16633], [-122.02024, 37.16654], [-122.02042, 37.16667], [-122.02064, 37.16671], [-122.02112, 37.16668], [-122.02125, 37.1668], [-122.02139, 37.16702], [-122.02181, 37.16714], [-122.02219, 37.16717], [-122.02245, 37.16675], [-122.02289, 37.16632], [-122.02323, 37.1663], [-122.02356, 37.16658], [-122.02362, 37.16658], [-122.02408, 37.16645], [-122.02509, 37.16701], [-122.02581, 37.16693], [-122.02609, 37.16696], [-122.02599, 37.16717], [-122.02596, 37.16736], [-122.02585, 37.16752], [-122.02583, 37.16775], [-122.02597, 37.16787], [-122.02614, 37.16806], [-122.02632, 37.16833], [-122.02638, 37.16834], [-122.02636, 37.16973], [-122.02658, 37.16973], [-122.02664, 37.16976]]], [[[-122.01698, 37.16743], [-122.01696, 37.16747], [-122.01675, 37.16771], [-122.01662, 37.1679], [-122.01644, 37.16842], [-122.01628, 37.16869], [-122.01626, 37.16899], [-122.01613, 37.16922], [-122.01607, 37.16952], [-122.01589, 37.16984], [-122.01616, 37.17017], [-122.01607, 37.17042], [-122.008, 37.17047], [-122.0079, 37.16395], [-122.01001, 37.16391], [-122.00996, 37.16197], [-122.01031, 37.16143], [-122.01028, 37.16102], [-122.01084, 37.16116], [-122.01097, 37.16134], [-122.01149, 37.16233], [-122.01174, 37.16233], [-122.01201, 37.16236], [-122.01232, 37.16235], [-122.01261, 37.1624], [-122.01294, 37.16251], [-122.01318, 37.16264], [-122.01335, 37.1628], [-122.01368, 37.16286], [-122.01368, 37.16348], [-122.01399, 37.16368], [-122.01416, 37.16401], [-122.01453, 37.16441], [-122.01477, 37.16457], [-122.01494, 37.16491], [-122.01541, 37.16551], [-122.01564, 37.16573], [-122.01576, 37.16582], [-122.01576, 37.16597], [-122.01582, 37.16608], [-122.01611, 37.16641], [-122.01646, 37.1669], [-122.01654, 37.16699], [-122.01693, 37.1673], [-122.01698, 37.16736], [-122.01698, 37.16743]]], [[[-122.01704, 37.18495], [-122.01702, 37.18525], [-122.01668, 37.1851], [-122.01682, 37.18502], [-122.01704, 37.18495]]]]} | Open Access 1 | Bear Creek Redwoods Open Space Preserve | 33167 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 751.306 | Bear Creek Redwoods OSP | 1999 |
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]);