units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where COUNTY = 26, DES_TP = 2 and MNG_AGENCY = 204
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME
MNG_AG_TYP 1
- City Agency 23
MNG_AGENCY 1
- Fairfield, City of · 23 ✖
DES_TP 1
- Local Park · 23 ✖
ACCESS_TYP 1
- Open Access 23
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
9435 | 9435 | 9434 | {"type": "Polygon", "coordinates": [[[-122.02401, 38.26071], [-122.02263, 38.26068], [-122.02261, 38.25964], [-122.02245, 38.25963], [-122.0225, 38.25902], [-122.02244, 38.25828], [-122.02395, 38.2583], [-122.02399, 38.25833], [-122.02401, 38.25835], [-122.02402, 38.2587], [-122.02401, 38.26071]]]} | Open Access 1 | 15775 | Dover Park | 18252 | 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.537 | Dover Park | 0 | Local Park 2 | 4 | |
9660 | 9660 | 9659 | {"type": "Polygon", "coordinates": [[[-122.02388, 38.29513], [-122.02362, 38.2953], [-122.02362, 38.29555], [-122.02331, 38.29552], [-122.02335, 38.29515], [-122.02326, 38.29484], [-122.0231, 38.29483], [-122.02304, 38.29462], [-122.02293, 38.29444], [-122.02249, 38.29358], [-122.02246, 38.29312], [-122.02247, 38.29306], [-122.02227, 38.29279], [-122.02192, 38.29225], [-122.02154, 38.29179], [-122.02121, 38.29157], [-122.021, 38.29134], [-122.0205, 38.29028], [-122.02049, 38.29011], [-122.02061, 38.29003], [-122.02054, 38.28981], [-122.02002, 38.28946], [-122.01995, 38.28943], [-122.01992, 38.28933], [-122.01984, 38.28924], [-122.01982, 38.28897], [-122.01997, 38.28868], [-122.02001, 38.28866], [-122.02033, 38.28825], [-122.02039, 38.28787], [-122.02034, 38.28758], [-122.01987, 38.28677], [-122.01974, 38.28601], [-122.01954, 38.2845], [-122.01947, 38.28367], [-122.01928, 38.28287], [-122.01919, 38.28224], [-122.01918, 38.28205], [-122.01916, 38.28194], [-122.01919, 38.28192], [-122.01917, 38.2816], [-122.0182, 38.27987], [-122.01798, 38.27986], [-122.01797, 38.27925], [-122.018, 38.27921], [-122.01804, 38.27689], [-122.01785, 38.27667], [-122.01756, 38.27643], [-122.01707, 38.27596], [-122.01666, 38.2755], [-122.01639, 38.27508], [-122.01619, 38.27458], [-122.01605, 38.27455], [-122.01582, 38.27387], [-122.01634, 38.27367], [-122.01643, 38.27391], [-122.01659, 38.27444], [-122.0168, 38.27489], [-122.01706, 38.27531], [-122.01743, 38.27575], [-122.01811, 38.27634], [-122.01829, 38.27653], [-122.01868, 38.2766], [-122.0187, 38.2779], [-122.01849, 38.27791], [-122.01845, 38.27976], [-122.01871, 38.27977], [-122.01934, 38.28085], [-122.01987, 38.28185], [-122.01988, 38.28205], [-122.01995, 38.28273], [-122.02019, 38.28378], [-122.02021, 38.28407], [-122.02027, 38.28442], [-122.02053, 38.28444], [-122.02033, 38.28482], [-122.02028, 38.28502], [-122.0205, 38.28658], [-122.02081, 38.28713], [-122.02089, 38.28721], [-122.02092, 38.28731], [-122.02097, 38.28734], [-122.0212, 38.28777], [-122.02126, 38.28816], [-122.02097, 38.28828], [-122.02087, 38.28896], [-122.02095, 38.28968], [-122.02109, 38.28993], [-122.02116, 38.28993], [-122.02169, 38.29075], [-122.02183, 38.29107], [-122.02204, 38.29138], [-122.02193, 38.29152], [-122.02227, 38.2917], [-122.02243, 38.29183], [-122.02257, 38.29203], [-122.0226, 38.29209], [-122.02268, 38.29216], [-122.02285, 38.29235], [-122.02306, 38.29317], [-122.02309, 38.29345], [-122.0232, 38.29373], [-122.02349, 38.29428], [-122.02371, 38.2945], [-122.02389, 38.29502], [-122.02388, 38.29513]]]} | Open Access 1 | 16289 | Fairfield Linear CreekPark | 18796 | 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.53 | Fairfield Linear CreekPark | 0 | Local Park 2 | 4 | |
10032 | 10032 | 10031 | {"type": "Polygon", "coordinates": [[[-122.01918, 38.28203], [-122.01814, 38.2823], [-122.01809, 38.28228], [-122.0181, 38.28202], [-122.01805, 38.28129], [-122.01747, 38.28112], [-122.01682, 38.28113], [-122.01684, 38.28165], [-122.01588, 38.28169], [-122.01584, 38.28172], [-122.01554, 38.28169], [-122.01539, 38.2817], [-122.01538, 38.28182], [-122.01519, 38.28189], [-122.01519, 38.28266], [-122.01483, 38.2827], [-122.01429, 38.28294], [-122.01361, 38.28337], [-122.01342, 38.28346], [-122.01337, 38.28345], [-122.01198, 38.282], [-122.0119, 38.28179], [-122.01189, 38.28002], [-122.01188, 38.28], [-122.0119, 38.27995], [-122.012, 38.27992], [-122.01329, 38.27994], [-122.01449, 38.27992], [-122.01753, 38.27994], [-122.01823, 38.27993], [-122.01827, 38.28012], [-122.01863, 38.28069], [-122.01914, 38.28161], [-122.01916, 38.2818], [-122.01915, 38.28196], [-122.01918, 38.28203]]]} | Open Access 1 | 17324 | Laurel Creek Park | 21091 | 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 | 37.589 | Laurel Creek Park | 0 | Local Park 2 | 4 | |
10111 | 10111 | 10110 | {"type": "Polygon", "coordinates": [[[-122.06362, 38.26685], [-122.06308, 38.26853], [-122.06218, 38.26864], [-122.06218, 38.26842], [-122.06216, 38.26832], [-122.06217, 38.26688], [-122.06212, 38.26682], [-122.06224, 38.26646], [-122.06362, 38.26685]]]} | Open Access 1 | 17546 | Mankas Park | 21750 | 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.6 | Mankas Park | 0 | Local Park 2 | 4 | |
10207 | 10207 | 10206 | {"type": "Polygon", "coordinates": [[[-122.00251, 38.2696], [-122.00233, 38.26963], [-122.0022, 38.26968], [-122.00115, 38.27042], [-122.001, 38.27046], [-122.00064, 38.27045], [-122.00079, 38.26977], [-122.00083, 38.26941], [-122.00093, 38.269], [-122.00111, 38.26902], [-122.0015, 38.26897], [-122.0016, 38.26894], [-122.00174, 38.26885], [-122.00196, 38.26874], [-122.0021, 38.26877], [-122.00234, 38.26902], [-122.00237, 38.26924], [-122.00236, 38.26929], [-122.0023, 38.26936], [-122.00231, 38.26939], [-122.0023, 38.26945], [-122.00243, 38.2695], [-122.00249, 38.2695], [-122.00251, 38.2696]]]} | Open Access 1 | 17842 | Meadow Glen Park | 22071 | 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.48 | Meadow Glen Park | 0 | Local Park 2 | 4 | |
11328 | 11328 | 11327 | {"type": "Polygon", "coordinates": [[[-122.09278, 38.24037], [-122.09046, 38.24124], [-122.08872, 38.24205], [-122.08805, 38.2428], [-122.08698, 38.2436], [-122.08478, 38.2439], [-122.0838, 38.24422], [-122.08075, 38.2456], [-122.07742, 38.24696], [-122.07497, 38.24809], [-122.07332, 38.24867], [-122.07148, 38.24944], [-122.07106, 38.24972], [-122.07129, 38.25019], [-122.06756, 38.25175], [-122.06023, 38.25488], [-122.05483, 38.25709], [-122.05473, 38.25736], [-122.05404, 38.25741], [-122.054, 38.25793], [-122.05237, 38.25796], [-122.04974, 38.25925], [-122.04975, 38.25926], [-122.04981, 38.25928], [-122.04553, 38.26116], [-122.04037, 38.26341], [-122.04037, 38.26325], [-122.03385, 38.26602], [-122.01603, 38.27379], [-122.01575, 38.27296], [-122.01683, 38.2726], [-122.0181, 38.27259], [-122.02505, 38.26952], [-122.03921, 38.26337], [-122.04037, 38.26285], [-122.04037, 38.26281], [-122.04059, 38.26279], [-122.04235, 38.26205], [-122.04513, 38.26077], [-122.04833, 38.25941], [-122.04836, 38.25935], [-122.04975, 38.25879], [-122.04971, 38.25837], [-122.05143, 38.258], [-122.05152, 38.25767], [-122.05277, 38.25744], [-122.0536, 38.25711], [-122.0536, 38.2571], [-122.05354, 38.25701], [-122.0549, 38.25656], [-122.05864, 38.2549], [-122.06656, 38.25147], [-122.06856, 38.25067], [-122.07124, 38.24939], [-122.07182, 38.24906], [-122.07202, 38.24883], [-122.07586, 38.24745], [-122.08486, 38.24356], [-122.08627, 38.24342], [-122.08749, 38.24312], [-122.08817, 38.24249], [-122.0884, 38.24204], [-122.09237, 38.24032], [-122.09278, 38.24037]]]} | Open Access 1 | 22049 | Fairfield Linear Park | 18797 | 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 | 79.782 | Fairfield Linear Park | 0 | Local Park 2 | 4 | |
12499 | 12499 | 12498 | {"type": "Polygon", "coordinates": [[[-122.05196, 38.28157], [-122.05189, 38.28173], [-122.05184, 38.28197], [-122.0518, 38.28203], [-122.05173, 38.28215], [-122.05151, 38.28236], [-122.05144, 38.28239], [-122.05123, 38.2821], [-122.05113, 38.28209], [-122.05107, 38.28211], [-122.05101, 38.2821], [-122.05098, 38.28206], [-122.05103, 38.2819], [-122.05102, 38.28184], [-122.05096, 38.28181], [-122.05092, 38.28172], [-122.05091, 38.28165], [-122.05092, 38.2816], [-122.05102, 38.28151], [-122.05113, 38.28151], [-122.05134, 38.28146], [-122.05135, 38.28138], [-122.05135, 38.28127], [-122.0514, 38.28116], [-122.05148, 38.28112], [-122.05159, 38.28113], [-122.05169, 38.28118], [-122.05178, 38.28128], [-122.05196, 38.28157]]]} | Open Access 1 | 28315 | Meadow Glen Park | 22071 | 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 | 1.894 | Meadow Glen 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]);