units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 204 sorted by PARK_URL descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
5964 | 5964 | 5963 | {"type": "MultiPolygon", "coordinates": [[[[-122.0625, 38.2797], [-122.06186, 38.28047], [-122.06153, 38.28134], [-122.0613, 38.28241], [-122.06124, 38.28345], [-122.06042, 38.29038], [-122.06061, 38.29042], [-122.0605, 38.3027], [-122.06045, 38.30288], [-122.04996, 38.30113], [-122.0502, 38.29051], [-122.05032, 38.29059], [-122.05134, 38.29095], [-122.05176, 38.29181], [-122.05189, 38.29223], [-122.05212, 38.2926], [-122.05244, 38.29299], [-122.05246, 38.2931], [-122.05326, 38.29312], [-122.05327, 38.29311], [-122.05321, 38.29218], [-122.05271, 38.29124], [-122.05325, 38.29102], [-122.05394, 38.29015], [-122.05466, 38.29019], [-122.05522, 38.29074], [-122.05559, 38.29146], [-122.05593, 38.29148], [-122.05685, 38.29144], [-122.05745, 38.29191], [-122.05776, 38.29202], [-122.05796, 38.29201], [-122.05853, 38.29262], [-122.05862, 38.29354], [-122.05812, 38.29384], [-122.0575, 38.29393], [-122.05734, 38.29431], [-122.05744, 38.29525], [-122.05748, 38.29545], [-122.05784, 38.2958], [-122.05854, 38.29599], [-122.05887, 38.29594], [-122.0595, 38.29562], [-122.05982, 38.29484], [-122.05946, 38.29416], [-122.05911, 38.2937], [-122.05896, 38.29312], [-122.05883, 38.29251], [-122.05868, 38.29218], [-122.05936, 38.29154], [-122.05988, 38.29089], [-122.06005, 38.29031], [-122.06006, 38.29005], [-122.05944, 38.28962], [-122.0586, 38.2896], [-122.05725, 38.29003], [-122.0569, 38.29008], [-122.0554, 38.28955], [-122.05503, 38.28914], [-122.05485, 38.28883], [-122.05418, 38.28847], [-122.05381, 38.28792], [-122.05421, 38.28626], [-122.05482, 38.28614], [-122.05522, 38.28634], [-122.05623, 38.28629], [-122.05687, 38.28593], [-122.05669, 38.28542], [-122.05609, 38.28457], [-122.05599, 38.28398], [-122.05562, 38.28323], [-122.05534, 38.28258], [-122.05532, 38.2821], [-122.0547, 38.28166], [-122.05481, 38.281], [-122.05602, 38.2805], [-122.05772, 38.28002], [-122.05926, 38.27989], [-122.0603, 38.27974], [-122.06161, 38.2793], [-122.06244, 38.27929], [-122.0625, 38.2797]]], [[[-122.05355, 38.28689], [-122.05338, 38.28746], [-122.05345, 38.28766], [-122.05348, 38.28815], [-122.05333, 38.28857], [-122.05309, 38.28901], [-122.05301, 38.2892], [-122.05265, 38.28922], [-122.05252, 38.28925], [-122.05206, 38.28924], [-122.05185, 38.28918], [-122.05163, 38.28903], [-122.0515, 38.28882], [-122.05101, 38.28815], [-122.05089, 38.28804], [-122.05077, 38.28805], [-122.05049, 38.28825], [-122.05021, 38.28809], [-122.05023, 38.28799], [-122.05035, 38.2877], [-122.05035, 38.28743], [-122.05043, 38.28701], [-122.05041, 38.28663], [-122.05041, 38.28638], [-122.05054, 38.2861], [-122.05061, 38.28585], [-122.05085, 38.28599], [-122.05108, 38.28597], [-122.05184, 38.28623], [-122.05196, 38.28631], [-122.05236, 38.28653], [-122.05281, 38.28655], [-122.05325, 38.28667], [-122.05346, 38.28685], [-122.05355, 38.28689]]]]} | Open Access 1 | 628 | Serpas Ranch Open Space | 3650 | 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/open_space_properties/serpas.asp | Solano 26 | 414.58 | Serpas Ranch OS | 0 | Local Recreation Area 3 | 4 |
16187 | 16187 | 16186 | {"type": "MultiPolygon", "coordinates": [[[[-122.0514, 38.28443], [-122.05096, 38.28498], [-122.05043, 38.28567], [-122.05015, 38.28627], [-122.05004, 38.2872], [-122.04994, 38.28781], [-122.04973, 38.28823], [-122.04931, 38.28851], [-122.04888, 38.28873], [-122.0483, 38.28884], [-122.0483, 38.28864], [-122.04817, 38.28826], [-122.04791, 38.28782], [-122.04734, 38.28753], [-122.04679, 38.28749], [-122.04592, 38.28747], [-122.04522, 38.2875], [-122.04464, 38.28741], [-122.04425, 38.28723], [-122.04383, 38.28726], [-122.04352, 38.28747], [-122.04309, 38.28763], [-122.04248, 38.28772], [-122.04199, 38.28757], [-122.04141, 38.28734], [-122.04086, 38.28714], [-122.04026, 38.28711], [-122.03936, 38.28744], [-122.0397, 38.2878], [-122.03943, 38.28804], [-122.03863, 38.2879], [-122.03821, 38.28794], [-122.03753, 38.28862], [-122.03698, 38.28939], [-122.03706, 38.28969], [-122.03748, 38.28999], [-122.03713, 38.29022], [-122.03723, 38.29079], [-122.03618, 38.29088], [-122.0356, 38.29112], [-122.03521, 38.29149], [-122.03478, 38.29216], [-122.03468, 38.29302], [-122.03477, 38.29335], [-122.03497, 38.29383], [-122.03536, 38.29405], [-122.03581, 38.29425], [-122.03554, 38.29438], [-122.03488, 38.29494], [-122.03485, 38.2953], [-122.03555, 38.29564], [-122.03547, 38.29577], [-122.03432, 38.29518], [-122.03443, 38.29309], [-122.03466, 38.29213], [-122.03528, 38.29094], [-122.03613, 38.28975], [-122.03833, 38.2873], [-122.03833, 38.28728], [-122.04089, 38.28432], [-122.04154, 38.2845], [-122.0419, 38.2843], [-122.04258, 38.28491], [-122.04284, 38.285], [-122.04325, 38.28488], [-122.04549, 38.28475], [-122.04586, 38.28457], [-122.04648, 38.28442], [-122.04686, 38.28458], [-122.04768, 38.2847], [-122.04841, 38.28473], [-122.04929, 38.28473], [-122.04968, 38.28472], [-122.05015, 38.28462], [-122.05008, 38.28378], [-122.05017, 38.28378], [-122.05072, 38.28396], [-122.0514, 38.28443]]], [[[-122.0502, 38.29051], [-122.04995, 38.30113], [-122.04384, 38.30183], [-122.0438, 38.30179], [-122.03492, 38.3018], [-122.03473, 38.30139], [-122.03494, 38.3009], [-122.03532, 38.30045], [-122.03581, 38.30044], [-122.03693, 38.30121], [-122.03876, 38.30066], [-122.03979, 38.30003], [-122.04073, 38.29904], [-122.04072, 38.2986], [-122.03987, 38.29813], [-122.03955, 38.29758], [-122.03913, 38.29676], [-122.03811, 38.29654], [-122.0378, 38.29613], [-122.038, 38.29568], [-122.03777, 38.2952], [-122.03698, 38.29524], [-122.03666, 38.29456], [-122.03694, 38.29376], [-122.03772, 38.29323], [-122.03811, 38.29312], [-122.03882, 38.29345], [-122.04005, 38.29336], [-122.04052, 38.29328], [-122.04108, 38.2929], [-122.04163, 38.29247], [-122.04283, 38.29295], [-122.04391, 38.29334], [-122.04437, 38.29335], [-122.04439, 38.29328], [-122.04455, 38.29313], [-122.0452, 38.29318], [-122.04535, 38.29325], [-122.04537, 38.29324], [-122.04588, 38.29333], [-122.04613, 38.29353], [-122.0467, 38.29342], [-122.047, 38.29377], [-122.04766, 38.29425], [-122.04819, 38.29428], [-122.04853, 38.29412], [-122.04864, 38.29384], [-122.04868, 38.29342], [-122.04844, 38.29293], [-122.04859, 38.29243], [-122.04849, 38.29166], [-122.0483, 38.291], [-122.04828, 38.29034], [-122.04797, 38.29012], [-122.04789, 38.28928], [-122.04823, 38.28927], [-122.04906, 38.28904], [-122.04998, 38.28847], [-122.05003, 38.28953], [-122.04969, 38.29016], [-122.0502, 38.29051]]]]} | Open Access 1 | 29159 | Rolling Hills Open Space | 3649 | 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/open_space_properties/rollinghills.asp | Solano 26 | 346.409 | Rolling Hills OS | 0 | Local Recreation Area 3 | 4 |
564 | 564 | 563 | {"type": "Polygon", "coordinates": [[[-122.04514, 38.26755], [-122.04396, 38.26758], [-122.04393, 38.26754], [-122.04333, 38.26755], [-122.04331, 38.26645], [-122.04405, 38.26643], [-122.04513, 38.26644], [-122.04514, 38.26755]]]} | Open Access 1 | 1883 | Veteran's Memorial Park | 27011 | 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 | 4.887 | Veteran's Memorial Park | 0 | Local Park 2 | 4 | |
748 | 748 | 747 | {"type": "Polygon", "coordinates": [[[-122.06423, 38.24698], [-122.06271, 38.24698], [-122.06272, 38.24918], [-122.05835, 38.24917], [-122.0583, 38.24668], [-122.05833, 38.24524], [-122.06423, 38.2453], [-122.06423, 38.24698]]]} | Open Access 1 | 4870 | Alan Witt Park | 15325 | 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 | 47.468 | Alan Witt Park | 0 | Local Park 2 | 4 | |
2283 | 2283 | 2282 | {"type": "Polygon", "coordinates": [[[-121.96736, 38.30157], [-121.96735, 38.30183], [-121.96664, 38.30199], [-121.96611, 38.30257], [-121.96381, 38.307], [-121.96352, 38.30736], [-121.96535, 38.3109], [-121.96492, 38.31134], [-121.96492, 38.31136], [-121.96449, 38.31183], [-121.96352, 38.31397], [-121.96367, 38.31471], [-121.96344, 38.31549], [-121.96158, 38.31549], [-121.95215, 38.31541], [-121.95186, 38.31079], [-121.95186, 38.31055], [-121.95185, 38.31054], [-121.95137, 38.30158], [-121.96736, 38.30157]]]} | No Public Access 3 | 18229 | Noonan Reservoir | 22785 | 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 | 428.883 | Noonan Reservoir | 0 | Local Recreation Area 3 | 4 | |
2312 | 2312 | 2311 | {"type": "Polygon", "coordinates": [[[-122.04197, 38.27757], [-122.0416, 38.27758], [-122.04147, 38.27761], [-122.04132, 38.27769], [-122.04097, 38.27776], [-122.04013, 38.27786], [-122.04013, 38.27648], [-122.04191, 38.27649], [-122.04197, 38.27653], [-122.04197, 38.27757]]]} | Open Access 1 | 16959 | Hillview Park | 19993 | 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 | 5.466 | Hillview Park | 0 | Local Park 2 | 4 | |
2709 | 2709 | 2708 | {"type": "Polygon", "coordinates": [[[-122.0663, 38.26167], [-122.0661, 38.26176], [-122.06535, 38.26216], [-122.06512, 38.26224], [-122.06493, 38.26224], [-122.06483, 38.26229], [-122.06477, 38.26237], [-122.06479, 38.26246], [-122.06486, 38.26256], [-122.06488, 38.26268], [-122.06496, 38.26292], [-122.06498, 38.26322], [-122.06495, 38.26326], [-122.06495, 38.26335], [-122.06428, 38.26336], [-122.06426, 38.26328], [-122.0641, 38.26327], [-122.06043, 38.26325], [-122.05979, 38.26322], [-122.05974, 38.26317], [-122.06176, 38.26072], [-122.06219, 38.26031], [-122.06226, 38.26028], [-122.06434, 38.25997], [-122.06437, 38.26003], [-122.06567, 38.25984], [-122.06576, 38.25986], [-122.06583, 38.25995], [-122.0663, 38.26167]]]} | Open Access 1 | 18312 | Octo-Inn | 23068 | 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 | 35.908 | Octo-Inn | None 222 | |||
3084 | 3084 | 3083 | {"type": "Polygon", "coordinates": [[[-122.14851, 38.21905], [-122.14849, 38.21918], [-122.14819, 38.2197], [-122.14804, 38.21983], [-122.14746, 38.22024], [-122.14718, 38.22007], [-122.14659, 38.21961], [-122.1463, 38.21944], [-122.14613, 38.21936], [-122.14611, 38.21932], [-122.14612, 38.21923], [-122.14714, 38.21825], [-122.14742, 38.21851], [-122.1478, 38.21875], [-122.14819, 38.21892], [-122.14844, 38.21898], [-122.14851, 38.21905]]]} | Open Access 1 | 1908 | Vintage Green Valley Park | 27145 | 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 | 6.117 | Vintage Green Valley Park | 0 | Local Park 2 | 4 | |
4127 | 4127 | 4126 | {"type": "Polygon", "coordinates": [[[-121.97912, 38.29715], [-121.97792, 38.29773], [-121.97767, 38.29735], [-121.97673, 38.2962], [-121.97642, 38.29586], [-121.97764, 38.29528], [-121.97775, 38.2953], [-121.97912, 38.29715]]]} | Open Access 1 | 28313 | Gary Falati Park | 19229 | 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 | 7.567 | Gary Falati Park | 0 | Local Park 2 | 4 | |
4128 | 4128 | 4127 | {"type": "Polygon", "coordinates": [[[-122.05474, 38.25477], [-122.05436, 38.25478], [-122.05436, 38.25458], [-122.05473, 38.25458], [-122.05474, 38.25477]]]} | Open Access 1 | 28314 | Hayes & Utah Street Tot Lot | 19754 | 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 | 0.175 | Hayes & Utah Street Tot Lot | 0 | Local Recreation Area 3 | 4 | |
5342 | 5342 | 5341 | {"type": "Polygon", "coordinates": [[[-122.1469, 38.19688], [-122.14679, 38.19694], [-122.14671, 38.19692], [-122.14621, 38.19672], [-122.14624, 38.1965], [-122.1459, 38.19623], [-122.14581, 38.19597], [-122.14579, 38.19565], [-122.14573, 38.19544], [-122.14544, 38.19539], [-122.14553, 38.19513], [-122.14552, 38.19504], [-122.14545, 38.19499], [-122.14532, 38.19496], [-122.14574, 38.19453], [-122.1455, 38.19433], [-122.14547, 38.19427], [-122.1454, 38.19423], [-122.14534, 38.1942], [-122.14531, 38.19416], [-122.1453, 38.19409], [-122.14489, 38.19382], [-122.14493, 38.19376], [-122.14492, 38.1937], [-122.14487, 38.19364], [-122.14479, 38.19361], [-122.14468, 38.19361], [-122.14444, 38.19344], [-122.14405, 38.19339], [-122.14384, 38.19325], [-122.14385, 38.19319], [-122.14372, 38.19311], [-122.14359, 38.19309], [-122.14314, 38.19344], [-122.14294, 38.19334], [-122.14252, 38.19319], [-122.1422, 38.19312], [-122.14152, 38.19309], [-122.14145, 38.19283], [-122.14127, 38.19279], [-122.14114, 38.1928], [-122.14081, 38.19294], [-122.14064, 38.19275], [-122.14051, 38.19264], [-122.14031, 38.19254], [-122.14016, 38.19252], [-122.14001, 38.19253], [-122.13988, 38.19248], [-122.13976, 38.19257], [-122.13948, 38.19243], [-122.13938, 38.19244], [-122.13927, 38.19234], [-122.13914, 38.19232], [-122.13848, 38.19213], [-122.13845, 38.19112], [-122.13856, 38.19112], [-122.1388, 38.19118], [-122.13893, 38.19125], [-122.13912, 38.19151], [-122.13921, 38.19149], [-122.13953, 38.19165], [-122.13969, 38.19189], [-122.13979, 38.19188], [-122.14007, 38.19193], [-122.14056, 38.19205], [-122.14059, 38.19207], [-122.1405, 38.19234], [-122.14049, 38.19242], [-122.14051, 38.19244], [-122.14082, 38.19249], [-122.14125, 38.19249], [-122.14155, 38.19253], [-122.14171, 38.19259], [-122.14197, 38.19271], [-122.14234, 38.19284], [-122.14243, 38.19282], [-122.14247, 38.19269], [-122.14294, 38.19268], [-122.14329, 38.19265], [-122.14344, 38.19262], [-122.14345, 38.19264], [-122.14356, 38.19253], [-122.14415, 38.19254], [-122.14424, 38.19266], [-122.14459, 38.1929], [-122.14492, 38.19301], [-122.14502, 38.19299], [-122.14505, 38.19304], [-122.14514, 38.19306], [-122.14522, 38.19305], [-122.14527, 38.19301], [-122.14551, 38.19328], [-122.14586, 38.19305], [-122.14623, 38.19418], [-122.14675, 38.1959], [-122.14689, 38.19633], [-122.14695, 38.19642], [-122.14698, 38.19666], [-122.1469, 38.19688]]]} | Open Access 1 | 15861 | American Canyon Creek Park | 15447 | 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 | 17.934 | American Canyon Creek Park | 0 | Local Park 2 | 4 | |
5469 | 5469 | 5468 | {"type": "Polygon", "coordinates": [[[-122.04031, 38.25555], [-122.04029, 38.25817], [-122.03928, 38.25818], [-122.03926, 38.25722], [-122.03922, 38.25721], [-122.03924, 38.25552], [-122.04018, 38.25553], [-122.04031, 38.25555]]]} | Open Access 1 | 17335 | Lee Bell Park | 21131 | 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 | 6.668 | Lee Bell Park | 0 | Local Park 2 | 4 | |
5729 | 5729 | 5728 | {"type": "Polygon", "coordinates": [[[-122.07467, 38.25809], [-122.07465, 38.25814], [-122.07455, 38.25817], [-122.07325, 38.25841], [-122.07321, 38.25823], [-122.07312, 38.25799], [-122.07303, 38.25758], [-122.07301, 38.25737], [-122.07294, 38.25719], [-122.07284, 38.25702], [-122.0728, 38.25697], [-122.07274, 38.25677], [-122.07369, 38.25642], [-122.07467, 38.25809]]]} | Open Access 1 | 2255 | Woodcreek Park | 27703 | 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 | 5.298 | Woodcreek Park | 0 | Local Park 2 | 4 | |
5736 | 5736 | 5735 | {"type": "Polygon", "coordinates": [[[-121.99862, 38.26741], [-121.99801, 38.26763], [-121.9976, 38.26714], [-121.99761, 38.26711], [-121.99757, 38.26706], [-121.99724, 38.26669], [-121.99708, 38.26654], [-121.99709, 38.26593], [-121.99855, 38.26597], [-121.99855, 38.26636], [-121.99851, 38.26651], [-121.99844, 38.26664], [-121.99843, 38.26685], [-121.99855, 38.26715], [-121.99862, 38.26741]]]} | Open Access 1 | 1658 | Tolenas Park | 26391 | 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 | 4.428 | Tolenas Park | 0 | Local Park 2 | 4 | |
5875 | 5875 | 5874 | {"type": "Polygon", "coordinates": [[[-122.04432, 38.29059], [-122.04427, 38.29062], [-122.04427, 38.29071], [-122.04431, 38.29077], [-122.04426, 38.29094], [-122.0442, 38.29104], [-122.04393, 38.29127], [-122.04357, 38.29146], [-122.04294, 38.29078], [-122.04292, 38.29074], [-122.04278, 38.29065], [-122.04269, 38.29046], [-122.04269, 38.29014], [-122.04274, 38.28977], [-122.04276, 38.28974], [-122.04304, 38.28972], [-122.04351, 38.28963], [-122.04354, 38.28966], [-122.04358, 38.28966], [-122.04374, 38.28982], [-122.04378, 38.2899], [-122.04384, 38.28997], [-122.04405, 38.29016], [-122.04414, 38.29022], [-122.04426, 38.29032], [-122.04432, 38.29046], [-122.04432, 38.29059]]]} | Open Access 1 | 260 | Rolling Hills Neighborhood Park | 24576 | 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 | 4.814 | Rolling Hills Neighborhood Park | 0 | Local Park 2 | 4 | |
6237 | 6237 | 6236 | {"type": "Polygon", "coordinates": [[[-122.03044, 38.28308], [-122.02968, 38.28308], [-122.02967, 38.28305], [-122.02961, 38.28299], [-122.02948, 38.28298], [-122.02941, 38.283], [-122.02935, 38.28306], [-122.0286, 38.28308], [-122.02827, 38.28307], [-122.02828, 38.28276], [-122.02826, 38.28269], [-122.02821, 38.28265], [-122.02821, 38.28258], [-122.02813, 38.28244], [-122.02814, 38.28231], [-122.02813, 38.28227], [-122.02807, 38.28222], [-122.02807, 38.2821], [-122.0281, 38.28207], [-122.0281, 38.28185], [-122.02845, 38.2818], [-122.03041, 38.28169], [-122.03044, 38.28308]]]} | Open Access 1 | 1301 | Sunrise Park | 26021 | 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 | 7.09 | Sunrise Park | 0 | Local Park 2 | 4 | |
6280 | 6280 | 6279 | {"type": "Polygon", "coordinates": [[[-122.01429, 38.26531], [-122.01427, 38.26661], [-122.01228, 38.26662], [-122.01227, 38.2653], [-122.01232, 38.26529], [-122.01429, 38.26531]]]} | Open Access 1 | 1402 | Tabor Park | 26162 | 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 | 6.355 | Tabor Park | 0 | Local Park 2 | 4 | |
7993 | 7993 | 7992 | {"type": "Polygon", "coordinates": [[[-122.14304, 38.19095], [-122.14273, 38.1911], [-122.14244, 38.19273], [-122.1424, 38.19282], [-122.14233, 38.19284], [-122.14197, 38.1927], [-122.14176, 38.19259], [-122.14156, 38.19252], [-122.14126, 38.19248], [-122.1408, 38.19248], [-122.14062, 38.19246], [-122.14051, 38.19243], [-122.14051, 38.19235], [-122.14104, 38.19081], [-122.14151, 38.19087], [-122.14213, 38.19078], [-122.14284, 38.19063], [-122.14304, 38.19095]]]} | Open Access 1 | 10988 | Ridgeview Park | 24359 | 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.277 | Ridgeview 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]);