units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where ACCESS_TYP = 2 and DES_TP = 14 sorted by MNG_AG_LEV
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME, YR_EST
MNG_AGENCY 24
- Sacramento, County of 4
- Los Angeles, City of 2
- San Francisco - Public Utilities Commission, City and County of 2
- Truckee Tahoe Airport District 2
- Santa Clara Valley Water District 2
- Conejo Recreation and Park District 1
- Los Angeles, County of 1
- Monterey Peninsula Regional Park District 1
- Hayward Area Recreation and Park District 1
- Los Angeles - Department of Water and Power, City of 1
- Los Angeles County Flood Control District 1
- Sonoma County Agricultural Preservation and Open Space District 1
- American Canyon, City of 1
- Vallejo, City of 1
- Humboldt, County of 1
- Sacramento Regional County Sanitation District 1
- San Lorenzo Valley Water District 1
- Galt, City of 1
- Borrego Water District 1
- Orange County Department of Education, County of 1
- Coachella Valley Association of Governments 1
- Watershed Conservation Authority 1
- Novato Sanitary District 1
- Western Riverside County Regional Conservation Authority 1
MNG_AG_TYP 11
LAYER 3 ✖
- Special District 16
- County 9
- City 6
DES_TP 1
- Local Other or Unknown · 31 ✖
ACCESS_TYP 1
- Restricted Access · 31 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2551 | 2551 | 2550 | {"type": "Polygon", "coordinates": [[[-122.19184, 38.13515], [-122.19158, 38.13526], [-122.19131, 38.13478], [-122.19123, 38.13468], [-122.19099, 38.1342], [-122.19079, 38.13407], [-122.19041, 38.13416], [-122.1903, 38.13436], [-122.18981, 38.13471], [-122.18936, 38.13477], [-122.18846, 38.13375], [-122.18772, 38.13324], [-122.18704, 38.13336], [-122.18679, 38.13315], [-122.18649, 38.13293], [-122.18554, 38.13206], [-122.1861, 38.13174], [-122.18524, 38.13097], [-122.18589, 38.13091], [-122.18631, 38.13097], [-122.18726, 38.13107], [-122.18796, 38.13157], [-122.18847, 38.13188], [-122.18936, 38.13246], [-122.19034, 38.13316], [-122.19067, 38.13331], [-122.1909, 38.13352], [-122.19133, 38.13422], [-122.19156, 38.13457], [-122.19184, 38.13515]]]} | Restricted Access 2 | 17806 | McIntyre Ranch | 22040 | 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 | 23.753 | McIntyre Ranch | 0 | Local Other or Unknown 14 | 4 | |
4782 | 4782 | 4781 | {"type": "MultiPolygon", "coordinates": [[[[-118.31523, 34.27262], [-118.31155, 34.27525], [-118.31209, 34.27614], [-118.31019, 34.27715], [-118.31018, 34.27759], [-118.30864, 34.278], [-118.30827, 34.27922], [-118.30683, 34.28], [-118.30504, 34.28028], [-118.30418, 34.27659], [-118.3067, 34.27613], [-118.30776, 34.27606], [-118.30797, 34.27532], [-118.30739, 34.27455], [-118.3079, 34.27436], [-118.30845, 34.27422], [-118.30878, 34.27411], [-118.30893, 34.27404], [-118.30921, 34.27384], [-118.30958, 34.27409], [-118.31025, 34.27505], [-118.31221, 34.27344], [-118.31465, 34.27267], [-118.31408, 34.27288], [-118.31389, 34.27298], [-118.31396, 34.27307], [-118.31454, 34.27284], [-118.31523, 34.27262]], [[-118.30988, 34.27535], [-118.30988, 34.27534], [-118.30953, 34.27504], [-118.30924, 34.27461], [-118.30928, 34.27454], [-118.30927, 34.27453], [-118.30885, 34.27447], [-118.3087, 34.27429], [-118.30803, 34.27437], [-118.30782, 34.27443], [-118.30784, 34.27447], [-118.30799, 34.27441], [-118.3086, 34.27434], [-118.30861, 34.27438], [-118.30817, 34.27444], [-118.30816, 34.27446], [-118.30908, 34.27567], [-118.30988, 34.27535]]], [[[-118.31018, 34.27763], [-118.31014, 34.27952], [-118.30543, 34.28199], [-118.30505, 34.28031], [-118.30684, 34.28003], [-118.30831, 34.27923], [-118.30868, 34.27803], [-118.31018, 34.27763]]], [[[-118.31695, 34.27216], [-118.31632, 34.27264], [-118.31581, 34.27301], [-118.3158, 34.27253], [-118.31583, 34.27253], [-118.31587, 34.27248], [-118.31656, 34.27226], [-118.31695, 34.27216]]]]} | Restricted Access 2 | 47252 | Unnamed site - Los Angeles, City of | 30961 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 88.776 | 0 | Local Other or Unknown 14 | 4 | ||
4793 | 4793 | 4792 | {"type": "MultiPolygon", "coordinates": [[[[-121.29204, 38.27768], [-121.29158, 38.27785], [-121.29136, 38.27788], [-121.29122, 38.27786], [-121.29102, 38.27778], [-121.29092, 38.27771], [-121.29083, 38.27761], [-121.29072, 38.27737], [-121.29065, 38.27731], [-121.29057, 38.27728], [-121.29048, 38.27726], [-121.29034, 38.27729], [-121.29026, 38.27734], [-121.2902, 38.27744], [-121.29019, 38.27802], [-121.29016, 38.27812], [-121.2901, 38.27821], [-121.28997, 38.27832], [-121.28986, 38.27837], [-121.28977, 38.27838], [-121.28944, 38.27834], [-121.28902, 38.27938], [-121.28899, 38.27942], [-121.28886, 38.27952], [-121.28876, 38.27956], [-121.28864, 38.27957], [-121.28848, 38.27966], [-121.28881, 38.28013], [-121.28882, 38.28017], [-121.28881, 38.2802], [-121.28838, 38.28045], [-121.28808, 38.28066], [-121.28721, 38.28136], [-121.28673, 38.28166], [-121.28621, 38.28191], [-121.28512, 38.28234], [-121.28459, 38.28251], [-121.28411, 38.28262], [-121.28339, 38.28269], [-121.28279, 38.28271], [-121.28274, 38.2827], [-121.28271, 38.28266], [-121.28269, 38.28233], [-121.28313, 38.28232], [-121.28319, 38.28229], [-121.28327, 38.28233], [-121.28337, 38.28234], [-121.28349, 38.28231], [-121.28387, 38.28225], [-121.28423, 38.28218], [-121.28475, 38.28203], [-121.28583, 38.28161], [-121.28631, 38.28139], [-121.28676, 38.28112], [-121.28698, 38.28096], [-121.28717, 38.28078], [-121.28725, 38.28073], [-121.2873, 38.28066], [-121.2873, 38.2806], [-121.28728, 38.28055], [-121.28734, 38.28052], [-121.2876, 38.2799], [-121.28755, 38.27979], [-121.28758, 38.27975], [-121.28758, 38.2797], [-121.28771, 38.27969], [-121.28792, 38.27918], [-121.28802, 38.27903], [-121.28816, 38.2787], [-121.28869, 38.27764], [-121.28882, 38.27746], [-121.28898, 38.27728], [-121.28916, 38.27713], [-121.28948, 38.27693], [-121.28976, 38.27682], [-121.29042, 38.2766], [-121.29066, 38.27659], [-121.2909, 38.27663], [-121.29111, 38.27672], [-121.29122, 38.27681], [-121.29131, 38.2769], [-121.29135, 38.27695], [-121.29127, 38.27699], [-121.29147, 38.27745], [-121.29155, 38.27749], [-121.29169, 38.27751], [-121.29178, 38.2775], [-121.2919, 38.27744], [-121.29204, 38.27768]]], [[[-121.30035, 38.27651], [-121.30032, 38.27682], [-121.30028, 38.277], [-121.3002, 38.27717], [-121.29942, 38.27706], [-121.2968, 38.27706], [-121.29631, 38.27711], [-121.29594, 38.27721], [-121.29553, 38.27735], [-121.29535, 38.27739], [-121.29517, 38.27739], [-121.29498, 38.27738], [-121.29385, 38.27719], [-121.29363, 38.27718], [-121.29348, 38.2772], [-121.29334, 38.27725], [-121.29323, 38.27732], [-121.29301, 38.2775], [-121.29284, 38.27761], [-121.29264, 38.2777], [-121.29243, 38.27777], [-121.29213, 38.27722], [-121.29247, 38.27708], [-121.29274, 38.27684], [-121.29348, 38.27665], [-121.29354, 38.27669], [-121.29365, 38.2767], [-121.29379, 38.27663], [-121.29424, 38.27653], [-121.29443, 38.27653], [-121.29453, 38.27646], [-121.29458, 38.27648], [-121.29523, 38.27628], [-121.29553, 38.27621], [-121.29583, 38.27618], [-121.2963, 38.27617], [-121.29753, 38.27624], [-121.29758, 38.2763], [-121.29766, 38.27632], [-121.29784, 38.2763], [-121.29934, 38.27638], [-121.29947, 38.27642], [-121.29958, 38.2764], [-121.29964, 38.27635], [-121.30035, 38.27651]]], [[[-121.30096, 38.27735], [-121.30038, 38.27726], [-121.30051, 38.27695], [-121.30056, 38.27663], [-121.30091, 38.27661], [-121.30095, 38.27685], [-121.30096, 38.27735]]]]} | Restricted Access 2 | 48279 | Unnamed Site - Galt, City of | 32849 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 35.606 | 0 | Local Other or Unknown 14 | 4 | ||
5686 | 5686 | 5685 | {"type": "MultiPolygon", "coordinates": [[[[-118.3146, 34.27718], [-118.31015, 34.27952], [-118.31012, 34.28089], [-118.30824, 34.28088], [-118.30823, 34.28248], [-118.29952, 34.28253], [-118.29956, 34.27885], [-118.29706, 34.27885], [-118.29722, 34.27856], [-118.29724, 34.27849], [-118.29738, 34.2783], [-118.29747, 34.27821], [-118.29783, 34.27791], [-118.29786, 34.27793], [-118.29789, 34.27792], [-118.29821, 34.27767], [-118.29855, 34.27746], [-118.30008, 34.27668], [-118.3003, 34.2766], [-118.30082, 34.27644], [-118.30124, 34.27638], [-118.30148, 34.27636], [-118.30179, 34.27635], [-118.30215, 34.27638], [-118.30253, 34.27644], [-118.30288, 34.27652], [-118.30345, 34.27671], [-118.30377, 34.27657], [-118.30377, 34.27655], [-118.30284, 34.27626], [-118.30232, 34.27616], [-118.30186, 34.27612], [-118.30133, 34.27613], [-118.30082, 34.2762], [-118.30049, 34.27628], [-118.3001, 34.27642], [-118.29959, 34.27575], [-118.29954, 34.27574], [-118.29962, 34.27549], [-118.29968, 34.27539], [-118.29981, 34.27528], [-118.3, 34.27521], [-118.30057, 34.27519], [-118.30046, 34.27535], [-118.30057, 34.27547], [-118.3008, 34.2755], [-118.3011, 34.27538], [-118.30106, 34.27524], [-118.30099, 34.27511], [-118.30108, 34.27507], [-118.3012, 34.27498], [-118.30129, 34.27487], [-118.30137, 34.27475], [-118.30153, 34.27463], [-118.30177, 34.27453], [-118.30201, 34.27451], [-118.30222, 34.27422], [-118.30235, 34.27419], [-118.30258, 34.27423], [-118.30327, 34.27406], [-118.30329, 34.27402], [-118.30407, 34.27408], [-118.30494, 34.27453], [-118.30407, 34.27497], [-118.30424, 34.27605], [-118.30424, 34.27608], [-118.30407, 34.27612], [-118.30544, 34.28198], [-118.31014, 34.27952], [-118.31018, 34.27715], [-118.31201, 34.27618], [-118.3146, 34.27718]]], [[[-118.29958, 34.27524], [-118.29947, 34.27538], [-118.2994, 34.27551], [-118.29898, 34.27524], [-118.29958, 34.27524]]], [[[-118.30022, 34.27503], [-118.29996, 34.27505], [-118.29981, 34.2751], [-118.29971, 34.27515], [-118.29971, 34.27511], [-118.30005, 34.27499], [-118.30022, 34.27503]]]]} | Restricted Access 2 | 47237 | Unnamed site - Los Angeles - Department of Water and Power, City of | 30960 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 138.829 | 0 | Local Other or Unknown 14 | 4 | ||
5708 | 5708 | 5707 | {"type": "Polygon", "coordinates": [[[-118.4631, 34.04049], [-118.4631, 34.04049], [-118.46238, 34.04081], [-118.46291, 34.04033], [-118.4631, 34.04049]]]} | Restricted Access 2 | 45779 | Bundy Triangle | 28785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.22 | Bundy Triangle | 0 | Local Other or Unknown 14 | 4 | |
11272 | 11272 | 11271 | {"type": "Polygon", "coordinates": [[[-122.28368, 38.18088], [-122.28209, 38.18427], [-122.278, 38.18424], [-122.27658, 38.18424], [-122.27681, 38.18329], [-122.2768, 38.18328], [-122.27228, 38.18322], [-122.27177, 38.1811], [-122.27824, 38.18104], [-122.28368, 38.18088]]]} | Restricted Access 2 | 21765 | American Canyon Property | 15449 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 72.744 | American Canyon Property | 0 | Local Other or Unknown 14 | 4 | |
1149 | 1149 | 1148 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | 6734 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 0.08 | Hillcrest And Ocean View Lots | 0 | Local Other or Unknown 14 | 4 | |
4519 | 4519 | 4518 | {"type": "Polygon", "coordinates": [[[-117.6523, 33.73705], [-117.6424, 33.73701], [-117.64238, 33.73346], [-117.64935, 33.7315], [-117.65064, 33.73322], [-117.652, 33.73296], [-117.65104, 33.73389], [-117.6515, 33.73494], [-117.6523, 33.73705]]]} | Restricted Access 2 | 12713 | Unnamed site - Orange County Department of Education, County of | 28651 | 313 | Orange County Department of Education, County of 770 | County 3 | County Agency - Other 9 | http://www.ocde.us/ | County 3 | 313 | Orange County Department of Education, County of 751 | County 3 | County Agency - Other 8 | Orange 3 | 105.765 | 0 | Local Other or Unknown 14 | 4 | ||
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | 43001 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.452 | 0 | Local Other or Unknown 14 | 4 | ||
4694 | 4694 | 4693 | {"type": "Polygon", "coordinates": [[[-117.90308, 34.64234], [-117.90298, 34.64592], [-117.89442, 34.64592], [-117.89406, 34.64594], [-117.89415, 34.64234], [-117.89864, 34.64232], [-117.90308, 34.64234]]]} | Restricted Access 2 | 45942 | Unnamed site - Los Angeles, County of | 29046 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 80.519 | 0 | Local Other or Unknown 14 | 4 | ||
4758 | 4758 | 4757 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | 46661 | Unnamed site - Humboldt, County of | 29996 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 19.487 | 0 | Local Other or Unknown 14 | 4 | ||
5923 | 5923 | 5922 | {"type": "Polygon", "coordinates": [[[-122.1385, 37.48163], [-122.13828, 37.48212], [-122.13754, 37.48296], [-122.13725, 37.48334], [-122.13641, 37.48427], [-122.13358, 37.48639], [-122.13244, 37.48637], [-122.12668, 37.4898], [-122.12636, 37.48978], [-122.12589, 37.4898], [-122.1259, 37.48918], [-122.12601, 37.48639], [-122.12719, 37.48574], [-122.12827, 37.48519], [-122.13007, 37.48435], [-122.1312, 37.48388], [-122.13088, 37.48337], [-122.13108, 37.4829], [-122.13274, 37.48232], [-122.13331, 37.48262], [-122.1338, 37.48271], [-122.13422, 37.48259], [-122.13498, 37.48243], [-122.13544, 37.48231], [-122.13605, 37.48227], [-122.13669, 37.48211], [-122.13741, 37.48183], [-122.1385, 37.48163]]]} | Restricted Access 2 | 455 | San Mateo Properties | 24954 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 94.811 | San Mateo Properties | 1930 | Local Other or Unknown 14 | 4 | |
11138 | 11138 | 11137 | {"type": "Polygon", "coordinates": [[[-121.29786, 38.49822], [-121.29733, 38.49802], [-121.2969, 38.49796], [-121.29661, 38.49799], [-121.29634, 38.49832], [-121.29629, 38.49874], [-121.29647, 38.49922], [-121.29644, 38.49953], [-121.29651, 38.49982], [-121.29676, 38.49992], [-121.29701, 38.49988], [-121.29784, 38.49901], [-121.29783, 38.50332], [-121.29735, 38.50321], [-121.29714, 38.50313], [-121.29689, 38.50305], [-121.29688, 38.50306], [-121.29691, 38.50315], [-121.29703, 38.50326], [-121.29748, 38.50354], [-121.29428, 38.50352], [-121.29385, 38.50329], [-121.29323, 38.50315], [-121.29275, 38.50326], [-121.29239, 38.50351], [-121.28867, 38.50348], [-121.28869, 38.50214], [-121.2923, 38.50215], [-121.29546, 38.49847], [-121.29544, 38.49627], [-121.29762, 38.49629], [-121.29774, 38.49637], [-121.29785, 38.49753], [-121.29786, 38.49822]], [[-121.29624, 38.50255], [-121.29625, 38.50254], [-121.29618, 38.50232], [-121.29606, 38.50211], [-121.29588, 38.50192], [-121.29566, 38.50176], [-121.29541, 38.50164], [-121.29512, 38.50157], [-121.29483, 38.50154], [-121.29453, 38.50156], [-121.29425, 38.50162], [-121.29398, 38.50173], [-121.29374, 38.50176], [-121.29351, 38.50182], [-121.2933, 38.50192], [-121.29313, 38.50205], [-121.293, 38.50219], [-121.29301, 38.5022], [-121.29326, 38.50215], [-121.29354, 38.50213], [-121.29382, 38.50215], [-121.29409, 38.50221], [-121.29464, 38.50225], [-121.29519, 38.50231], [-121.29572, 38.50242], [-121.29624, 38.50255]]]} | Restricted Access 2 | 21429 | Arroyo Seco (florin Mitigation Bank) | 15628 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 66.229 | Arroyo Seco (florin Mitigation Bank) | 0 | Local Other or Unknown 14 | 4 | |
11411 | 11411 | 11410 | {"type": "Polygon", "coordinates": [[[-121.44882, 38.38398], [-121.44574, 38.38469], [-121.44561, 38.38473], [-121.44549, 38.38479], [-121.44535, 38.38492], [-121.44535, 38.38427], [-121.44879, 38.38348], [-121.44879, 38.38397], [-121.44882, 38.38398]]]} | Restricted Access 2 | 22248 | Lotus Pond Drainage | 21545 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 4.291 | Lotus Pond Drainage | 0 | Local Other or Unknown 14 | 4 | |
11416 | 11416 | 11415 | {"type": "MultiPolygon", "coordinates": [[[[-121.21771, 38.43508], [-121.21767, 38.43514], [-121.21731, 38.43503], [-121.21701, 38.43503], [-121.21678, 38.43513], [-121.21658, 38.43516], [-121.21642, 38.43515], [-121.21609, 38.43504], [-121.21579, 38.43498], [-121.21541, 38.43495], [-121.21521, 38.43491], [-121.21521, 38.43479], [-121.2153, 38.43448], [-121.21529, 38.43433], [-121.2152, 38.43412], [-121.21522, 38.43402], [-121.2154, 38.43378], [-121.21556, 38.43335], [-121.21562, 38.43316], [-121.21558, 38.433], [-121.21538, 38.43274], [-121.21497, 38.43244], [-121.2147, 38.4323], [-121.21424, 38.43218], [-121.21361, 38.43208], [-121.21335, 38.43213], [-121.21298, 38.43228], [-121.21241, 38.43242], [-121.21216, 38.43255], [-121.21175, 38.43286], [-121.21165, 38.43299], [-121.21163, 38.4332], [-121.21162, 38.43355], [-121.21155, 38.43361], [-121.21145, 38.4336], [-121.21134, 38.43357], [-121.21111, 38.43335], [-121.21093, 38.43326], [-121.21068, 38.43323], [-121.21074, 38.43315], [-121.21279, 38.43099], [-121.2167, 38.43328], [-121.21655, 38.43334], [-121.21649, 38.43335], [-121.2163, 38.43348], [-121.21623, 38.43364], [-121.21624, 38.43385], [-121.21637, 38.43403], [-121.21673, 38.43437], [-121.21706, 38.43464], [-121.21766, 38.43499], [-121.21771, 38.43508]]], [[[-121.22965, 38.44085], [-121.22946, 38.44104], [-121.22924, 38.44124], [-121.22905, 38.44133], [-121.2284, 38.4414], [-121.22792, 38.44165], [-121.22743, 38.44203], [-121.22713, 38.44222], [-121.22653, 38.44252], [-121.22623, 38.44284], [-121.226, 38.443], [-121.22581, 38.44318], [-121.22536, 38.44373], [-121.22511, 38.44393], [-121.22441, 38.44463], [-121.22389, 38.44499], [-121.22347, 38.44513], [-121.22277, 38.44533], [-121.22211, 38.44582], [-121.22187, 38.44601], [-121.22168, 38.4462], [-121.22097, 38.44668], [-121.22032, 38.44693], [-121.21922, 38.44722], [-121.21851, 38.44722], [-121.21769, 38.44713], [-121.21696, 38.447], [-121.21555, 38.44658], [-121.21532, 38.44655], [-121.21717, 38.44459], [-121.21532, 38.4435], [-121.21808, 38.44059], [-121.21514, 38.43887], [-121.2152, 38.43879], [-121.21524, 38.43868], [-121.21537, 38.43863], [-121.2156, 38.43866], [-121.21601, 38.43877], [-121.21619, 38.4388], [-121.21635, 38.43874], [-121.21674, 38.43846], [-121.2169, 38.43837], [-121.21706, 38.43839], [-121.21718, 38.43847], [-121.21725, 38.43882], [-121.21726, 38.43969], [-121.2173, 38.43983], [-121.21742, 38.43991], [-121.2176, 38.43996], [-121.21794, 38.43998], [-121.21845, 38.44009], [-121.21868, 38.44008], [-121.21886, 38.43998], [-121.21899, 38.43996], [-121.21917, 38.44006], [-121.21933, 38.44013], [-121.21959, 38.44017], [-121.21986, 38.44018], [-121.21998, 38.44033], [-121.21998, 38.44046], [-121.21989, 38.44088], [-121.2199, 38.44104], [-121.21996, 38.44117], [-121.22011, 38.44136], [-121.22013, 38.44145], [-121.22008, 38.44158], [-121.22009, 38.44168], [-121.22019, 38.44185], [-121.22041, 38.44203], [-121.22087, 38.44236], [-121.22103, 38.44243], [-121.2212, 38.44241], [-121.22138, 38.44231], [-121.22142, 38.44216], [-121.22142, 38.442], [-121.22139, 38.44196], [-121.22139, 38.44201], [-121.22138, 38.44206], [-121.22133, 38.44208], [-121.22124, 38.44202], [-121.22115, 38.44202], [-121.22114, 38.44194], [-121.22118, 38.44188], [-121.22124, 38.44183], [-121.2213, 38.44186], [-121.22137, 38.44194], [-121.22139, 38.44193], [-121.22125, 38.44166], [-121.22108, 38.44122], [-121.22086, 38.44092], [-121.22063, 38.44071], [-121.22042, 38.44048], [-121.22025, 38.44006], [-121.21964, 38.43942], [-121.21954, 38.43924], [-121.21951, 38.43898], [-121.21963, 38.43889], [-121.21975, 38.43889], [-121.21991, 38.43898], [-121.22013, 38.43921], [-121.22054, 38.43948], [-121.22075, 38.43968], [-121.22107, 38.44003], [-121.22131, 38.44023], [-121.2215, 38.44033], [-121.22166, 38.44034], [-121.22211, 38.44031], [-121.22236, 38.44034], [-121.22272, 38.44034], [-121.22306, 38.4403], [-121.22328, 38.44022], [-121.22356, 38.44006], [-121.2241, 38.43986], [-121.22413, 38.43978], [-121.22409, 38.4397], [-121.224, 38.43964], [-121.22367, 38.43955], [-121.22339, 38.43955], [-121.22304, 38.43959], [-121.22272, 38.4396], [-121.22234, 38.43955], [-121.22181, 38.43943], [-121.22165, 38.43931], [-121.22141, 38.43903], [-121.22119, 38.43864], [-121.22098, 38.43849], [-121.22077, 38.43842], [-121.22022, 38.43828], [-121.22, 38.43813], [-121.21952, 38.43768], [-121.21906, 38.43738], [-121.21873, 38.43708], [-121.21861, 38.43684], [-121.21863, 38.43653], [-121.21878, 38.43618], [-121.21908, 38.43587], [-121.21941, 38.43558], [-121.21998, 38.4353], [-121.22005, 38.43525], [-121.22004, 38.43523], [-121.22007, 38.43523], [-121.22007, 38.43525], [-121.22965, 38.44085]]]]} | Restricted Access 2 | 22225 | Nelson Family Ranch | 22696 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 208.842 | Nelson Family Ranch | 0 | Local Other or Unknown 14 | 4 | |
2719 | 2719 | 2718 | {"type": "Polygon", "coordinates": [[[-122.15145, 37.62482], [-122.1508, 37.62499], [-122.14973, 37.62515], [-122.14837, 37.62508], [-122.14707, 37.62481], [-122.14004, 37.62225], [-122.13959, 37.62203], [-122.13915, 37.62174], [-122.14433, 37.62003], [-122.14478, 37.62002], [-122.14935, 37.61837], [-122.15103, 37.61782], [-122.15106, 37.61893], [-122.15087, 37.61931], [-122.15075, 37.62021], [-122.15092, 37.62129], [-122.15132, 37.6246], [-122.15145, 37.62482]]]} | Restricted Access 2 | 18348 | Oliver Property | 23136 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 118.291 | Oliver Property | 1977 | Local Other or Unknown 14 | 4 | |
3586 | 3586 | 3585 | {"type": "Polygon", "coordinates": [[[-120.11203, 39.33019], [-120.08116, 39.33018], [-120.08102, 39.32357], [-120.08615, 39.32375], [-120.08611, 39.31645], [-120.10961, 39.31639], [-120.10962, 39.32423], [-120.10845, 39.3243], [-120.10845, 39.32716], [-120.11194, 39.32719], [-120.11203, 39.33019]]]} | Restricted Access 2 | 37007 | Waddle Ranch | 27205 | 2329 | Truckee Tahoe Airport District 663 | Special District 4 | Community Services District 19 | http://www.truckeetahoeairport.com/ | Special District 4 | 2329 | Truckee Tahoe Airport District 651 | Special District 4 | Community Services District 17 | Nevada 30 | 851.88 | Waddle Ranch | 0 | Local Other or Unknown 14 | 4 | |
3741 | 3741 | 3740 | {"type": "Polygon", "coordinates": [[[-121.909, 36.51865], [-121.90875, 36.51885], [-121.90885, 36.51911], [-121.90865, 36.51936], [-121.90826, 36.5196], [-121.90811, 36.51967], [-121.90807, 36.51973], [-121.90716, 36.52011], [-121.90656, 36.52042], [-121.90615, 36.52045], [-121.90555, 36.52056], [-121.90501, 36.52079], [-121.9046, 36.52107], [-121.90365, 36.52139], [-121.9025, 36.52232], [-121.90225, 36.5224], [-121.90144, 36.52252], [-121.90107, 36.52238], [-121.90084, 36.52241], [-121.90066, 36.52256], [-121.90048, 36.52259], [-121.89827, 36.52246], [-121.89696, 36.52232], [-121.89571, 36.51565], [-121.8964, 36.51259], [-121.89768, 36.51305], [-121.89768, 36.5118], [-121.90218, 36.51185], [-121.90218, 36.50821], [-121.90668, 36.50827], [-121.90669, 36.51191], [-121.90662, 36.51654], [-121.909, 36.51865]]]} | Restricted Access 2 | 44849 | Whisler-Wilson Ranch | 28252 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 306.464 | Whisler-Wilson Ranch | 0 | Local Other or Unknown 14 | 4 | |
4470 | 4470 | 4469 | {"type": "Polygon", "coordinates": [[[-116.37329, 33.19965], [-116.36458, 33.19964], [-116.36453, 33.19257], [-116.37324, 33.19257], [-116.37329, 33.19965]]]} | Restricted Access 2 | 1194 | Unnamed site - Borrego Water District | 28622 | 2008 | Borrego Water District 764 | Special District 4 | Water District 13 | http://www.borregowd.org/ | Special District 4 | 2008 | Borrego Water District 745 | Special District 4 | Water District 13 | San Diego 4 | 157.534 | 0 | Local Other or Unknown 14 | 4 | ||
4692 | 4692 | 4691 | {"type": "Polygon", "coordinates": [[[-118.35865, 34.26614], [-118.35827, 34.26807], [-118.35695, 34.26791], [-118.35657, 34.2683], [-118.35593, 34.26829], [-118.35637, 34.26785], [-118.35636, 34.26783], [-118.35538, 34.26771], [-118.35584, 34.26829], [-118.35539, 34.26829], [-118.35538, 34.2683], [-118.3577, 34.27107], [-118.35758, 34.2717], [-118.35674, 34.27179], [-118.3562, 34.272], [-118.35591, 34.27203], [-118.35491, 34.27184], [-118.35328, 34.27158], [-118.35331, 34.27145], [-118.35321, 34.27142], [-118.35327, 34.27106], [-118.35311, 34.27121], [-118.35307, 34.27142], [-118.35297, 34.27141], [-118.35294, 34.27154], [-118.35225, 34.27148], [-118.3521, 34.27136], [-118.35132, 34.27105], [-118.35025, 34.27136], [-118.35001, 34.27136], [-118.34913, 34.27125], [-118.34883, 34.27106], [-118.34638, 34.27079], [-118.3461, 34.27079], [-118.34579, 34.27083], [-118.34487, 34.27088], [-118.34383, 34.27067], [-118.34275, 34.27038], [-118.34297, 34.2702], [-118.34461, 34.26985], [-118.34448, 34.26941], [-118.34405, 34.26957], [-118.34268, 34.26987], [-118.34194, 34.26956], [-118.34228, 34.26782], [-118.33932, 34.26743], [-118.33933, 34.26732], [-118.33824, 34.26717], [-118.33809, 34.26706], [-118.33774, 34.26708], [-118.33774, 34.2671], [-118.33771, 34.26708], [-118.33752, 34.26709], [-118.33678, 34.26627], [-118.33684, 34.26622], [-118.33636, 34.26564], [-118.33801, 34.26554], [-118.33802, 34.26556], [-118.33921, 34.26572], [-118.3404, 34.26577], [-118.34054, 34.26507], [-118.34096, 34.26513], [-118.34096, 34.26515], [-118.34167, 34.26525], [-118.34171, 34.26509], [-118.34256, 34.26511], [-118.34257, 34.26507], [-118.34282, 34.26507], [-118.34299, 34.26424], [-118.34363, 34.26427], [-118.34414, 34.26432], [-118.34481, 34.26442], [-118.34531, 34.26452], [-118.34609, 34.26472], [-118.3483, 34.26542], [-118.34897, 34.26558], [-118.34944, 34.26565], [-118.35413, 34.26605], [-118.35603, 34.26619], [-118.35857, 34.26622], [-118.35865, 34.26614]]]} | Restricted Access 2 | 45521 | Unnamed - Los Angeles County Flood Control District | 30959 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/wrd/Projects/BTWMA/index.cfm | Los Angeles 6 | 242.496 | 0 | Local Other or Unknown 14 | 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]);