units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where DES_TP = 2 and MNG_AGENCY = 204 sorted by MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15231 | 15231 | 15230 | {"type": "Polygon", "coordinates": [[[-122.14332, 38.17919], [-122.14296, 38.17925], [-122.14262, 38.17942], [-122.1425, 38.1795], [-122.14239, 38.17958], [-122.14233, 38.17967], [-122.14223, 38.17974], [-122.14226, 38.18007], [-122.14225, 38.18015], [-122.14202, 38.1808], [-122.14205, 38.18081], [-122.14207, 38.18128], [-122.14166, 38.18144], [-122.14114, 38.18158], [-122.14098, 38.18119], [-122.14101, 38.18059], [-122.14076, 38.18059], [-122.14018, 38.18064], [-122.13998, 38.18068], [-122.13961, 38.18077], [-122.13918, 38.18092], [-122.13965, 38.18048], [-122.13979, 38.18028], [-122.13986, 38.18016], [-122.13998, 38.17983], [-122.14, 38.1796], [-122.13999, 38.17933], [-122.13995, 38.17915], [-122.13985, 38.1789], [-122.13963, 38.17855], [-122.13819, 38.17681], [-122.13787, 38.17644], [-122.13809, 38.17635], [-122.13866, 38.17604], [-122.13835, 38.17559], [-122.13839, 38.17549], [-122.13857, 38.17551], [-122.13863, 38.17547], [-122.13868, 38.17533], [-122.13879, 38.17524], [-122.1403, 38.17522], [-122.1412, 38.17485], [-122.14219, 38.17486], [-122.14224, 38.17744], [-122.14237, 38.17765], [-122.1426, 38.17766], [-122.14264, 38.17762], [-122.14272, 38.17759], [-122.1428, 38.17761], [-122.14285, 38.17769], [-122.14317, 38.17836], [-122.14316, 38.17845], [-122.14305, 38.17875], [-122.14332, 38.17919]]]} | Open Access 1 | 47292 | Cordelia Community Park | 30998 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | https://www.fairfield.ca.gov/gov/depts/pw/parks/parks/cordelia.asp | Solano 26 | 47.581 | Cordelia Community Park | 0 | Local Park 2 | 4 |
16301 | 16301 | 16300 | {"type": "MultiPolygon", "coordinates": [[[[-122.15102, 38.24578], [-122.14386, 38.25089], [-122.14461, 38.25163], [-122.14453, 38.25166], [-122.14452, 38.25167], [-122.14502, 38.25203], [-122.14385, 38.25229], [-122.14271, 38.25258], [-122.1411, 38.25312], [-122.13968, 38.25353], [-122.13869, 38.25372], [-122.13763, 38.25369], [-122.13647, 38.25343], [-122.13524, 38.2529], [-122.13437, 38.25224], [-122.13399, 38.25192], [-122.134, 38.25189], [-122.13252, 38.24867], [-122.13348, 38.24826], [-122.13334, 38.24795], [-122.13189, 38.24507], [-122.1314, 38.24508], [-122.13075, 38.24528], [-122.13028, 38.24489], [-122.13041, 38.24459], [-122.13106, 38.24436], [-122.12907, 38.24074], [-122.12938, 38.24046], [-122.12955, 38.23998], [-122.12951, 38.23932], [-122.12932, 38.23893], [-122.12917, 38.23867], [-122.12897, 38.2386], [-122.12869, 38.23837], [-122.12841, 38.23779], [-122.12844, 38.23766], [-122.12853, 38.23757], [-122.12873, 38.23754], [-122.12894, 38.23749], [-122.1292, 38.23725], [-122.12936, 38.237], [-122.12943, 38.23673], [-122.1294, 38.23663], [-122.12929, 38.23655], [-122.12921, 38.23629], [-122.12928, 38.23582], [-122.12935, 38.23565], [-122.12985, 38.23534], [-122.13003, 38.23535], [-122.13014, 38.23541], [-122.13031, 38.23538], [-122.13049, 38.23528], [-122.13085, 38.2362], [-122.13104, 38.23714], [-122.13302, 38.23686], [-122.13279, 38.23642], [-122.13275, 38.23626], [-122.1327, 38.23616], [-122.13278, 38.23609], [-122.13274, 38.23583], [-122.13294, 38.23544], [-122.13266, 38.23394], [-122.13292, 38.23321], [-122.13319, 38.23325], [-122.13333, 38.2333], [-122.13355, 38.2333], [-122.13372, 38.23324], [-122.13457, 38.23244], [-122.13529, 38.23156], [-122.13565, 38.23179], [-122.1363, 38.23132], [-122.13691, 38.23122], [-122.13761, 38.23117], [-122.13797, 38.23128], [-122.13805, 38.23155], [-122.1381, 38.23206], [-122.13793, 38.2328], [-122.13798, 38.23398], [-122.13797, 38.2345], [-122.13808, 38.23477], [-122.13543, 38.23575], [-122.1352, 38.23582], [-122.13529, 38.23892], [-122.13534, 38.23896], [-122.13556, 38.24251], [-122.13727, 38.24246], [-122.13768, 38.24198], [-122.13765, 38.24163], [-122.13998, 38.24117], [-122.13997, 38.24098], [-122.13995, 38.24097], [-122.13972, 38.23668], [-122.14143, 38.23658], [-122.14147, 38.23543], [-122.1423, 38.23525], [-122.14423, 38.2337], [-122.14429, 38.23359], [-122.1445, 38.23305], [-122.14465, 38.23309], [-122.14481, 38.23276], [-122.1448, 38.23275], [-122.14469, 38.23276], [-122.14463, 38.23271], [-122.1446, 38.2326], [-122.1446, 38.23237], [-122.14482, 38.23236], [-122.14496, 38.23198], [-122.14509, 38.23155], [-122.14521, 38.23134], [-122.1453, 38.23126], [-122.14553, 38.23065], [-122.14565, 38.23044], [-122.14589, 38.22989], [-122.14612, 38.22989], [-122.14619, 38.22988], [-122.14586, 38.23068], [-122.14556, 38.23124], [-122.14544, 38.23165], [-122.14536, 38.23173], [-122.14536, 38.23183], [-122.14522, 38.23198], [-122.1452, 38.2321], [-122.14513, 38.23225], [-122.14513, 38.23271], [-122.14492, 38.23274], [-122.14485, 38.23288], [-122.14478, 38.23307], [-122.14459, 38.23346], [-122.14422, 38.23433], [-122.14464, 38.23468], [-122.14568, 38.23568], [-122.14564, 38.23627], [-122.14643, 38.23656], [-122.14659, 38.23647], [-122.14711, 38.23631], [-122.14798, 38.23633], [-122.14824, 38.23616], [-122.14827, 38.23595], [-122.14825, 38.23531], [-122.14815, 38.23492], [-122.14926, 38.23574], [-122.14949, 38.23604], [-122.14944, 38.23665], [-122.14945, 38.2367], [-122.14928, 38.23724], [-122.14917, 38.23844], [-122.14953, 38.24004], [-122.14946, 38.24025], [-122.14909, 38.24099], [-122.14854, 38.24156], [-122.14824, 38.24179], [-122.15102, 38.24578]]], [[[-122.14739, 38.22029], [-122.14697, 38.22072], [-122.14692, 38.22074], [-122.14691, 38.22069], [-122.14522, 38.22013], [-122.14465, 38.22005], [-122.14441, 38.22008], [-122.14377, 38.2203], [-122.14337, 38.22053], [-122.14266, 38.21928], [-122.14238, 38.21897], [-122.14212, 38.21871], [-122.14224, 38.21863], [-122.14246, 38.21862], [-122.14293, 38.21868], [-122.14334, 38.21876], [-122.14437, 38.21925], [-122.14523, 38.21929], [-122.14572, 38.21935], [-122.14609, 38.21943], [-122.14645, 38.21957], [-122.14696, 38.21999], [-122.14739, 38.22029]]], [[[-122.14709, 38.22776], [-122.1467, 38.22871], [-122.14622, 38.22979], [-122.14618, 38.22981], [-122.14593, 38.22981], [-122.14693, 38.22753], [-122.14709, 38.22776]]], [[[-122.14745, 38.22715], [-122.14715, 38.22764], [-122.14696, 38.22732], [-122.14697, 38.22726], [-122.14714, 38.22705], [-122.1469, 38.22681], [-122.14697, 38.22676], [-122.14718, 38.22675], [-122.14745, 38.22715]]], [[[-122.15266, 38.22691], [-122.15132, 38.22765], [-122.15115, 38.22773], [-122.15121, 38.22762], [-122.15124, 38.2274], [-122.15105, 38.22686], [-122.15055, 38.22692], [-122.14892, 38.22463], [-122.14878, 38.22434], [-122.14876, 38.22434], [-122.14866, 38.22406], [-122.14857, 38.22351], [-122.14855, 38.22324], [-122.14847, 38.22268], [-122.14841, 38.22246], [-122.14794, 38.22181], [-122.14769, 38.2216], [-122.14703, 38.22128], [-122.14724, 38.22103], [-122.14745, 38.22083], [-122.14785, 38.22054], [-122.14829, 38.22014], [-122.14868, 38.22055], [-122.14847, 38.22092], [-122.14893, 38.22119], [-122.14918, 38.22144], [-122.1492, 38.22144], [-122.14947, 38.22177], [-122.15032, 38.21977], [-122.15053, 38.21993], [-122.15053, 38.21995], [-122.15069, 38.22008], [-122.15028, 38.22061], [-122.14984, 38.22167], [-122.1498, 38.22218], [-122.14981, 38.22239], [-122.14986, 38.22268], [-122.14985, 38.22293], [-122.1498, 38.22323], [-122.14979, 38.22354], [-122.14984, 38.22379], [-122.14994, 38.22408], [-122.15009, 38.22432], [-122.15029, 38.22453], [-122.15041, 38.22474], [-122.15047, 38.22495], [-122.15047, 38.22504], [-122.15064, 38.2254], [-122.15092, 38.22564], [-122.15118, 38.22576], [-122.15165, 38.22589], [-122.15202, 38.22606], [-122.15223, 38.22605], [-122.15266, 38.22691]]], [[[-122.14804, 38.22571], [-122.14778, 38.22621], [-122.14767, 38.22658], [-122.14772, 38.2268], [-122.14766, 38.22702], [-122.14759, 38.22693], [-122.14758, 38.22694], [-122.14729, 38.2265], [-122.1472, 38.22629], [-122.14728, 38.22621], [-122.14749, 38.22619], [-122.14755, 38.22616], [-122.14776, 38.22562], [-122.14793, 38.22569], [-122.14804, 38.22571]]], [[[-122.14865, 38.22441], [-122.14861, 38.22444], [-122.14843, 38.22472], [-122.14817, 38.22539], [-122.14813, 38.22544], [-122.14807, 38.22564], [-122.1479, 38.22559], [-122.1478, 38.22553], [-122.1483, 38.22441], [-122.14839, 38.22412], [-122.14851, 38.22404], [-122.14865, 38.22441]]], [[[-122.15194, 38.21681], [-122.15102, 38.21895], [-122.15092, 38.21913], [-122.1506, 38.21979], [-122.15039, 38.21963], [-122.15131, 38.21749], [-122.1517, 38.21667], [-122.15194, 38.21681]]], [[[-122.15265, 38.21517], [-122.15228, 38.21596], [-122.15225, 38.21611], [-122.15217, 38.21616], [-122.15218, 38.21627], [-122.15216, 38.21636], [-122.15202, 38.21666], [-122.15196, 38.21668], [-122.15188, 38.21668], [-122.15175, 38.2166], [-122.15149, 38.21637], [-122.15151, 38.21628], [-122.15179, 38.21595], [-122.15217, 38.21519], [-122.15229, 38.21513], [-122.15265, 38.21517]]]]} | Open Access 1 | 223 | Rockville Hills Regional Park | 3647 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/open_space/rockville_hills_regional_park/default.asp | Solano 26 | 729.531 | Rockville Hills RP | 0 | Local Park 2 | 4 |
17037 | 17037 | 17036 | {"type": "Polygon", "coordinates": [[[-122.049, 38.2523], [-122.04898, 38.25324], [-122.04829, 38.25323], [-122.04829, 38.25341], [-122.04822, 38.25341], [-122.04799, 38.2534], [-122.04772, 38.25335], [-122.04706, 38.25312], [-122.04688, 38.25309], [-122.04657, 38.25308], [-122.04598, 38.25321], [-122.04557, 38.25337], [-122.04533, 38.25348], [-122.04532, 38.25288], [-122.04554, 38.25289], [-122.04567, 38.25287], [-122.04568, 38.25245], [-122.04566, 38.25234], [-122.04575, 38.25233], [-122.04575, 38.25227], [-122.04584, 38.25215], [-122.04589, 38.25212], [-122.04666, 38.25213], [-122.0467, 38.2522], [-122.0473, 38.25219], [-122.04727, 38.25226], [-122.04764, 38.25227], [-122.04806, 38.25237], [-122.04832, 38.2524], [-122.04853, 38.25236], [-122.04867, 38.2523], [-122.04873, 38.25226], [-122.04875, 38.25228], [-122.049, 38.2523]]]} | Open Access 1 | 28312 | Civic Center Park | 17356 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 8.233 | Civic Ctr. 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]);