units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 3, AGNCY_NAME = 472 and DES_TP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3378 | 3378 | 3377 | {"type": "Polygon", "coordinates": [[[-121.6646, 36.99929], [-121.66395, 36.99962], [-121.66372, 36.99914], [-121.6607, 36.99998], [-121.64336, 36.99825], [-121.64237, 36.99706], [-121.64103, 36.99558], [-121.63962, 36.99342], [-121.63959, 36.99328], [-121.63974, 36.99263], [-121.64976, 36.98879], [-121.64998, 36.98865], [-121.65387, 36.98718], [-121.65444, 36.98739], [-121.65526, 36.98798], [-121.65768, 36.98858], [-121.65796, 36.98868], [-121.65926, 36.98898], [-121.65924, 36.98906], [-121.65915, 36.98927], [-121.65869, 36.98944], [-121.65852, 36.98982], [-121.65814, 36.99001], [-121.65802, 36.99034], [-121.65782, 36.99051], [-121.6576, 36.99095], [-121.65718, 36.99132], [-121.657, 36.99169], [-121.65616, 36.99213], [-121.65585, 36.99264], [-121.65576, 36.9929], [-121.65573, 36.9932], [-121.65619, 36.9935], [-121.65642, 36.99384], [-121.65658, 36.99397], [-121.65726, 36.99401], [-121.65742, 36.99461], [-121.65783, 36.99478], [-121.65806, 36.99509], [-121.65843, 36.99523], [-121.65842, 36.99555], [-121.65873, 36.99572], [-121.65856, 36.99611], [-121.65867, 36.99631], [-121.65934, 36.99662], [-121.66013, 36.99723], [-121.66134, 36.99737], [-121.66267, 36.99781], [-121.66332, 36.99812], [-121.6646, 36.99929]], [[-121.65455, 36.99628], [-121.65454, 36.99626], [-121.6541, 36.99606], [-121.65394, 36.9963], [-121.65438, 36.9965], [-121.65455, 36.99628]]]} | No Public Access 3 | 24434 | Mount Madonna County Park | 29288 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/MtMadonna.aspx | Santa Clara 19 | 423.185 | Mount Madonna County Park | 0 | Local Park 2 | 4 |
3807 | 3807 | 3806 | {"type": "Polygon", "coordinates": [[[-122.056, 37.23144], [-122.05442, 37.23139], [-122.05437, 37.23056], [-122.0559, 37.23113], [-122.056, 37.23144]]]} | No Public Access 3 | 35126 | Sanborn County Park | 32833 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 2.136 | Sanborn County Park | 0 | Local Park 2 | 4 | |
5769 | 5769 | 5768 | {"type": "MultiPolygon", "coordinates": [[[[-121.68672, 36.99803], [-121.68674, 36.99859], [-121.68661, 36.99896], [-121.68643, 36.99936], [-121.6863, 36.9998], [-121.68549, 37.00119], [-121.6854, 37.0018], [-121.68518, 37.00212], [-121.68487, 37.00246], [-121.68471, 37.00262], [-121.68441, 37.00278], [-121.68384, 37.00298], [-121.68341, 37.00311], [-121.68281, 37.00343], [-121.68237, 37.0037], [-121.68199, 37.00385], [-121.68126, 37.00395], [-121.68062, 37.00388], [-121.68004, 37.0037], [-121.67943, 37.00359], [-121.67871, 37.00351], [-121.67689, 37.0034], [-121.67629, 37.00332], [-121.67587, 37.0032], [-121.67521, 37.00309], [-121.67512, 37.00291], [-121.6747, 37.00217], [-121.67447, 37.00187], [-121.67356, 37.00185], [-121.67306, 37.00116], [-121.67214, 37.00075], [-121.67159, 37.00067], [-121.67134, 37.00042], [-121.67088, 36.99909], [-121.66987, 36.99904], [-121.66916, 36.99843], [-121.66876, 36.99825], [-121.66483, 36.99911], [-121.66455, 36.98429], [-121.66813, 36.98641], [-121.68672, 36.99803]]], [[[-121.71358, 37.02718], [-121.70911, 37.02723], [-121.70928, 37.03286], [-121.70996, 37.03332], [-121.70988, 37.03335], [-121.70972, 37.03333], [-121.7096, 37.03334], [-121.70945, 37.03341], [-121.7089, 37.03404], [-121.70885, 37.03408], [-121.70828, 37.03421], [-121.70784, 37.03422], [-121.7076, 37.03425], [-121.70647, 37.0346], [-121.70632, 37.03463], [-121.70616, 37.03463], [-121.70601, 37.0346], [-121.70587, 37.03455], [-121.70573, 37.03446], [-121.70561, 37.03436], [-121.70548, 37.03418], [-121.70533, 37.03394], [-121.70527, 37.03382], [-121.70514, 37.03352], [-121.70509, 37.03342], [-121.70486, 37.03318], [-121.70472, 37.0331], [-121.70461, 37.03307], [-121.70408, 37.03302], [-121.70399, 37.033], [-121.70389, 37.03293], [-121.70373, 37.03277], [-121.70364, 37.03271], [-121.70354, 37.03269], [-121.70248, 37.03265], [-121.70224, 37.03263], [-121.70178, 37.03256], [-121.70108, 37.03239], [-121.70101, 37.03235], [-121.70095, 37.03226], [-121.70088, 37.03219], [-121.70078, 37.03213], [-121.70066, 37.03209], [-121.70054, 37.03207], [-121.70041, 37.03207], [-121.70013, 37.03214], [-121.69996, 37.03214], [-121.69963, 37.032], [-121.69954, 37.03197], [-121.69934, 37.03195], [-121.69917, 37.0319], [-121.69891, 37.03176], [-121.69879, 37.03172], [-121.69867, 37.03171], [-121.69854, 37.03173], [-121.69828, 37.03181], [-121.69804, 37.03193], [-121.69794, 37.03195], [-121.69785, 37.03194], [-121.69776, 37.03191], [-121.69726, 37.03162], [-121.69676, 37.0314], [-121.69677, 37.03137], [-121.69548, 37.03058], [-121.69537, 37.03053], [-121.69525, 37.0305], [-121.69506, 37.0305], [-121.69486, 37.03055], [-121.69477, 37.03055], [-121.69249, 37.03023], [-121.69194, 37.03018], [-121.6914, 37.03015], [-121.69085, 37.03013], [-121.69018, 37.03013], [-121.68919, 37.03024], [-121.68892, 37.03028], [-121.68849, 37.0304], [-121.68825, 37.03044], [-121.68792, 37.03049], [-121.68742, 37.03052], [-121.6871, 37.03063], [-121.68688, 37.03074], [-121.6865, 37.03101], [-121.68561, 37.0317], [-121.68385, 37.0269], [-121.68064, 37.02881], [-121.67665, 37.02709], [-121.67403, 37.02297], [-121.675, 37.02246], [-121.67552, 37.02128], [-121.67558, 37.02068], [-121.676, 37.02025], [-121.67636, 37.02005], [-121.67689, 37.01985], [-121.67803, 37.01968], [-121.67837, 37.01899], [-121.67873, 37.01863], [-121.6793, 37.0179], [-121.67931, 37.01745], [-121.67946, 37.01733], [-121.67982, 37.01735], [-121.68038, 37.01748], [-121.68096, 37.01751], [-121.68219, 37.01829], [-121.68285, 37.01856], [-121.68319, 37.01853], [-121.6839, 37.01867], [-121.68431, 37.01873], [-121.68521, 37.01909], [-121.68796, 37.02053], [-121.68866, 37.02026], [-121.6934, 37.02305], [-121.71353, 37.01979], [-121.71358, 37.02718]]], [[[-121.73523, 37.0163], [-121.73072, 37.02292], [-121.73026, 37.02356], [-121.73013, 37.02352], [-121.7306, 37.02279], [-121.7309, 37.02184], [-121.72859, 37.02092], [-121.72772, 37.0209], [-121.72688, 37.02196], [-121.72662, 37.02169], [-121.72638, 37.02141], [-121.72622, 37.02119], [-121.72608, 37.02095], [-121.7259, 37.02055], [-121.7258, 37.02026], [-121.72555, 37.01921], [-121.72542, 37.01876], [-121.72521, 37.01839], [-121.72494, 37.01805], [-121.72474, 37.01786], [-121.72452, 37.01769], [-121.72427, 37.01753], [-121.72389, 37.01735], [-121.72363, 37.01727], [-121.72336, 37.01721], [-121.72223, 37.01703], [-121.72176, 37.01693], [-121.72133, 37.01679], [-121.72106, 37.01668], [-121.72081, 37.01655], [-121.72057, 37.01639], [-121.72035, 37.01621], [-121.72016, 37.01602], [-121.71912, 37.01475], [-121.71821, 37.01369], [-121.71826, 37.01358], [-121.71827, 37.01345], [-121.7181, 37.01308], [-121.718, 37.0129], [-121.71786, 37.01273], [-121.7177, 37.01258], [-121.71729, 37.01231], [-121.71724, 37.01223], [-121.71724, 37.01215], [-121.71729, 37.01206], [-121.71738, 37.01197], [-121.71748, 37.0119], [-121.71761, 37.01185], [-121.71822, 37.01174], [-121.719, 37.01167], [-121.71923, 37.01163], [-121.71945, 37.01157], [-121.71966, 37.01147], [-121.71985, 37.01136], [-121.72023, 37.01107], [-121.72042, 37.01084], [-121.72065, 37.01038], [-121.72073, 37.01028], [-121.72089, 37.01015], [-121.72116, 37.01002], [-121.72128, 37.00993], [-121.72139, 37.00983], [-121.72147, 37.00971], [-121.72152, 37.00958], [-121.72154, 37.00945], [-121.72155, 37.00931], [-121.72152, 37.00917], [-121.72147, 37.00901], [-121.72119, 37.00864], [-121.7217, 37.00769], [-121.72196, 37.00744], [-121.72557, 37.01114], [-121.72673, 37.01494], [-121.73044, 37.01336], [-121.73523, 37.0163]]]]} | No Public Access 3 | 37026 | Mount Madonna County Park | 29288 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/MtMadonna.aspx | Santa Clara 19 | 1720.675 | Mount Madonna County Park | 0 | Local Park 2 | 4 |
12239 | 12239 | 12238 | {"type": "MultiPolygon", "coordinates": [[[[-121.81481, 37.18545], [-121.81443, 37.18597], [-121.81411, 37.18586], [-121.81364, 37.18607], [-121.81328, 37.18597], [-121.81248, 37.18616], [-121.8121, 37.18634], [-121.81191, 37.1867], [-121.81129, 37.18674], [-121.81119, 37.18707], [-121.81007, 37.18754], [-121.80967, 37.18793], [-121.80876, 37.18806], [-121.80828, 37.18817], [-121.80768, 37.1887], [-121.80721, 37.18917], [-121.80733, 37.18936], [-121.80713, 37.18941], [-121.80652, 37.18941], [-121.80585, 37.18957], [-121.80484, 37.18906], [-121.80459, 37.1887], [-121.80433, 37.18869], [-121.80389, 37.18904], [-121.80401, 37.18967], [-121.8038, 37.18975], [-121.80308, 37.18935], [-121.80225, 37.18942], [-121.80234, 37.18906], [-121.80212, 37.18882], [-121.80163, 37.18877], [-121.80144, 37.18892], [-121.80106, 37.18913], [-121.80106, 37.18872], [-121.80086, 37.18855], [-121.79987, 37.1886], [-121.79945, 37.18855], [-121.79942, 37.18814], [-121.79966, 37.18806], [-121.79993, 37.18815], [-121.80072, 37.18789], [-121.80062, 37.18771], [-121.80016, 37.1876], [-121.80011, 37.18752], [-121.80048, 37.18729], [-121.80037, 37.18708], [-121.80011, 37.18699], [-121.79949, 37.18707], [-121.79953, 37.1867], [-121.79952, 37.18669], [-121.79918, 37.18667], [-121.79884, 37.18685], [-121.79882, 37.18684], [-121.79892, 37.1866], [-121.7987, 37.18623], [-121.7983, 37.18624], [-121.79766, 37.18685], [-121.79754, 37.18628], [-121.79722, 37.18623], [-121.79694, 37.18653], [-121.7968, 37.18633], [-121.79705, 37.18608], [-121.79691, 37.18585], [-121.79713, 37.18572], [-121.79689, 37.18547], [-121.79672, 37.18544], [-121.79659, 37.18535], [-121.79644, 37.18517], [-121.79633, 37.18496], [-121.79629, 37.18479], [-121.79617, 37.18353], [-121.79606, 37.18286], [-121.79494, 37.17798], [-121.7893, 37.17799], [-121.78787, 37.17503], [-121.79735, 37.17316], [-121.79728, 37.1727], [-121.79721, 37.17205], [-121.79887, 37.17199], [-121.80285, 37.17191], [-121.81129, 37.17604], [-121.81128, 37.17607], [-121.81161, 37.1763], [-121.81395, 37.17834], [-121.81422, 37.17843], [-121.81424, 37.17881], [-121.8145, 37.17904], [-121.8143, 37.17932], [-121.8142, 37.17969], [-121.81354, 37.18042], [-121.81255, 37.18117], [-121.81253, 37.1814], [-121.81326, 37.18189], [-121.81377, 37.18342], [-121.81418, 37.18413], [-121.81453, 37.18459], [-121.81481, 37.18545]], [[-121.8138, 37.18355], [-121.81379, 37.18354], [-121.81252, 37.1835], [-121.81247, 37.1844], [-121.81375, 37.18444], [-121.8138, 37.18355]]], [[[-121.81966, 37.19051], [-121.81954, 37.19058], [-121.81966, 37.19073], [-121.81628, 37.19243], [-121.81628, 37.19244], [-121.81771, 37.19348], [-121.81621, 37.19407], [-121.81534, 37.19382], [-121.81409, 37.197], [-121.81255, 37.19662], [-121.80925, 37.19534], [-121.80926, 37.1953], [-121.80483, 37.19356], [-121.80121, 37.19199], [-121.80043, 37.19164], [-121.79993, 37.19139], [-121.79978, 37.1913], [-121.79948, 37.19106], [-121.79815, 37.18987], [-121.79774, 37.18931], [-121.79705, 37.18819], [-121.79685, 37.18793], [-121.79667, 37.18773], [-121.79643, 37.18752], [-121.79622, 37.18738], [-121.79626, 37.18738], [-121.79728, 37.187], [-121.79742, 37.18696], [-121.79746, 37.18705], [-121.79766, 37.18713], [-121.79822, 37.18683], [-121.79849, 37.18655], [-121.79858, 37.18709], [-121.79917, 37.18697], [-121.79927, 37.18717], [-121.79974, 37.18734], [-121.79993, 37.18781], [-121.79945, 37.18779], [-121.79906, 37.18801], [-121.79921, 37.18869], [-121.79971, 37.18887], [-121.80075, 37.18882], [-121.80068, 37.18913], [-121.80092, 37.18935], [-121.80182, 37.18906], [-121.80197, 37.18946], [-121.80237, 37.18968], [-121.80289, 37.18959], [-121.80373, 37.19001], [-121.80437, 37.18981], [-121.80451, 37.18921], [-121.80487, 37.18956], [-121.80581, 37.18993], [-121.80753, 37.18959], [-121.80818, 37.18894], [-121.80837, 37.18891], [-121.80875, 37.18857], [-121.8102, 37.18806], [-121.81041, 37.1878], [-121.81085, 37.18764], [-121.81182, 37.18708], [-121.81219, 37.18702], [-121.81246, 37.18655], [-121.81315, 37.18646], [-121.8134, 37.18627], [-121.81369, 37.18628], [-121.81411, 37.1862], [-121.81436, 37.18625], [-121.81461, 37.18613], [-121.81494, 37.18576], [-121.81511, 37.18541], [-121.81503, 37.1848], [-121.81446, 37.18409], [-121.81444, 37.18399], [-121.81554, 37.18375], [-121.81547, 37.18401], [-121.81584, 37.18451], [-121.81613, 37.1848], [-121.81612, 37.18486], [-121.81578, 37.18507], [-121.8158, 37.1853], [-121.81578, 37.18554], [-121.81565, 37.18646], [-121.81576, 37.18744], [-121.81583, 37.18771], [-121.81582, 37.18783], [-121.81578, 37.18791], [-121.81534, 37.18815], [-121.81486, 37.18815], [-121.81462, 37.18823], [-121.81441, 37.18879], [-121.81477, 37.18888], [-121.81561, 37.18868], [-121.81639, 37.19007], [-121.81727, 37.18963], [-121.81845, 37.1891], [-121.81883, 37.18887], [-121.81959, 37.1894], [-121.81897, 37.18971], [-121.819, 37.18985], [-121.81911, 37.18992], [-121.81966, 37.19051]]]]} | No Public Access 3 | 25443 | Calero County Park | 16679 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 963.38 | Calero County Park | 0 | Local Park 2 | 4 |
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]);