units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where COUNTY = 5, MNG_AG_TYP = 4 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, PARK_URL, LABEL_NAME
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3818 | 3818 | 3817 | {"type": "Polygon", "coordinates": [[[-122.13417, 37.15393], [-122.13375, 37.15388], [-122.13379, 37.15364], [-122.13411, 37.15359], [-122.13417, 37.15393]]]} | Open Access 1 | 35183 | Garrahan Park | 28532 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/#!parks/ccjp | Santa Cruz 5 | 0.257 | Garrahan Park | 0 | Local Park 2 | 4 |
3819 | 3819 | 3818 | {"type": "Polygon", "coordinates": [[[-122.13458, 37.15391], [-122.13422, 37.15419], [-122.1342, 37.1541], [-122.13422, 37.15394], [-122.13417, 37.15393], [-122.13411, 37.15359], [-122.13379, 37.15364], [-122.13383, 37.15347], [-122.13395, 37.15311], [-122.13418, 37.15278], [-122.13458, 37.15237], [-122.13458, 37.15391]]]} | Open Access 1 | 35184 | Garrahan Park | 28532 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/#!parks/ccjp | Santa Cruz 5 | 1.947 | Garrahan Park | 0 | Local Park 2 | 4 |
4559 | 4559 | 4558 | {"type": "Polygon", "coordinates": [[[-121.86369, 36.93775], [-121.86367, 36.9378], [-121.86349, 36.938], [-121.86335, 36.93821], [-121.86263, 36.93764], [-121.86282, 36.9375], [-121.86287, 36.9375], [-121.86293, 36.93754], [-121.86296, 36.93752], [-121.86302, 36.93756], [-121.86312, 36.93749], [-121.86321, 36.93756], [-121.86335, 36.93746], [-121.86366, 36.93771], [-121.86369, 36.93775]]]} | Open Access 1 | 35179 | Unknown park - La Selva Beach Parks and Recreation District | 28690 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 1.005 | 0 | Local Other or Unknown 14 | 4 | ||
4618 | 4618 | 4617 | {"type": "Polygon", "coordinates": [[[-121.86433, 36.93568], [-121.86428, 36.93572], [-121.8632, 36.9346], [-121.86325, 36.93456], [-121.86433, 36.93568]]]} | Open Access 1 | 36130 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.256 | 0 | Local Other or Unknown 14 | 4 | ||
4619 | 4619 | 4618 | {"type": "Polygon", "coordinates": [[[-121.86, 36.94078], [-121.85982, 36.94067], [-121.85962, 36.94058], [-121.85956, 36.94051], [-121.8596, 36.94044], [-121.85969, 36.9404], [-121.86, 36.94039], [-121.86, 36.94078]]]} | Open Access 1 | 36131 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.265 | 0 | Local Other or Unknown 14 | 4 | ||
4628 | 4628 | 4627 | {"type": "MultiPolygon", "coordinates": [[[[-121.86066, 36.93962], [-121.86062, 36.93973], [-121.86059, 36.94006], [-121.86048, 36.94029], [-121.86042, 36.94033], [-121.86035, 36.94032], [-121.86032, 36.94029], [-121.86032, 36.94025], [-121.86066, 36.93962]]], [[[-121.8624, 36.9389], [-121.86234, 36.93895], [-121.86222, 36.93911], [-121.86212, 36.9392], [-121.86196, 36.93931], [-121.86184, 36.93937], [-121.8617, 36.93936], [-121.86144, 36.93927], [-121.86121, 36.93924], [-121.86099, 36.9393], [-121.86083, 36.9394], [-121.86071, 36.93953], [-121.86082, 36.93939], [-121.86095, 36.93926], [-121.86106, 36.93919], [-121.86116, 36.93917], [-121.86153, 36.93924], [-121.86176, 36.93924], [-121.86197, 36.93918], [-121.8624, 36.9389]]], [[[-121.86359, 36.93809], [-121.86355, 36.9382], [-121.86353, 36.93834], [-121.86347, 36.93848], [-121.86323, 36.93869], [-121.86305, 36.9388], [-121.86297, 36.93883], [-121.86269, 36.93881], [-121.86256, 36.93883], [-121.86292, 36.93873], [-121.86307, 36.93867], [-121.86324, 36.93857], [-121.86336, 36.93843], [-121.86356, 36.93807], [-121.86359, 36.93809]]]]} | Open Access 1 | 36258 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.768 | 0 | Local Other or Unknown 14 | 4 | ||
4673 | 4673 | 4672 | {"type": "Polygon", "coordinates": [[[-121.86411, 36.93794], [-121.86404, 36.93797], [-121.86384, 36.93798], [-121.86379, 36.93797], [-121.86377, 36.93793], [-121.86383, 36.93779], [-121.86393, 36.93787], [-121.86398, 36.93783], [-121.86411, 36.93794]]]} | Open Access 1 | 36646 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.092 | 0 | Local Other or Unknown 14 | 4 | ||
4683 | 4683 | 4682 | {"type": "Polygon", "coordinates": [[[-121.8613, 36.93786], [-121.86128, 36.9379], [-121.86099, 36.93813], [-121.86095, 36.93813], [-121.86093, 36.9381], [-121.86095, 36.93798], [-121.86093, 36.93765], [-121.86096, 36.93761], [-121.86102, 36.93762], [-121.86128, 36.93782], [-121.8613, 36.93786]]]} | Open Access 1 | 43074 | Unknown park - La Selva Beach Recreation District | 28639 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.278 | 0 | Local Other or Unknown 14 | 4 | ||
13188 | 13188 | 13187 | {"type": "Polygon", "coordinates": [[[-122.11963, 37.1255], [-122.11902, 37.12573], [-122.11902, 37.12573], [-122.11903, 37.12536], [-122.11963, 37.1255]]]} | Open Access 1 | 35178 | Barbara Day Park | 28528 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.272 | Barbara Day Park | 0 | Local Park 2 | 4 | |
13189 | 13189 | 13188 | {"type": "Polygon", "coordinates": [[[-122.1211, 37.12664], [-122.12089, 37.12679], [-122.12081, 37.12657], [-122.12102, 37.12645], [-122.1211, 37.12664]]]} | Open Access 1 | 35180 | Junction Park | 28529 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/#!parks/ccjp | Santa Cruz 5 | 0.129 | Junction Park | 0 | Local Park 2 | 4 |
14165 | 14165 | 14164 | {"type": "Polygon", "coordinates": [[[-122.12089, 37.12679], [-122.1207, 37.12728], [-122.12022, 37.12709], [-122.12065, 37.12667], [-122.12082, 37.1266], [-122.12089, 37.12679]]]} | Open Access 1 | 43076 | Junction Park | 28529 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/#!parks/ccjp | Santa Cruz 5 | 0.555 | Junction Park | 0 | Local Park 2 | 4 |
15482 | 15482 | 15481 | {"type": "Polygon", "coordinates": [[[-121.85976, 36.9403], [-121.85956, 36.94034], [-121.85939, 36.94045], [-121.85932, 36.94046], [-121.85927, 36.94041], [-121.85927, 36.94028], [-121.85951, 36.94009], [-121.85976, 36.9403]]]} | Open Access 1 | 43081 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.222 | 0 | Local Other or Unknown 14 | 4 | ||
15485 | 15485 | 15484 | {"type": "Polygon", "coordinates": [[[-121.8621, 36.93337], [-121.86183, 36.93378], [-121.86183, 36.93423], [-121.86175, 36.93427], [-121.86176, 36.93376], [-121.86206, 36.93332], [-121.8621, 36.93337]]]} | Open Access 1 | 43087 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.166 | 0 | Local Other or Unknown 14 | 4 | ||
15943 | 15943 | 15942 | {"type": "Polygon", "coordinates": [[[-121.86211, 37.08756], [-121.86171, 37.09923], [-121.86102, 37.09924], [-121.8606, 37.0992], [-121.85977, 37.09909], [-121.85944, 37.09903], [-121.85924, 37.09901], [-121.85863, 37.09903], [-121.85836, 37.09902], [-121.85804, 37.09898], [-121.8578, 37.099], [-121.85738, 37.09915], [-121.85721, 37.09919], [-121.85698, 37.09921], [-121.85679, 37.09922], [-121.85593, 37.09913], [-121.85577, 37.09907], [-121.85571, 37.09902], [-121.85525, 37.09856], [-121.85509, 37.09843], [-121.8547, 37.0983], [-121.8543, 37.09827], [-121.85421, 37.09828], [-121.85408, 37.09827], [-121.8537, 37.09833], [-121.85359, 37.09837], [-121.85328, 37.09844], [-121.85297, 37.09855], [-121.85265, 37.09865], [-121.85234, 37.09872], [-121.85211, 37.09873], [-121.85204, 37.09875], [-121.85168, 37.09875], [-121.85138, 37.09869], [-121.85102, 37.09856], [-121.85041, 37.09826], [-121.85028, 37.09825], [-121.84997, 37.09831], [-121.84977, 37.09831], [-121.84959, 37.0983], [-121.84937, 37.09824], [-121.84887, 37.09802], [-121.84853, 37.09783], [-121.84837, 37.09771], [-121.84815, 37.09742], [-121.84811, 37.09735], [-121.848, 37.09727], [-121.84762, 37.09722], [-121.84743, 37.09716], [-121.84699, 37.09693], [-121.84689, 37.0969], [-121.84681, 37.09688], [-121.84649, 37.09688], [-121.84633, 37.09682], [-121.84615, 37.09667], [-121.84591, 37.09651], [-121.84586, 37.09645], [-121.84575, 37.09641], [-121.84548, 37.09626], [-121.84537, 37.09627], [-121.84483, 37.09663], [-121.84478, 37.09663], [-121.84458, 37.09658], [-121.84463, 37.09643], [-121.84446, 37.09626], [-121.84425, 37.09617], [-121.84417, 37.09605], [-121.84423, 37.0958], [-121.84436, 37.09554], [-121.84445, 37.09516], [-121.84444, 37.09501], [-121.84436, 37.09487], [-121.84423, 37.09476], [-121.84391, 37.09463], [-121.84374, 37.09458], [-121.84336, 37.09455], [-121.84312, 37.09455], [-121.84353, 37.08752], [-121.84376, 37.07725], [-121.84511, 37.07796], [-121.84551, 37.07795], [-121.846, 37.07829], [-121.84647, 37.07873], [-121.84667, 37.07883], [-121.84685, 37.07889], [-121.84703, 37.07892], [-121.84762, 37.07891], [-121.84769, 37.07892], [-121.84791, 37.079], [-121.84801, 37.07906], [-121.84866, 37.07977], [-121.84974, 37.08068], [-121.85007, 37.08133], [-121.8501, 37.08153], [-121.85045, 37.08186], [-121.85071, 37.08226], [-121.85156, 37.08296], [-121.852, 37.08343], [-121.85262, 37.0839], [-121.85304, 37.0843], [-121.85339, 37.08454], [-121.85379, 37.08474], [-121.85423, 37.08487], [-121.85481, 37.08496], [-121.85512, 37.08503], [-121.85541, 37.08514], [-121.85585, 37.0854], [-121.85612, 37.08551], [-121.85645, 37.0856], [-121.85675, 37.08563], [-121.85706, 37.08562], [-121.8582, 37.0854], [-121.85885, 37.08543], [-121.8595, 37.08561], [-121.86009, 37.0867], [-121.86173, 37.08714], [-121.86184, 37.08723], [-121.86191, 37.08739], [-121.86195, 37.08744], [-121.86199, 37.08749], [-121.86211, 37.08756]]]} | No Public Access 3 | 35999 | Sierra Azul Open Space Preserve | 29299 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_sierra_azul.asp | Santa Cruz 5 | 688.947 | Sierra Azul OSP | 0 | Local Conservation Area 4 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);