units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and LABEL_NAME = "Mount Madonna County Park"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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]);