units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where YR_EST = 1991
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, DES_TP
MNG_AG_TYP 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1603 | 1603 | 1602 | {"type": "Polygon", "coordinates": [[[-122.15485, 37.85745], [-122.15479, 37.85769], [-122.15364, 37.85749], [-122.15188, 37.85642], [-122.15096, 37.85579], [-122.15047, 37.85561], [-122.15261, 37.85473], [-122.15278, 37.85487], [-122.15361, 37.8555], [-122.15275, 37.85595], [-122.15275, 37.85596], [-122.15485, 37.85745]]]} | Open Access 1 | 12261 | Orinda Oaks Park | 23203 | 1235 | Orinda, City of 392 | City 2 | City Agency 2 | http://www.cityoforinda.org/index.asp?Type=B_BASIC&SEC={DF30AA31-A638-4650-A63E-8E4033089DBE} | City 2 | 1235 | Orinda, City of 386 | City 2 | City Agency 2 | Contra Costa 12 | 10.843 | Orinda Oaks Park | 1991 | Local Park 2 | 4 | |
1808 | 1808 | 1807 | {"type": "Polygon", "coordinates": [[[-121.84545, 37.34799], [-121.84505, 37.34825], [-121.8444, 37.34765], [-121.84479, 37.34738], [-121.84545, 37.34799]]]} | Open Access 1 | 13712 | Parque De La Amistad | 23473 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.998 | Parque De La Amistad | 1991 | None 142 | ||
2107 | 2107 | 2106 | {"type": "Polygon", "coordinates": [[[-121.823, 37.2655], [-121.82273, 37.26566], [-121.82189, 37.26626], [-121.82172, 37.26633], [-121.82156, 37.26635], [-121.82143, 37.26634], [-121.82131, 37.2663], [-121.82003, 37.26559], [-121.8195, 37.26514], [-121.81947, 37.26509], [-121.81945, 37.26503], [-121.81942, 37.26502], [-121.81945, 37.26287], [-121.82135, 37.26289], [-121.82136, 37.26338], [-121.82176, 37.26351], [-121.82177, 37.26403], [-121.82155, 37.2643], [-121.82156, 37.26434], [-121.823, 37.2655]]]} | Open Access 1 | 15890 | Edenvale Garden | 18431 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 18.978 | Edenvale Garden | 1991 | Local Park 2 | 4 | |
2162 | 2162 | 2161 | {"type": "Polygon", "coordinates": [[[-122.1072, 38.49368], [-122.10672, 38.49336], [-122.10649, 38.49316], [-122.10637, 38.49012], [-122.10659, 38.49004], [-122.10674, 38.48989], [-122.10698, 38.4896], [-122.10718, 38.48928], [-122.1072, 38.49368]]]} | Restricted Access 2 | 17585 | Quail Ridge | 24047 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Napa 11 | 6.615 | Quail Ridge | 1991 | None 178 | ||
3040 | 3040 | 3039 | {"type": "Polygon", "coordinates": [[[-121.37084, 39.39974], [-121.37082, 39.39975], [-121.37084, 39.40223], [-121.37031, 39.40225], [-121.36927, 39.40212], [-121.36889, 39.4021], [-121.36818, 39.40194], [-121.36731, 39.40187], [-121.36689, 39.40181], [-121.36642, 39.4018], [-121.36537, 39.40237], [-121.365, 39.40266], [-121.3645, 39.4029], [-121.36351, 39.40323], [-121.36347, 39.40315], [-121.3633, 39.40299], [-121.36301, 39.4028], [-121.36261, 39.40265], [-121.36221, 39.40255], [-121.36179, 39.40237], [-121.36156, 39.40231], [-121.36135, 39.40222], [-121.36087, 39.40192], [-121.36066, 39.40175], [-121.36037, 39.40144], [-121.36022, 39.40118], [-121.36005, 39.40068], [-121.36006, 39.40045], [-121.35987, 39.39992], [-121.35982, 39.3995], [-121.35984, 39.39935], [-121.35995, 39.39926], [-121.3599, 39.39898], [-121.36004, 39.3987], [-121.36069, 39.39803], [-121.3607, 39.39781], [-121.36076, 39.39766], [-121.36102, 39.39757], [-121.36113, 39.39744], [-121.36142, 39.39682], [-121.36172, 39.39637], [-121.36196, 39.39611], [-121.36208, 39.39586], [-121.36216, 39.39557], [-121.36217, 39.39522], [-121.36217, 39.39497], [-121.36227, 39.39469], [-121.36241, 39.39442], [-121.36249, 39.39415], [-121.36241, 39.39383], [-121.36232, 39.39354], [-121.36215, 39.39314], [-121.36201, 39.39289], [-121.36184, 39.39247], [-121.36197, 39.39203], [-121.36213, 39.39172], [-121.36251, 39.39118], [-121.36271, 39.39094], [-121.36287, 39.39068], [-121.36297, 39.39021], [-121.36288, 39.38942], [-121.3629, 39.38902], [-121.36295, 39.38888], [-121.37081, 39.38887], [-121.37076, 39.39567], [-121.37084, 39.39974]]]} | Open Access 1 | 307 | Daugherty Hill Wildlife Area | 30431 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Daugherty-Hill-WA | Butte 42 | 294.385 | Daugherty Hill Wildlife Area | 1991 | State Conservation Area 8 | 2 |
3782 | 3782 | 3781 | {"type": "Polygon", "coordinates": [[[-121.82966, 37.34595], [-121.82886, 37.34644], [-121.82778, 37.34531], [-121.82759, 37.34513], [-121.82758, 37.34508], [-121.82831, 37.34458], [-121.8284, 37.34466], [-121.82778, 37.34509], [-121.82856, 37.34592], [-121.82921, 37.3455], [-121.82966, 37.34595]]]} | Open Access 1 | 8685 | Sylvia Cassell Park | 31405 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/Facilities/Facility/Details/Sylvia-Cassell-Park-61 | Santa Clara 19 | 2.04 | Sylvia Cassell Park | 1991 | Local Park 2 | 4 |
4262 | 4262 | 4261 | {"type": "Polygon", "coordinates": [[[-121.62968, 39.20461], [-121.62981, 39.20619], [-121.62965, 39.20795], [-121.62916, 39.20791], [-121.62904, 39.20973], [-121.62892, 39.21023], [-121.6284, 39.21125], [-121.62609, 39.21031], [-121.62113, 39.20758], [-121.62141, 39.20654], [-121.62161, 39.20636], [-121.62186, 39.20629], [-121.62207, 39.20629], [-121.62247, 39.20646], [-121.62262, 39.20647], [-121.62275, 39.20645], [-121.62321, 39.20669], [-121.62321, 39.2069], [-121.62365, 39.20717], [-121.62403, 39.2072], [-121.62491, 39.20722], [-121.62613, 39.20712], [-121.62637, 39.20707], [-121.62787, 39.20585], [-121.62845, 39.2055], [-121.6291, 39.20513], [-121.62953, 39.20457], [-121.62968, 39.20461]]]} | Restricted Access 2 | 47979 | Feather River Wildlife Area | 18861 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sutter 47 | 61.666 | Feather River Wildlife Area | 1991 | State Conservation Area 8 | 2 | |
4951 | 4951 | 4950 | {"type": "Polygon", "coordinates": [[[-122.29522, 37.84229], [-122.29465, 37.8424], [-122.2945, 37.84185], [-122.29505, 37.84174], [-122.29522, 37.84229]]]} | Open Access 1 | 14774 | Christie Park | 17227 | 1098 | Emeryville, City of 790 | City 2 | City Agency 2 | http://www.ci.emeryville.ca.us/158/City-Parks | City 2 | 1098 | Emeryville, City of 769 | City 2 | City Agency 2 | Alameda 17 | 0.791 | Christie Park | 1991 | Local Park 2 | 4 | |
6086 | 6086 | 6085 | {"type": "MultiPolygon", "coordinates": [[[[-117.00116, 33.01884], [-116.99647, 33.01886], [-116.99635, 33.01507], [-117.00112, 33.01494], [-117.00116, 33.01884]]], [[[-117.01695, 33.01451], [-117.01452, 33.01459], [-117.00983, 33.01471], [-117.00983, 33.01458], [-117.01035, 33.01452], [-117.01054, 33.01217], [-117.01092, 33.01197], [-117.01481, 33.01197], [-117.01603, 33.01335], [-117.01695, 33.01451]]]]} | Restricted Access 2 | 891 | Blue Sky Ecological Reserve | 29220 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 83.938 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
6955 | 6955 | 6954 | {"type": "Polygon", "coordinates": [[[-116.82258, 34.29412], [-116.81895, 34.29413], [-116.81583, 34.29406], [-116.81412, 34.29404], [-116.81378, 34.29375], [-116.81407, 34.28696], [-116.82253, 34.28699], [-116.82258, 34.29412]]]} | Open Access 1 | 844 | Baldwin Lake Ecological Reserve | 32039 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Baldwin-Lake-ER | San Bernardino 22 | 155.025 | Baldwin Lake ER | 1991 | State Conservation Area 8 | 2 |
7736 | 7736 | 7735 | {"type": "Polygon", "coordinates": [[[-121.83615, 37.21266], [-121.83601, 37.21253], [-121.83574, 37.21238], [-121.83546, 37.21225], [-121.83482, 37.21202], [-121.83481, 37.21199], [-121.83493, 37.21118], [-121.83495, 37.21093], [-121.8355, 37.21093], [-121.83549, 37.21084], [-121.83582, 37.21077], [-121.83615, 37.21266]]]} | Open Access 1 | 8250 | Carrabelle Park | 16907 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.683 | Carrabelle Park | 1991 | Local Park 2 | 4 | |
7744 | 7744 | 7743 | {"type": "Polygon", "coordinates": [[[-121.34631, 40.42002], [-121.34615, 40.42376], [-121.34148, 40.4272], [-121.34143, 40.42745], [-121.32718, 40.42717], [-121.32695, 40.42369], [-121.32692, 40.42], [-121.3269, 40.41962], [-121.32733, 40.41916], [-121.32692, 40.41896], [-121.32693, 40.41626], [-121.32213, 40.41631], [-121.3222, 40.40907], [-121.31748, 40.40899], [-121.31731, 40.40549], [-121.31484, 40.40544], [-121.31362, 40.40352], [-121.31355, 40.40337], [-121.31355, 40.40321], [-121.31364, 40.40305], [-121.31428, 40.40218], [-121.31448, 40.40186], [-121.31458, 40.4016], [-121.31458, 40.40141], [-121.31404, 40.40054], [-121.32182, 40.40055], [-121.32205, 40.40548], [-121.32672, 40.4055], [-121.32693, 40.40909], [-121.33173, 40.40915], [-121.33186, 40.41632], [-121.33667, 40.41635], [-121.33663, 40.42002], [-121.34631, 40.42002]]]} | Open Access 1 | 8253 | Warner Valley Wildlife Area | 30514 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Warner-Valley-WA | Plumas 57 | 718.273 | Warner Valley Wildlife Area | 1991 | State Conservation Area 8 | 2 |
8331 | 8331 | 8330 | {"type": "Polygon", "coordinates": [[[-121.94729, 37.71388], [-121.9468, 37.71415], [-121.94663, 37.71434], [-121.94632, 37.71456], [-121.94606, 37.7144], [-121.94573, 37.71423], [-121.9455, 37.71414], [-121.94608, 37.71266], [-121.94656, 37.71266], [-121.9468, 37.71261], [-121.94691, 37.71283], [-121.94696, 37.71336], [-121.94711, 37.71367], [-121.94729, 37.71388]]]} | Open Access 1 | 14763 | Dolan Park | 18189 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 5.045 | Dolan Park | 1991 | Local Park 2 | 4 | |
8602 | 8602 | 8601 | {"type": "Polygon", "coordinates": [[[-122.32356, 38.29943], [-122.32365, 38.29978], [-122.32398, 38.30085], [-122.32422, 38.30177], [-122.32406, 38.30237], [-122.32395, 38.3027], [-122.32387, 38.30282], [-122.3233, 38.30341], [-122.32321, 38.3036], [-122.32318, 38.30361], [-122.32314, 38.30365], [-122.32186, 38.30366], [-122.32193, 38.30225], [-122.32264, 38.30224], [-122.32356, 38.29943]]]} | Restricted Access 2 | 13687 | Connolly Ranch | 17594 | 3035 | Land Trust of Napa County 140 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.napalandtrust.org/ | Non Governmental Organization 10 | 3035 | Land Trust of Napa County 137 | Non Profit 6 | Non Profit - Land Trust 10 | Napa 11 | 11.751 | Connolly Ranch | 1991 | Private Conservation 16 | 2 | |
8809 | 8809 | 8808 | {"type": "Polygon", "coordinates": [[[-122.27629, 37.49154], [-122.27581, 37.49179], [-122.27422, 37.49071], [-122.27576, 37.49084], [-122.27629, 37.49154]]]} | Open Access 1 | 14335 | Heather Park | 19784 | 1295 | San Carlos, City of 438 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | San Mateo 15 | 2.358 | Heather Park | 1991 | Local Park 2 | 4 | |
8813 | 8813 | 8812 | {"type": "Polygon", "coordinates": [[[-122.27702, 37.49658], [-122.27675, 37.49691], [-122.27679, 37.49735], [-122.2766, 37.49734], [-122.27645, 37.49725], [-122.27627, 37.49704], [-122.2755, 37.49746], [-122.27563, 37.49755], [-122.27575, 37.49769], [-122.27586, 37.49771], [-122.27579, 37.49775], [-122.27572, 37.49774], [-122.27559, 37.49761], [-122.27524, 37.49766], [-122.27439, 37.49692], [-122.27455, 37.49655], [-122.27445, 37.4963], [-122.27451, 37.49628], [-122.27455, 37.49624], [-122.27456, 37.49619], [-122.27454, 37.49615], [-122.2741, 37.4957], [-122.27361, 37.49532], [-122.27362, 37.49525], [-122.27376, 37.49511], [-122.27383, 37.495], [-122.27388, 37.4949], [-122.27389, 37.49478], [-122.27387, 37.49459], [-122.27374, 37.49436], [-122.27369, 37.4942], [-122.27361, 37.49383], [-122.27362, 37.4938], [-122.27366, 37.49378], [-122.2743, 37.49369], [-122.27453, 37.49361], [-122.27653, 37.49535], [-122.27586, 37.49584], [-122.27586, 37.49585], [-122.27647, 37.49636], [-122.27695, 37.49625], [-122.27689, 37.49634], [-122.27689, 37.49643], [-122.27694, 37.49652], [-122.27702, 37.49658]]]} | Open Access 1 | 14343 | Highlands Park | 19946 | 1295 | San Carlos, City of 438 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | San Mateo 15 | 17.776 | Highlands Park | 1991 | Local Park 2 | 4 | |
8947 | 8947 | 8946 | {"type": "Polygon", "coordinates": [[[-122.15409, 37.85875], [-122.15382, 37.85912], [-122.15332, 37.8589], [-122.15259, 37.85923], [-122.15174, 37.85981], [-122.15113, 37.86013], [-122.15036, 37.86072], [-122.15004, 37.86052], [-122.14988, 37.86078], [-122.14943, 37.86126], [-122.14924, 37.86109], [-122.14906, 37.86095], [-122.14886, 37.86083], [-122.14741, 37.86019], [-122.147, 37.85999], [-122.14641, 37.85974], [-122.14369, 37.85838], [-122.14335, 37.85825], [-122.14317, 37.85821], [-122.14295, 37.85818], [-122.14268, 37.85816], [-122.1426, 37.85264], [-122.14422, 37.85365], [-122.14541, 37.85435], [-122.14541, 37.85462], [-122.14521, 37.85491], [-122.14526, 37.85503], [-122.14528, 37.85512], [-122.14538, 37.85516], [-122.14542, 37.85521], [-122.14572, 37.85545], [-122.14665, 37.85597], [-122.14686, 37.8567], [-122.14772, 37.85662], [-122.14768, 37.85637], [-122.14785, 37.85571], [-122.14886, 37.85549], [-122.1493, 37.85542], [-122.15037, 37.85557], [-122.15096, 37.85579], [-122.15188, 37.85642], [-122.15363, 37.85749], [-122.15347, 37.85824], [-122.15354, 37.85835], [-122.15365, 37.85847], [-122.15409, 37.85875]]]} | Open Access 1 | 44957 | Mulholland Open Space Preserve | 22595 | 1235 | Orinda, City of 392 | City 2 | City Agency 2 | http://www.cityoforinda.org/index.asp?Type=B_BASIC&SEC={DF30AA31-A638-4650-A63E-8E4033089DBE} | City 2 | 1235 | Orinda, City of 386 | City 2 | City Agency 2 | Contra Costa 12 | 113.073 | Mulholland OSP | 1991 | Local Conservation Area 4 | 2 | |
9322 | 9322 | 9321 | {"type": "MultiPolygon", "coordinates": [[[[-122.20821, 38.11834], [-122.20742, 38.11845], [-122.20759, 38.11937], [-122.20753, 38.11939], [-122.20738, 38.11924], [-122.20708, 38.11901], [-122.20679, 38.11886], [-122.20643, 38.11872], [-122.20619, 38.11868], [-122.20605, 38.1187], [-122.20572, 38.11871], [-122.20511, 38.11879], [-122.20465, 38.11879], [-122.20448, 38.11877], [-122.20415, 38.11871], [-122.20376, 38.11859], [-122.20326, 38.11834], [-122.20334, 38.11833], [-122.20404, 38.11834], [-122.20516, 38.11821], [-122.20614, 38.11753], [-122.20673, 38.11765], [-122.20815, 38.11747], [-122.20815, 38.11805], [-122.20821, 38.11834]]], [[[-122.21023, 38.11913], [-122.21021, 38.11927], [-122.21021, 38.11948], [-122.21038, 38.12021], [-122.21036, 38.12027], [-122.20999, 38.12039], [-122.20989, 38.1204], [-122.20974, 38.12048], [-122.20963, 38.12054], [-122.20944, 38.1207], [-122.20831, 38.12141], [-122.20818, 38.12144], [-122.20804, 38.12144], [-122.20789, 38.1214], [-122.20779, 38.12133], [-122.20771, 38.12121], [-122.20768, 38.12111], [-122.20768, 38.1209], [-122.2077, 38.12074], [-122.20778, 38.12047], [-122.20781, 38.12031], [-122.2078, 38.12001], [-122.20776, 38.11983], [-122.20769, 38.11964], [-122.20758, 38.11947], [-122.20754, 38.11946], [-122.20779, 38.11939], [-122.20789, 38.11952], [-122.20831, 38.11947], [-122.20907, 38.11946], [-122.20961, 38.11914], [-122.21023, 38.11913]]]]} | Open Access 1 | 15541 | Wardlaw Park | 31381 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Wardlaw_School_Park | Solano 26 | 19.165 | Wardlaw Park | 1991 | Local Park 2 | 4 |
9383 | 9383 | 9382 | {"type": "Polygon", "coordinates": [[[-117.02409, 33.01859], [-117.02405, 33.01935], [-117.02293, 33.01948], [-117.02294, 33.02011], [-117.02331, 33.02046], [-117.02327, 33.02094], [-117.01484, 33.02106], [-117.01495, 33.02313], [-117.00114, 33.02272], [-117.00003, 33.02187], [-116.99656, 33.02181], [-116.99647, 33.01886], [-117.00116, 33.01884], [-117.00113, 33.01494], [-117.00176, 33.01492], [-117.00139, 33.01566], [-117.00152, 33.01603], [-117.00223, 33.01638], [-117.00261, 33.01628], [-117.00335, 33.01606], [-117.00334, 33.01603], [-117.00323, 33.01592], [-117.00268, 33.01605], [-117.00264, 33.01604], [-117.00272, 33.01546], [-117.00243, 33.01541], [-117.00251, 33.0149], [-117.00388, 33.01485], [-117.00394, 33.01295], [-117.00393, 33.01294], [-117.00285, 33.01294], [-117.00251, 33.01231], [-117.00056, 33.01283], [-117.00029, 33.01496], [-116.99635, 33.01507], [-116.99612, 33.00753], [-117.00411, 33.00747], [-117.0041, 33.00787], [-117.00447, 33.0083], [-117.00662, 33.00841], [-117.00625, 33.01481], [-117.01452, 33.01459], [-117.01694, 33.01452], [-117.01747, 33.01518], [-117.01827, 33.0154], [-117.01849, 33.01544], [-117.01867, 33.01545], [-117.01925, 33.0154], [-117.01967, 33.01533], [-117.02092, 33.01516], [-117.02205, 33.0149], [-117.02266, 33.01473], [-117.02288, 33.01469], [-117.02335, 33.01457], [-117.02371, 33.01452], [-117.02372, 33.01475], [-117.02384, 33.01474], [-117.02387, 33.01556], [-117.02391, 33.0158], [-117.02389, 33.01581], [-117.02396, 33.01607], [-117.02353, 33.01605], [-117.02223, 33.01607], [-117.02226, 33.01868], [-117.02227, 33.01869], [-117.02409, 33.01859]]]} | Open Access 1 | 12141 | Blue Sky Ecological Reserve | 32055 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Blue-Sky-ER | San Diego 4 | 615.641 | Blue Sky ER | 1991 | State Conservation Area 8 | 2 |
10213 | 10213 | 10212 | {"type": "Polygon", "coordinates": [[[-121.81934, 37.28143], [-121.81929, 37.28212], [-121.81735, 37.28204], [-121.8173, 37.28202], [-121.81728, 37.28199], [-121.81732, 37.28134], [-121.81934, 37.28143]]]} | Open Access 1 | 17862 | Melody Park | 22112 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.419 | Melody Park | 1991 | 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]);