units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where ACCESS_TYP = 3, COUNTY = 26 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, YR_EST
DES_TP 5
- Local Recreation Area 6
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 3
MNG_AG_TYP 1
- City Agency · 10 ✖
ACCESS_TYP 1
- No Public Access · 10 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
6218 | 6218 | 6217 | {"type": "Polygon", "coordinates": [[[-122.22564, 38.15293], [-122.22516, 38.15364], [-122.22485, 38.15405], [-122.22462, 38.15394], [-122.22416, 38.15388], [-122.22394, 38.15359], [-122.2239, 38.15324], [-122.22435, 38.15302], [-122.22465, 38.15275], [-122.22491, 38.15266], [-122.22559, 38.15271], [-122.22564, 38.15293]]]} | No Public Access 3 | 1275 | Summit Reservoir | 25968 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 3.617 | Summit Reservoir | 0 | Local Recreation Area 3 | 4 | |
6300 | 6300 | 6299 | {"type": "Polygon", "coordinates": [[[-122.00948, 38.34308], [-122.00872, 38.34467], [-122.00701, 38.34922], [-122.00683, 38.34903], [-122.00699, 38.34894], [-122.00699, 38.34892], [-122.00674, 38.34867], [-122.00658, 38.34877], [-122.00653, 38.34873], [-122.00669, 38.34811], [-122.00525, 38.34739], [-122.00384, 38.34625], [-122.00365, 38.34649], [-122.00372, 38.3469], [-122.00364, 38.34691], [-122.00347, 38.34659], [-122.00335, 38.3466], [-122.00333, 38.34675], [-122.00313, 38.34708], [-122.00328, 38.34718], [-122.0034, 38.34738], [-122.00345, 38.34758], [-122.00328, 38.34776], [-122.00331, 38.34791], [-122.00325, 38.34817], [-122.00307, 38.34857], [-122.00277, 38.34889], [-122.00279, 38.3491], [-122.00256, 38.34887], [-122.00265, 38.34871], [-122.00284, 38.34855], [-122.00297, 38.34837], [-122.00309, 38.34797], [-122.00303, 38.34764], [-122.00318, 38.34745], [-122.00312, 38.34727], [-122.00301, 38.34719], [-122.00296, 38.34712], [-122.00307, 38.3466], [-122.00299, 38.34644], [-122.00268, 38.34637], [-122.00253, 38.3462], [-122.00226, 38.34601], [-122.00198, 38.34544], [-122.00181, 38.34515], [-122.00175, 38.34498], [-122.00215, 38.34482], [-122.00702, 38.34317], [-122.00825, 38.343], [-122.00928, 38.34317], [-122.00948, 38.34308]]]} | No Public Access 3 | 1417 | Alamo Terrace Open Space | 15323 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 55.193 | Alamo Terrace OS | 2000 | Local Recreation Area 3 | 4 | |
9676 | 9676 | 9675 | {"type": "Polygon", "coordinates": [[[-122.19255, 38.29554], [-122.19255, 38.29564], [-122.19104, 38.2956], [-122.19096, 38.29567], [-122.19099, 38.29593], [-122.19087, 38.29605], [-122.19071, 38.29609], [-122.19073, 38.29628], [-122.19076, 38.29637], [-122.19081, 38.29641], [-122.19091, 38.29658], [-122.19096, 38.2967], [-122.19101, 38.29691], [-122.19099, 38.2971], [-122.19094, 38.29711], [-122.19055, 38.2969], [-122.1903, 38.29687], [-122.19006, 38.29702], [-122.18984, 38.29702], [-122.18977, 38.29714], [-122.18971, 38.29735], [-122.18961, 38.29751], [-122.18938, 38.29755], [-122.1893, 38.29748], [-122.18904, 38.29688], [-122.18901, 38.29648], [-122.18903, 38.29625], [-122.18912, 38.29602], [-122.1893, 38.2958], [-122.18933, 38.29555], [-122.1893, 38.29542], [-122.18934, 38.29521], [-122.18948, 38.29491], [-122.18929, 38.29469], [-122.18907, 38.2945], [-122.18888, 38.29431], [-122.18864, 38.29413], [-122.18847, 38.29387], [-122.18849, 38.29365], [-122.18872, 38.29353], [-122.18872, 38.29346], [-122.1887, 38.29338], [-122.18863, 38.2933], [-122.18853, 38.29308], [-122.18853, 38.29294], [-122.18849, 38.29274], [-122.18821, 38.29253], [-122.18811, 38.29231], [-122.18803, 38.29218], [-122.18796, 38.29208], [-122.18787, 38.292], [-122.18782, 38.29186], [-122.18748, 38.29129], [-122.18714, 38.291], [-122.18685, 38.29066], [-122.18678, 38.29053], [-122.1867, 38.29021], [-122.18658, 38.29004], [-122.18648, 38.28997], [-122.18641, 38.28989], [-122.18645, 38.28981], [-122.18655, 38.28976], [-122.18705, 38.28964], [-122.18752, 38.28944], [-122.18768, 38.28946], [-122.1878, 38.28947], [-122.18809, 38.28932], [-122.18818, 38.2892], [-122.18818, 38.28883], [-122.18812, 38.28842], [-122.18804, 38.2883], [-122.188, 38.28816], [-122.18807, 38.28803], [-122.18825, 38.28789], [-122.18833, 38.28793], [-122.18837, 38.28803], [-122.18849, 38.28815], [-122.18881, 38.28836], [-122.18891, 38.28859], [-122.18896, 38.2889], [-122.18908, 38.28918], [-122.18916, 38.28937], [-122.18925, 38.28941], [-122.18932, 38.2895], [-122.18937, 38.28963], [-122.18949, 38.28972], [-122.18966, 38.28974], [-122.18976, 38.28973], [-122.1898, 38.28974], [-122.18985, 38.28979], [-122.18993, 38.29004], [-122.19002, 38.29014], [-122.19039, 38.29045], [-122.19046, 38.29056], [-122.19058, 38.29091], [-122.19071, 38.29101], [-122.19077, 38.29098], [-122.19089, 38.29107], [-122.19089, 38.29128], [-122.19105, 38.29154], [-122.19119, 38.2918], [-122.19131, 38.29193], [-122.19126, 38.2921], [-122.19112, 38.29228], [-122.19104, 38.29246], [-122.19092, 38.29262], [-122.1909, 38.29274], [-122.19094, 38.29299], [-122.19107, 38.29329], [-122.19114, 38.29353], [-122.19093, 38.29384], [-122.19096, 38.29416], [-122.19109, 38.29435], [-122.19133, 38.29438], [-122.1914, 38.29445], [-122.19144, 38.29453], [-122.19142, 38.29462], [-122.19128, 38.29475], [-122.19128, 38.29483], [-122.19134, 38.29495], [-122.19155, 38.29515], [-122.19169, 38.29521], [-122.19208, 38.29529], [-122.19221, 38.29528], [-122.19236, 38.29531], [-122.19248, 38.29542], [-122.19255, 38.29554]]]} | No Public Access 3 | 16321 | Lake Frey | 20892 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 51.566 | Lake Frey | 0 | None 829 | ||
9677 | 9677 | 9676 | {"type": "Polygon", "coordinates": [[[-122.19813, 38.30518], [-122.19811, 38.30572], [-122.19746, 38.30695], [-122.19709, 38.30803], [-122.19629, 38.30861], [-122.19561, 38.30937], [-122.19533, 38.31033], [-122.19566, 38.3109], [-122.1948, 38.3118], [-122.19463, 38.31263], [-122.19472, 38.31293], [-122.19525, 38.31315], [-122.19566, 38.31317], [-122.19627, 38.31316], [-122.19668, 38.3129], [-122.19688, 38.3129], [-122.1966, 38.31346], [-122.1966, 38.31374], [-122.19682, 38.31398], [-122.1972, 38.3145], [-122.19717, 38.31471], [-122.19693, 38.31471], [-122.19675, 38.3146], [-122.19652, 38.31422], [-122.19619, 38.31412], [-122.19578, 38.31424], [-122.1956, 38.31404], [-122.19513, 38.31383], [-122.19461, 38.31393], [-122.19445, 38.31407], [-122.19414, 38.31428], [-122.19359, 38.31458], [-122.19269, 38.31501], [-122.19303, 38.31447], [-122.19326, 38.31396], [-122.19336, 38.31344], [-122.19309, 38.31321], [-122.19269, 38.31296], [-122.19231, 38.31283], [-122.19215, 38.31267], [-122.19211, 38.3124], [-122.19187, 38.31187], [-122.1914, 38.31131], [-122.19127, 38.31103], [-122.1914, 38.31078], [-122.19168, 38.31061], [-122.19199, 38.3105], [-122.19197, 38.31027], [-122.19184, 38.31022], [-122.19177, 38.31007], [-122.19186, 38.31], [-122.19236, 38.31018], [-122.19278, 38.31036], [-122.1931, 38.31035], [-122.19321, 38.31018], [-122.19304, 38.3098], [-122.19232, 38.3091], [-122.19248, 38.30887], [-122.19247, 38.30854], [-122.19331, 38.30796], [-122.19392, 38.30748], [-122.19467, 38.30713], [-122.19537, 38.30627], [-122.19554, 38.30593], [-122.19592, 38.30586], [-122.19655, 38.30547], [-122.19708, 38.30535], [-122.1975, 38.30511], [-122.19785, 38.30474], [-122.19813, 38.30518]]]} | No Public Access 3 | 16333 | Lake Madigan | 20951 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 66.97 | Lake Madigan | None 830 | |||
9683 | 9683 | 9682 | {"type": "Polygon", "coordinates": [[[-122.20614, 38.31457], [-122.20607, 38.3157], [-122.1894, 38.31588], [-122.18952, 38.3136], [-122.1897, 38.30526], [-122.18507, 38.30526], [-122.18515, 38.29837], [-122.18065, 38.29829], [-122.18076, 38.28784], [-122.18075, 38.28783], [-122.18022, 38.28841], [-122.1764, 38.27648], [-122.17639, 38.27648], [-122.17466, 38.27733], [-122.17228, 38.27276], [-122.17131, 38.2713], [-122.17033, 38.2697], [-122.1693, 38.26822], [-122.16818, 38.26618], [-122.17132, 38.26615], [-122.17405, 38.2673], [-122.17621, 38.26806], [-122.17787, 38.26825], [-122.18125, 38.25243], [-122.19329, 38.25234], [-122.19314, 38.25272], [-122.19297, 38.25544], [-122.19237, 38.25612], [-122.19237, 38.25613], [-122.19566, 38.2584], [-122.2031, 38.25944], [-122.19399, 38.2709], [-122.19304, 38.27115], [-122.18835, 38.2714], [-122.19035, 38.27574], [-122.19019, 38.2872], [-122.19947, 38.28716], [-122.19952, 38.28719], [-122.19951, 38.2872], [-122.19954, 38.28728], [-122.1995, 38.28756], [-122.19954, 38.28779], [-122.19969, 38.28801], [-122.19987, 38.28812], [-122.20004, 38.28827], [-122.20021, 38.28859], [-122.20032, 38.28872], [-122.20046, 38.28883], [-122.20082, 38.28903], [-122.20122, 38.28939], [-122.20133, 38.28951], [-122.20136, 38.28966], [-122.20138, 38.28991], [-122.20139, 38.2905], [-122.19943, 38.29049], [-122.19965, 38.2982], [-122.18994, 38.29826], [-122.18979, 38.3017], [-122.1898, 38.30171], [-122.19097, 38.3017], [-122.19902, 38.30174], [-122.20022, 38.30208], [-122.20051, 38.30238], [-122.20065, 38.30285], [-122.20072, 38.30294], [-122.20245, 38.30413], [-122.20259, 38.3051], [-122.20185, 38.30668], [-122.20117, 38.30779], [-122.20115, 38.30785], [-122.20116, 38.30817], [-122.20129, 38.30858], [-122.2015, 38.30881], [-122.20164, 38.309], [-122.2019, 38.30924], [-122.2025, 38.30949], [-122.2027, 38.30951], [-122.20289, 38.3096], [-122.20312, 38.30968], [-122.20338, 38.30972], [-122.2036, 38.30986], [-122.204, 38.3102], [-122.20454, 38.31106], [-122.20499, 38.31274], [-122.20614, 38.31457]], [[-122.1976, 38.305], [-122.1975, 38.30511], [-122.19707, 38.30535], [-122.19655, 38.30547], [-122.19592, 38.30586], [-122.19554, 38.30593], [-122.19537, 38.30627], [-122.19467, 38.30713], [-122.19392, 38.30748], [-122.19331, 38.30796], [-122.19247, 38.30854], [-122.19248, 38.30887], [-122.19233, 38.3091], [-122.19304, 38.3098], [-122.19321, 38.31017], [-122.1931, 38.31035], [-122.19278, 38.31036], [-122.19236, 38.31018], [-122.19186, 38.31001], [-122.19178, 38.31008], [-122.19184, 38.31022], [-122.19197, 38.31027], [-122.19199, 38.3105], [-122.19168, 38.31061], [-122.19141, 38.31078], [-122.19127, 38.31103], [-122.1914, 38.31132], [-122.19187, 38.31187], [-122.19211, 38.3124], [-122.19215, 38.31267], [-122.19231, 38.31283], [-122.19269, 38.31296], [-122.19309, 38.31321], [-122.19336, 38.31344], [-122.19326, 38.31395], [-122.19303, 38.31447], [-122.19271, 38.31499], [-122.19271, 38.315], [-122.19359, 38.31458], [-122.19414, 38.31428], [-122.19445, 38.31407], [-122.19461, 38.31393], [-122.19513, 38.31383], [-122.1956, 38.31404], [-122.19578, 38.31424], [-122.19619, 38.31412], [-122.19652, 38.31423], [-122.19675, 38.3146], [-122.19693, 38.31471], [-122.19717, 38.3147], [-122.1972, 38.31449], [-122.19682, 38.31398], [-122.1966, 38.31375], [-122.1966, 38.31346], [-122.19687, 38.3129], [-122.19667, 38.3129], [-122.19627, 38.31316], [-122.19566, 38.31317], [-122.19525, 38.31315], [-122.19472, 38.31293], [-122.19463, 38.31263], [-122.1948, 38.3118], [-122.19566, 38.3109], [-122.19533, 38.31033], [-122.19561, 38.30937], [-122.19629, 38.30861], [-122.19709, 38.30803], [-122.19746, 38.30695], [-122.19811, 38.30572], [-122.19813, 38.30518], [-122.19785, 38.30475], [-122.19784, 38.30475], [-122.1976, 38.305]], [[-122.19187, 38.29525], [-122.19169, 38.29521], [-122.19155, 38.29515], [-122.19135, 38.29495], [-122.19128, 38.29482], [-122.19128, 38.29474], [-122.19142, 38.29462], [-122.19144, 38.29453], [-122.1914, 38.29445], [-122.19133, 38.29438], [-122.19109, 38.29435], [-122.19096, 38.29416], [-122.19093, 38.29384], [-122.19114, 38.29353], [-122.19107, 38.29329], [-122.19094, 38.29299], [-122.1909, 38.29274], [-122.19092, 38.29262], [-122.19104, 38.29246], [-122.19112, 38.29228], [-122.19126, 38.2921], [-122.19131, 38.29193], [-122.19119, 38.2918], [-122.19105, 38.29154], [-122.19089, 38.29128], [-122.19089, 38.29107], [-122.19077, 38.29099], [-122.19072, 38.29101], [-122.19058, 38.29091], [-122.19046, 38.29056], [-122.19039, 38.29045], [-122.19002, 38.29014], [-122.18993, 38.29004], [-122.18985, 38.28979], [-122.1898, 38.28974], [-122.18976, 38.28973], [-122.18966, 38.28974], [-122.18949, 38.28972], [-122.18937, 38.28963], [-122.18932, 38.28951], [-122.18925, 38.28941], [-122.18916, 38.28937], [-122.18908, 38.28918], [-122.18896, 38.2889], [-122.18891, 38.28859], [-122.18881, 38.28836], [-122.18849, 38.28815], [-122.18837, 38.28803], [-122.18833, 38.28793], [-122.18824, 38.28789], [-122.18807, 38.28803], [-122.188, 38.28816], [-122.18804, 38.2883], [-122.18812, 38.28842], [-122.18818, 38.28883], [-122.18818, 38.2892], [-122.18809, 38.28932], [-122.1878, 38.28947], [-122.18768, 38.28946], [-122.18752, 38.28944], [-122.18705, 38.28964], [-122.18655, 38.28976], [-122.18645, 38.28981], [-122.18641, 38.28989], [-122.18648, 38.28997], [-122.18658, 38.29004], [-122.1867, 38.29021], [-122.18678, 38.29053], [-122.18685, 38.29066], [-122.18714, 38.291], [-122.18748, 38.29129], [-122.18782, 38.29186], [-122.18787, 38.292], [-122.18796, 38.29208], [-122.18803, 38.29218], [-122.18811, 38.29231], [-122.18821, 38.29253], [-122.18849, 38.29274], [-122.18853, 38.29294], [-122.18853, 38.29308], [-122.18863, 38.29329], [-122.1887, 38.29338], [-122.18872, 38.29346], [-122.18872, 38.29353], [-122.18849, 38.29365], [-122.18847, 38.29387], [-122.18864, 38.29413], [-122.18888, 38.29431], [-122.18907, 38.2945], [-122.18929, 38.29469], [-122.18948, 38.29491], [-122.18934, 38.29521], [-122.1893, 38.29542], [-122.18933, 38.29555], [-122.1893, 38.2958], [-122.18912, 38.29602], [-122.18903, 38.29625], [-122.18901, 38.29648], [-122.18904, 38.29688], [-122.1893, 38.29748], [-122.18938, 38.29755], [-122.18961, 38.29751], [-122.18971, 38.29735], [-122.18977, 38.29714], [-122.18984, 38.29702], [-122.19006, 38.29702], [-122.19031, 38.29687], [-122.19055, 38.2969], [-122.19094, 38.29711], [-122.19099, 38.2971], [-122.19101, 38.29691], [-122.19096, 38.2967], [-122.19091, 38.29658], [-122.19081, 38.29641], [-122.19076, 38.29637], [-122.19073, 38.29628], [-122.19071, 38.29609], [-122.19087, 38.29605], [-122.19099, 38.29593], [-122.19096, 38.29567], [-122.19105, 38.2956], [-122.19255, 38.29563], [-122.19255, 38.29554], [-122.19248, 38.29542], [-122.19236, 38.29531], [-122.19221, 38.29528], [-122.19208, 38.29529], [-122.19187, 38.29525]]]} | No Public Access 3 | 16322 | Vallejo Lakes | 26780 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 2325.531 | Vallejo Lakes | 0 | None 834 | ||
10346 | 10346 | 10345 | {"type": "Polygon", "coordinates": [[[-122.19567, 38.13207], [-122.19607, 38.1323], [-122.19607, 38.1323], [-122.1969, 38.13267], [-122.19794, 38.13308], [-122.19855, 38.13337], [-122.19901, 38.13361], [-122.19996, 38.1342], [-122.20165, 38.13531], [-122.20208, 38.13557], [-122.20272, 38.13596], [-122.20326, 38.13619], [-122.20352, 38.13629], [-122.20489, 38.13665], [-122.20612, 38.13692], [-122.20724, 38.13706], [-122.20547, 38.13799], [-122.20543, 38.13823], [-122.20762, 38.13847], [-122.20991, 38.13874], [-122.20972, 38.13981], [-122.20973, 38.13982], [-122.21088, 38.13993], [-122.21174, 38.14005], [-122.21298, 38.14019], [-122.2131, 38.13937], [-122.21532, 38.13962], [-122.21525, 38.14005], [-122.21545, 38.1406], [-122.21382, 38.14057], [-122.21368, 38.14204], [-122.21291, 38.14191], [-122.21264, 38.14192], [-122.21255, 38.14225], [-122.21271, 38.14272], [-122.2134, 38.14303], [-122.21288, 38.14606], [-122.20837, 38.14896], [-122.20599, 38.14589], [-122.19995, 38.14373], [-122.19935, 38.14304], [-122.19853, 38.14245], [-122.19668, 38.14098], [-122.19475, 38.13958], [-122.19412, 38.13869], [-122.19448, 38.13723], [-122.19423, 38.13573], [-122.19408, 38.13498], [-122.19238, 38.13177], [-122.19208, 38.13161], [-122.19179, 38.13148], [-122.19139, 38.13124], [-122.19095, 38.13094], [-122.19068, 38.13063], [-122.19033, 38.13018], [-122.18977, 38.1297], [-122.18938, 38.12931], [-122.18901, 38.1289], [-122.18861, 38.12857], [-122.18982, 38.12792], [-122.19073, 38.12752], [-122.19077, 38.12764], [-122.19086, 38.12773], [-122.19143, 38.12808], [-122.19189, 38.12829], [-122.192, 38.12829], [-122.19217, 38.12822], [-122.19363, 38.13011], [-122.19405, 38.13058], [-122.19453, 38.13106], [-122.19501, 38.13153], [-122.19554, 38.132], [-122.19567, 38.13207]]]} | No Public Access 3 | 18255 | Northgate | 22870 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 435.488 | Northgate | 1999 | None 905 | ||
11334 | 11334 | 11333 | {"type": "Polygon", "coordinates": [[[-122.03688, 38.31196], [-122.03629, 38.31305], [-122.03366, 38.31645], [-122.03216, 38.31563], [-122.03232, 38.31462], [-122.03293, 38.31293], [-122.03356, 38.30987], [-122.03451, 38.30962], [-122.03456, 38.30784], [-122.03685, 38.3093], [-122.03577, 38.3104], [-122.03688, 38.31196]]]} | No Public Access 3 | 22071 | Lagoon Valley Gateway Open Space | 30788 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 50.705 | Lagoon Valley Gateway OS | 0 | Local Recreation Area 3 | 4 | |
15992 | 15992 | 15991 | {"type": "Polygon", "coordinates": [[[-121.9799, 38.37625], [-121.97978, 38.37626], [-121.97969, 38.37632], [-121.97967, 38.37636], [-121.97967, 38.37641], [-121.97972, 38.3765], [-121.97906, 38.37666], [-121.97898, 38.37672], [-121.97889, 38.3767], [-121.97882, 38.3767], [-121.97877, 38.37672], [-121.97872, 38.37667], [-121.97795, 38.37669], [-121.97733, 38.37393], [-121.97713, 38.37363], [-121.97701, 38.37346], [-121.977, 38.37339], [-121.97718, 38.37325], [-121.97737, 38.37299], [-121.97738, 38.37294], [-121.9774, 38.3729], [-121.97744, 38.37276], [-121.97745, 38.37234], [-121.9775, 38.3723], [-121.97831, 38.37233], [-121.97891, 38.37241], [-121.97913, 38.37242], [-121.97914, 38.37278], [-121.97928, 38.37297], [-121.97928, 38.37308], [-121.9793, 38.37312], [-121.97931, 38.37328], [-121.97934, 38.37343], [-121.97935, 38.37375], [-121.97943, 38.3738], [-121.97942, 38.37399], [-121.97936, 38.37423], [-121.97943, 38.37455], [-121.97952, 38.37459], [-121.9795, 38.37467], [-121.97953, 38.37474], [-121.97948, 38.37477], [-121.97954, 38.37506], [-121.97976, 38.37535], [-121.97972, 38.3754], [-121.97972, 38.37545], [-121.97975, 38.37551], [-121.97981, 38.37556], [-121.9798, 38.37594], [-121.9799, 38.37625]]]} | No Public Access 3 | 1305 | Sunrise Woodcrest Open Space | 26039 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 20.516 | Sunrise Woodcrest OS | 0 | Local Recreation Area 3 | 4 | |
16141 | 16141 | 16140 | {"type": "MultiPolygon", "coordinates": [[[[-122.03212, 38.31331], [-122.03196, 38.3141], [-122.0313, 38.31544], [-122.03096, 38.31544], [-122.03056, 38.31614], [-122.0301, 38.31688], [-122.03005, 38.31707], [-122.03027, 38.31735], [-122.02952, 38.31821], [-122.02738, 38.32038], [-122.02634, 38.32147], [-122.02566, 38.32227], [-122.02487, 38.32309], [-122.0247, 38.32296], [-122.02481, 38.32271], [-122.02483, 38.32231], [-122.02483, 38.32091], [-122.02485, 38.32029], [-122.0247, 38.32019], [-122.02475, 38.31971], [-122.0241, 38.31956], [-122.0236, 38.31937], [-122.02353, 38.3194], [-122.02348, 38.31936], [-122.02274, 38.31931], [-122.02228, 38.31923], [-122.02192, 38.31888], [-122.0215, 38.31869], [-122.02116, 38.31849], [-122.02102, 38.31823], [-122.02092, 38.31819], [-122.02096, 38.31815], [-122.02096, 38.31813], [-122.02055, 38.31799], [-122.01993, 38.31769], [-122.01946, 38.3173], [-122.01902, 38.31716], [-122.01847, 38.31693], [-122.018, 38.31679], [-122.01748, 38.3165], [-122.01657, 38.31619], [-122.0151, 38.3158], [-122.01478, 38.31549], [-122.01664, 38.31423], [-122.01662, 38.31401], [-122.01662, 38.31386], [-122.01666, 38.31363], [-122.0167, 38.3135], [-122.01679, 38.3133], [-122.01718, 38.31269], [-122.01719, 38.31264], [-122.01713, 38.31259], [-122.01662, 38.31255], [-122.01647, 38.31252], [-122.01631, 38.31243], [-122.01624, 38.31236], [-122.01617, 38.31227], [-122.01613, 38.31219], [-122.01612, 38.31209], [-122.01615, 38.31194], [-122.01619, 38.31185], [-122.01642, 38.31155], [-122.01651, 38.31136], [-122.01649, 38.31128], [-122.01645, 38.31124], [-122.0164, 38.31121], [-122.01614, 38.31119], [-122.01585, 38.3112], [-122.01556, 38.31124], [-122.01526, 38.31132], [-122.01513, 38.3114], [-122.01506, 38.31147], [-122.01501, 38.31158], [-122.015, 38.31175], [-122.01495, 38.31183], [-122.01488, 38.31189], [-122.01477, 38.31193], [-122.01466, 38.31195], [-122.01453, 38.31193], [-122.01442, 38.31187], [-122.01427, 38.31127], [-122.01425, 38.31107], [-122.01427, 38.31084], [-122.01435, 38.31059], [-122.01478, 38.30969], [-122.01478, 38.30965], [-122.01477, 38.3096], [-122.01473, 38.30955], [-122.0145, 38.30941], [-122.01443, 38.30938], [-122.01382, 38.30946], [-122.01352, 38.30948], [-122.01333, 38.30946], [-122.01311, 38.3094], [-122.01293, 38.30928], [-122.01278, 38.30911], [-122.01274, 38.30903], [-122.0127, 38.30886], [-122.01269, 38.30872], [-122.01858, 38.30883], [-122.01866, 38.30895], [-122.01898, 38.30911], [-122.02115, 38.30989], [-122.02458, 38.31092], [-122.0254, 38.31237], [-122.02696, 38.31291], [-122.02885, 38.31231], [-122.02898, 38.31232], [-122.03212, 38.31331]], [[-122.02474, 38.31963], [-122.02475, 38.31964], [-122.02476, 38.31963], [-122.02475, 38.31962], [-122.02474, 38.31963]]], [[[-122.03081, 38.3203], [-122.03054, 38.32057], [-122.03033, 38.32076], [-122.02936, 38.32075], [-122.02948, 38.32125], [-122.02987, 38.32264], [-122.02992, 38.32293], [-122.03005, 38.3234], [-122.03005, 38.32493], [-122.02932, 38.325], [-122.02804, 38.32553], [-122.02611, 38.32602], [-122.02533, 38.32521], [-122.02522, 38.325], [-122.02514, 38.32475], [-122.02511, 38.32448], [-122.02514, 38.32422], [-122.02521, 38.32396], [-122.02543, 38.32374], [-122.0258, 38.32326], [-122.02614, 38.32278], [-122.0283, 38.32044], [-122.02862, 38.32014], [-122.03003, 38.31861], [-122.03081, 38.3203]]]]} | No Public Access 3 | 17793 | Lagoon Valley Open Space | 30790 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 346.712 | Lagoon Valley OS | 0 | Local Recreation Area 3 | 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]);