units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where LABEL_NAME = "Mount Madonna County Park", MNG_AGENCY = 465 and MNG_AG_TYP = 7
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
ACCESS_TYP 2
MNG_AG_TYP 1
- County Agency - Parks · 4 ✖
MNG_AGENCY 1
- Santa Clara County Parks and Recreation Dept., County of · 4 ✖
DES_TP 1
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 |
3971 | 3971 | 3970 | {"type": "Polygon", "coordinates": [[[-121.68844, 36.99391], [-121.68834, 36.99433], [-121.68829, 36.99445], [-121.6881, 36.99477], [-121.68806, 36.99491], [-121.68805, 36.99504], [-121.68808, 36.99518], [-121.68824, 36.99549], [-121.68824, 36.99564], [-121.68821, 36.99576], [-121.68799, 36.99607], [-121.68785, 36.99624], [-121.68778, 36.99632], [-121.68747, 36.99652], [-121.68723, 36.99676], [-121.68792, 36.99542], [-121.68787, 36.99477], [-121.68815, 36.99388], [-121.68844, 36.99391]]]} | Open Access 1 | 38002 | Mount Madonna County Park | 29287 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 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 | 1.998 | Mount Madonna 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 |
8878 | 8878 | 8877 | {"type": "Polygon", "coordinates": [[[-121.73579, 36.99015], [-121.73447, 36.99077], [-121.73447, 36.99079], [-121.73464, 36.99099], [-121.73457, 36.99126], [-121.73408, 36.99167], [-121.73226, 36.99191], [-121.73204, 36.9918], [-121.73132, 36.99174], [-121.73019, 36.99221], [-121.72997, 36.99226], [-121.72902, 36.99271], [-121.72846, 36.99279], [-121.72811, 36.99317], [-121.72789, 36.99327], [-121.72671, 36.99458], [-121.72662, 36.99507], [-121.72646, 36.99525], [-121.72637, 36.99585], [-121.72581, 36.99653], [-121.72795, 36.99801], [-121.72066, 37.00505], [-121.71733, 37.00769], [-121.71733, 37.0077], [-121.72141, 37.00934], [-121.72141, 37.00944], [-121.72136, 37.00963], [-121.72125, 37.0098], [-121.72108, 37.00993], [-121.72075, 37.01011], [-121.72062, 37.01021], [-121.72053, 37.01034], [-121.72034, 37.01071], [-121.72024, 37.01086], [-121.72005, 37.01106], [-121.71977, 37.01128], [-121.71949, 37.01143], [-121.71919, 37.01153], [-121.71887, 37.01158], [-121.71809, 37.01164], [-121.71757, 37.01175], [-121.71743, 37.0118], [-121.71731, 37.01187], [-121.71721, 37.01196], [-121.71711, 37.01212], [-121.7171, 37.01224], [-121.71716, 37.01235], [-121.7176, 37.01266], [-121.71782, 37.01287], [-121.71797, 37.01312], [-121.71814, 37.0135], [-121.71813, 37.01355], [-121.71787, 37.01384], [-121.71727, 37.01407], [-121.71714, 37.0147], [-121.71699, 37.01521], [-121.71676, 37.0155], [-121.71649, 37.01569], [-121.71652, 37.01589], [-121.7169, 37.01609], [-121.71687, 37.01655], [-121.71677, 37.01679], [-121.7169, 37.01703], [-121.71701, 37.0171], [-121.71706, 37.01719], [-121.71685, 37.01755], [-121.71702, 37.01791], [-121.71702, 37.0181], [-121.71725, 37.01843], [-121.71776, 37.01886], [-121.71856, 37.01889], [-121.71861, 37.01938], [-121.7191, 37.01981], [-121.71921, 37.02015], [-121.71921, 37.02019], [-121.71917, 37.02032], [-121.7191, 37.02039], [-121.71812, 37.0211], [-121.71806, 37.02119], [-121.71798, 37.02138], [-121.71763, 37.02145], [-121.71736, 37.02156], [-121.71642, 37.02213], [-121.71631, 37.02222], [-121.71623, 37.02232], [-121.71619, 37.02244], [-121.71617, 37.02256], [-121.71619, 37.02277], [-121.71615, 37.023], [-121.71607, 37.02315], [-121.71586, 37.02342], [-121.71578, 37.02357], [-121.71356, 37.02358], [-121.71352, 37.01979], [-121.6934, 37.02305], [-121.68866, 37.02026], [-121.67729, 37.01335], [-121.6772, 37.00495], [-121.66942, 37.00492], [-121.66959, 37.00486], [-121.67192, 37.00422], [-121.67208, 37.00414], [-121.67228, 37.00399], [-121.67239, 37.00387], [-121.67264, 37.00352], [-121.67274, 37.00342], [-121.67293, 37.00332], [-121.67307, 37.00329], [-121.67321, 37.00328], [-121.67364, 37.0033], [-121.67392, 37.00328], [-121.6742, 37.00325], [-121.67456, 37.00317], [-121.67479, 37.00315], [-121.67502, 37.00316], [-121.67525, 37.00319], [-121.67521, 37.00309], [-121.67587, 37.0032], [-121.67629, 37.00332], [-121.67689, 37.0034], [-121.67871, 37.00351], [-121.67943, 37.00359], [-121.68004, 37.0037], [-121.68062, 37.00388], [-121.68126, 37.00395], [-121.68199, 37.00385], [-121.68237, 37.0037], [-121.68281, 37.00343], [-121.68341, 37.00311], [-121.68384, 37.00298], [-121.68441, 37.00278], [-121.68471, 37.00262], [-121.68518, 37.00212], [-121.6854, 37.0018], [-121.68549, 37.00119], [-121.6863, 36.9998], [-121.68643, 36.99936], [-121.68661, 36.99896], [-121.68674, 36.99859], [-121.68672, 36.99802], [-121.68675, 36.99781], [-121.68685, 36.99752], [-121.68691, 36.9974], [-121.68744, 36.99676], [-121.68762, 36.9966], [-121.68793, 36.99645], [-121.68806, 36.99632], [-121.68817, 36.99618], [-121.68839, 36.99583], [-121.68842, 36.99573], [-121.68842, 36.99563], [-121.68825, 36.99514], [-121.68824, 36.99496], [-121.68827, 36.99485], [-121.68847, 36.99458], [-121.68854, 36.99446], [-121.68858, 36.99435], [-121.6886, 36.99416], [-121.69764, 36.99405], [-121.69869, 36.99486], [-121.7093, 37.00138], [-121.70936, 37.0011], [-121.70968, 37.00069], [-121.71149, 36.99954], [-121.71207, 36.99878], [-121.71285, 36.99842], [-121.71386, 36.99802], [-121.71541, 36.99709], [-121.71607, 36.99662], [-121.71641, 36.99633], [-121.71704, 36.9962], [-121.71707, 36.99622], [-121.71705, 36.99625], [-121.71707, 36.99626], [-121.7228, 36.99324], [-121.7302, 36.99108], [-121.73207, 36.99031], [-121.7342, 36.99045], [-121.73435, 36.99034], [-121.73459, 36.99038], [-121.73496, 36.99037], [-121.73521, 36.99011], [-121.73579, 36.99015]]]} | Open Access 1 | 14504 | Mount Madonna County Park | 29287 | 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 | 2465.622 | Mount Madonna 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]);