units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 3, AGNCY_LEV = 2 and MNG_AGENCY = 524
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, YR_EST
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 6397 | 6397 | 6396 | {"type": "Polygon", "coordinates": [[[-122.11544, 38.38481], [-122.11085, 38.38485], [-122.11091, 38.38267], [-122.11093, 38.38014], [-122.111, 38.37767], [-122.09259, 38.37779], [-122.09265, 38.37418], [-122.09308, 38.37371], [-122.09356, 38.37334], [-122.0949, 38.37217], [-122.09681, 38.3721], [-122.0983, 38.37151], [-122.09981, 38.37125], [-122.10093, 38.37053], [-122.10295, 38.36978], [-122.10869, 38.36903], [-122.10856, 38.36776], [-122.10988, 38.36786], [-122.11024, 38.36696], [-122.11195, 38.3669], [-122.11229, 38.36599], [-122.11168, 38.36504], [-122.11442, 38.36431], [-122.11479, 38.36369], [-122.11499, 38.36371], [-122.11581, 38.36318], [-122.11586, 38.36198], [-122.11638, 38.36158], [-122.11721, 38.36118], [-122.11751, 38.36079], [-122.11748, 38.35989], [-122.11809, 38.35895], [-122.11957, 38.35813], [-122.11997, 38.35753], [-122.12053, 38.35653], [-122.12122, 38.35702], [-122.12167, 38.35723], [-122.12188, 38.35576], [-122.12341, 38.35574], [-122.12355, 38.35555], [-122.12382, 38.35544], [-122.1243, 38.35538], [-122.12565, 38.35533], [-122.1258, 38.35478], [-122.12584, 38.35485], [-122.12745, 38.35453], [-122.12788, 38.35542], [-122.12782, 38.35783], [-122.1305, 38.35809], [-122.13208, 38.35914], [-122.13312, 38.35871], [-122.135, 38.35888], [-122.13607, 38.35969], [-122.13737, 38.36011], [-122.13806, 38.36013], [-122.14092, 38.36156], [-122.14146, 38.36186], [-122.143, 38.3619], [-122.14372, 38.36113], [-122.14487, 38.36143], [-122.14617, 38.36078], [-122.147, 38.36125], [-122.14761, 38.36115], [-122.14965, 38.36007], [-122.15036, 38.35989], [-122.15096, 38.35888], [-122.1527, 38.3596], [-122.15299, 38.36046], [-122.15403, 38.36153], [-122.15406, 38.36222], [-122.15549, 38.36355], [-122.15126, 38.36401], [-122.14689, 38.36435], [-122.14511, 38.36421], [-122.14503, 38.36891], [-122.14499, 38.37022], [-122.14326, 38.37027], [-122.14325, 38.37093], [-122.1428, 38.37066], [-122.1427, 38.37054], [-122.14273, 38.37046], [-122.144, 38.36923], [-122.14424, 38.36897], [-122.14443, 38.36844], [-122.14445, 38.3679], [-122.14446, 38.36562], [-122.1444, 38.36532], [-122.14435, 38.36515], [-122.14429, 38.36501], [-122.14417, 38.36482], [-122.14391, 38.36448], [-122.14354, 38.36412], [-122.14318, 38.36382], [-122.14297, 38.36374], [-122.14284, 38.36373], [-122.14244, 38.36385], [-122.14209, 38.36392], [-122.14187, 38.36391], [-122.14154, 38.36376], [-122.14118, 38.36349], [-122.14045, 38.36313], [-122.13997, 38.36301], [-122.13964, 38.36301], [-122.13927, 38.36294], [-122.13906, 38.3628], [-122.13852, 38.36235], [-122.13817, 38.36222], [-122.13659, 38.36209], [-122.13516, 38.36173], [-122.13481, 38.36166], [-122.13475, 38.36158], [-122.13454, 38.36146], [-122.13414, 38.3614], [-122.13386, 38.36137], [-122.13364, 38.36141], [-122.13331, 38.3614], [-122.13301, 38.36147], [-122.13241, 38.36148], [-122.13123, 38.36138], [-122.13061, 38.3614], [-122.13022, 38.36131], [-122.13003, 38.36124], [-122.12971, 38.36105], [-122.12947, 38.36072], [-122.1293, 38.36005], [-122.129, 38.35959], [-122.12873, 38.35958], [-122.12898, 38.36], [-122.12913, 38.36022], [-122.12914, 38.36054], [-122.12938, 38.36098], [-122.1296, 38.36121], [-122.12991, 38.36141], [-122.13045, 38.36156], [-122.13104, 38.36158], [-122.13157, 38.36156], [-122.13253, 38.36165], [-122.13312, 38.36166], [-122.13337, 38.36161], [-122.13369, 38.36158], [-122.13388, 38.36154], [-122.13442, 38.36164], [-122.13455, 38.36169], [-122.13468, 38.3618], [-122.13497, 38.36189], [-122.13563, 38.362], [-122.13632, 38.36221], [-122.13678, 38.36228], [-122.1372, 38.36229], [-122.13787, 38.36233], [-122.1382, 38.36239], [-122.13839, 38.36248], [-122.13855, 38.36259], [-122.1387, 38.36274], [-122.13879, 38.36286], [-122.13904, 38.36302], [-122.13927, 38.36312], [-122.13961, 38.36316], [-122.13991, 38.36317], [-122.14057, 38.36336], [-122.14122, 38.36376], [-122.14166, 38.364], [-122.14198, 38.36408], [-122.14226, 38.36404], [-122.14281, 38.36389], [-122.14295, 38.3639], [-122.14322, 38.3641], [-122.14346, 38.36433], [-122.14384, 38.36478], [-122.14404, 38.36509], [-122.14416, 38.36534], [-122.14421, 38.36561], [-122.14423, 38.36687], [-122.14423, 38.3675], [-122.1442, 38.36834], [-122.14405, 38.36879], [-122.1438, 38.36917], [-122.14325, 38.36964], [-122.14279, 38.37007], [-122.14257, 38.37033], [-122.14249, 38.3705], [-122.14253, 38.37065], [-122.14267, 38.37084], [-122.14288, 38.37096], [-122.14325, 38.3711], [-122.14328, 38.37163], [-122.14394, 38.37239], [-122.14249, 38.37349], [-122.14246, 38.37491], [-122.13816, 38.37472], [-122.13819, 38.37527], [-122.13871, 38.37775], [-122.13877, 38.38821], [-122.13876, 38.39117], [-122.13879, 38.39262], [-122.13883, 38.39836], [-122.13884, 38.40294], [-122.13429, 38.40294], [-122.12538, 38.40262], [-122.1252, 38.39908], [-122.11618, 38.39882], [-122.11535, 38.38839], [-122.11825, 38.38838], [-122.12002, 38.38842], [-122.12, 38.38757], [-122.12008, 38.38554], [-122.12007, 38.38483], [-122.1174, 38.38474], [-122.11544, 38.38481]]]} | No Public Access 3 | 1835 | Lake Curry | 20880 | 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 | Napa 11 | 3148.149 | Lake Curry | 0 | None 520 | ||
| 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 | ||
| 10667 | 10667 | 10666 | {"type": "MultiPolygon", "coordinates": [[[[-122.19439, 38.27092], [-122.19263, 38.27269], [-122.19055, 38.27268], [-122.19048, 38.27602], [-122.18835, 38.27139], [-122.19304, 38.27115], [-122.19425, 38.27083], [-122.19439, 38.27092]]], [[[-122.20783, 38.25248], [-122.20721, 38.25318], [-122.20285, 38.25318], [-122.20294, 38.25867], [-122.20242, 38.25935], [-122.19566, 38.2584], [-122.19236, 38.25613], [-122.19297, 38.25544], [-122.19314, 38.25272], [-122.19365, 38.25193], [-122.19538, 38.25117], [-122.19809, 38.25182], [-122.20011, 38.24941], [-122.20316, 38.24974], [-122.20407, 38.25169], [-122.20678, 38.25193], [-122.20783, 38.25248]]], [[[-122.20412, 38.28673], [-122.20393, 38.29076], [-122.20138, 38.29104], [-122.20139, 38.29046], [-122.20138, 38.28991], [-122.20136, 38.28966], [-122.20132, 38.28951], [-122.20122, 38.28939], [-122.20082, 38.28903], [-122.20046, 38.28883], [-122.20032, 38.28872], [-122.20021, 38.28859], [-122.20004, 38.28827], [-122.19987, 38.28812], [-122.19969, 38.28801], [-122.19954, 38.28779], [-122.1995, 38.28756], [-122.19954, 38.28728], [-122.1995, 38.28719], [-122.20412, 38.28673]]]]} | No Public Access 3 | 23062 | 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 | Napa 11 | 257.233 | Vallejo Lakes | None 937 |
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]);