units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where ACCESS_TYP = 2 and COUNTY = 15 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_ID, LABEL_NAME, YR_EST
MNG_AGENCY 15
- San Francisco - Public Utilities Commission, City and County of 5
- Sempervirens Fund 5
- California Department of Fish and Wildlife 3
- Peninsula Open Space Trust 3
- United States Fish and Wildlife Service 2
- California Department of Parks and Recreation 2
- California State Coastal Conservancy 2
- San Francisco, City and County of 1
- San Mateo, City of 1
- Belmont, City of 1
- Midpeninsula Regional Open Space District 1
- Cascade Ranch Historic Farm 1
- Portola Valley Ranch Home Owners Association 1
- Stanford University 1
- National Trust for Historic Preservation 1
DES_TP 15
MNG_AG_TYP 9
ACCESS_TYP 1
- Restricted Access · 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
3579 | 3579 | 3578 | {"type": "Polygon", "coordinates": [[[-122.27737, 37.52515], [-122.27628, 37.5261], [-122.27592, 37.52644], [-122.27476, 37.52551], [-122.27479, 37.52549], [-122.27485, 37.52551], [-122.27523, 37.52566], [-122.27527, 37.52574], [-122.27521, 37.52579], [-122.27589, 37.52633], [-122.27622, 37.52607], [-122.27592, 37.52582], [-122.27595, 37.52578], [-122.27578, 37.52566], [-122.27556, 37.52583], [-122.27534, 37.52568], [-122.27552, 37.52553], [-122.27553, 37.52546], [-122.2755, 37.52536], [-122.27531, 37.52529], [-122.27523, 37.5252], [-122.27526, 37.52495], [-122.27496, 37.52493], [-122.27495, 37.52486], [-122.27535, 37.52488], [-122.27541, 37.52444], [-122.27551, 37.52429], [-122.27562, 37.52424], [-122.27585, 37.52406], [-122.2754, 37.52369], [-122.27546, 37.52366], [-122.27592, 37.524], [-122.27737, 37.52515]]]} | Restricted Access 2 | 29136 | Nesbit School Park | 31954 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 6.56 | Nesbit School Park | 0 | Local Park 2 | 4 | |
4070 | 4070 | 4069 | {"type": "Polygon", "coordinates": [[[-122.26206, 37.57356], [-122.25329, 37.58145], [-122.25329, 37.58145], [-122.25315, 37.58126], [-122.26174, 37.57345], [-122.26206, 37.57356]]]} | Restricted Access 2 | 44448 | San Mateo Fishing Pier | 24951 | 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 | San Mateo 15 | 7.589 | San Mateo Fishing Pier | 0 | State Recreation Area 39 | 4 | |
14357 | 14357 | 14356 | {"type": "Polygon", "coordinates": [[[-122.43472, 37.4203], [-122.43469, 37.42037], [-122.43446, 37.42083], [-122.4341, 37.42131], [-122.43399, 37.42142], [-122.43373, 37.42132], [-122.43314, 37.42182], [-122.4328, 37.42151], [-122.43328, 37.42138], [-122.43363, 37.42038], [-122.43351, 37.42016], [-122.43273, 37.42015], [-122.43193, 37.4206], [-122.43157, 37.42064], [-122.4316, 37.42016], [-122.43222, 37.41984], [-122.43246, 37.41933], [-122.4324, 37.4191], [-122.43212, 37.41903], [-122.43205, 37.41889], [-122.43246, 37.4187], [-122.43311, 37.41865], [-122.43355, 37.41836], [-122.43396, 37.41759], [-122.43381, 37.41744], [-122.43364, 37.4172], [-122.43392, 37.41715], [-122.43398, 37.41754], [-122.43396, 37.41759], [-122.43422, 37.41784], [-122.43428, 37.41792], [-122.43425, 37.41801], [-122.43421, 37.41821], [-122.43421, 37.41834], [-122.4343, 37.41853], [-122.43449, 37.41873], [-122.43489, 37.41893], [-122.43496, 37.419], [-122.43499, 37.41907], [-122.43499, 37.41928], [-122.43492, 37.41953], [-122.43465, 37.42005], [-122.43472, 37.4203]]]} | Restricted Access 2 | 44407 | Cowell-Purisima Coastal Trail | 17731 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | San Mateo 15 | 15.245 | Cowell-Purisima Coastal Trail | None 1214 | |||
14369 | 14369 | 14368 | {"type": "MultiPolygon", "coordinates": [[[[-122.42996, 37.41136], [-122.42941, 37.41135], [-122.42937, 37.41116], [-122.42893, 37.41087], [-122.42819, 37.41085], [-122.42789, 37.41056], [-122.42791, 37.41017], [-122.42718, 37.41014], [-122.42617, 37.40985], [-122.42582, 37.40872], [-122.42589, 37.40859], [-122.42582, 37.40836], [-122.42623, 37.40784], [-122.4262, 37.40764], [-122.4264, 37.40705], [-122.4267, 37.40688], [-122.42689, 37.40654], [-122.4268, 37.40604], [-122.4269, 37.40577], [-122.42664, 37.40523], [-122.42528, 37.4053], [-122.4245, 37.4051], [-122.42447, 37.40466], [-122.42525, 37.4048], [-122.42538, 37.40464], [-122.42552, 37.40455], [-122.42566, 37.40402], [-122.426, 37.40391], [-122.42604, 37.40394], [-122.42609, 37.40394], [-122.42633, 37.40416], [-122.42642, 37.40419], [-122.42664, 37.40432], [-122.42679, 37.40443], [-122.42707, 37.40506], [-122.42712, 37.40543], [-122.42708, 37.40562], [-122.4271, 37.40626], [-122.42699, 37.40673], [-122.42698, 37.40732], [-122.42699, 37.40821], [-122.42697, 37.40864], [-122.42714, 37.40912], [-122.42734, 37.40922], [-122.42734, 37.40927], [-122.42739, 37.40949], [-122.42767, 37.40992], [-122.42785, 37.41013], [-122.42791, 37.41012], [-122.42805, 37.41012], [-122.42824, 37.41006], [-122.42835, 37.41006], [-122.42853, 37.41002], [-122.42862, 37.41007], [-122.42869, 37.41009], [-122.4288, 37.41034], [-122.42902, 37.41057], [-122.42916, 37.41075], [-122.42989, 37.41135], [-122.42996, 37.41136]]], [[[-122.43364, 37.4172], [-122.43347, 37.41724], [-122.43296, 37.41702], [-122.43321, 37.41639], [-122.43332, 37.41629], [-122.43321, 37.41576], [-122.4326, 37.41522], [-122.43172, 37.41547], [-122.43157, 37.41522], [-122.43105, 37.41573], [-122.43053, 37.4145], [-122.43129, 37.41447], [-122.43132, 37.41415], [-122.43158, 37.41413], [-122.43159, 37.41411], [-122.43133, 37.41355], [-122.43123, 37.41331], [-122.43099, 37.41256], [-122.43059, 37.41173], [-122.43031, 37.41161], [-122.43016, 37.41141], [-122.43025, 37.41143], [-122.43046, 37.41155], [-122.43058, 37.41169], [-122.43072, 37.41173], [-122.43082, 37.41179], [-122.4309, 37.41177], [-122.43097, 37.41179], [-122.43105, 37.41171], [-122.43119, 37.41194], [-122.4311, 37.41206], [-122.43109, 37.41211], [-122.4311, 37.41216], [-122.43117, 37.41223], [-122.43127, 37.41218], [-122.43133, 37.41243], [-122.43152, 37.41293], [-122.43188, 37.41341], [-122.43189, 37.41355], [-122.43216, 37.41416], [-122.43242, 37.41444], [-122.43287, 37.415], [-122.43319, 37.41532], [-122.43343, 37.4155], [-122.43354, 37.41553], [-122.43371, 37.4163], [-122.4337, 37.41645], [-122.4336, 37.41676], [-122.43358, 37.41708], [-122.43364, 37.4172]]]]} | Restricted Access 2 | 44457 | Cowell-Purisima Coastal Trail | 17731 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | San Mateo 15 | 26.92 | Cowell-Purisima Coastal Trail | None 1218 | |||
12361 | 12361 | 12360 | {"type": "Polygon", "coordinates": [[[-122.51194, 37.55293], [-122.51175, 37.5529], [-122.51142, 37.5529], [-122.51116, 37.55285], [-122.5109, 37.55283], [-122.51049, 37.55289], [-122.5104, 37.55289], [-122.51017, 37.55282], [-122.50992, 37.55279], [-122.50984, 37.55282], [-122.50966, 37.55296], [-122.50957, 37.55297], [-122.50949, 37.55299], [-122.50915, 37.55295], [-122.50902, 37.55297], [-122.50904, 37.55116], [-122.50851, 37.54998], [-122.50883, 37.54911], [-122.51181, 37.54893], [-122.51174, 37.5492], [-122.51169, 37.54951], [-122.51167, 37.54981], [-122.51167, 37.55012], [-122.51175, 37.55091], [-122.51202, 37.55236], [-122.51194, 37.55293]]]} | Restricted Access 2 | 46924 | Ocean View Farms | 30541 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 27.623 | Ocean View Farms | 0 | Private Agricultural 354 | 4 | |
5431 | 5431 | 5430 | {"type": "Polygon", "coordinates": [[[-122.28359, 37.19448], [-122.27908, 37.19458], [-122.2789, 37.1915], [-122.28349, 37.19108], [-122.28359, 37.19448]]]} | Restricted Access 2 | 24949 | Welden | 27339 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 36.036 | Welden | 0 | Private Conservation 16 | 2 | |
5432 | 5432 | 5431 | {"type": "Polygon", "coordinates": [[[-122.27908, 37.19458], [-122.27174, 37.1941], [-122.27109, 37.19325], [-122.27157, 37.19273], [-122.27165, 37.19281], [-122.27207, 37.19259], [-122.27297, 37.19241], [-122.27343, 37.19201], [-122.2743, 37.19257], [-122.27482, 37.19258], [-122.27577, 37.19236], [-122.27656, 37.19279], [-122.27741, 37.19296], [-122.27773, 37.19264], [-122.27759, 37.1919], [-122.27791, 37.19156], [-122.27818, 37.19107], [-122.27849, 37.1909], [-122.27887, 37.19098], [-122.27908, 37.19458]]]} | Restricted Access 2 | 24950 | Cobb/Mahoney | 17468 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 37.31 | Cobb/Mahoney | 0 | Private Conservation 16 | 2 | |
5433 | 5433 | 5432 | {"type": "Polygon", "coordinates": [[[-122.28349, 37.19108], [-122.2789, 37.1915], [-122.27872, 37.18835], [-122.28339, 37.18766], [-122.28349, 37.19108]]]} | Restricted Access 2 | 24951 | Santos | 25153 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 37.316 | Santos | 0 | Private Conservation 16 | 2 | |
3335 | 3335 | 3334 | {"type": "Polygon", "coordinates": [[[-122.28809, 37.19438], [-122.28359, 37.19448], [-122.2835, 37.19108], [-122.28806, 37.19066], [-122.28809, 37.19438]]]} | Restricted Access 2 | 29767 | Krvavica | 20728 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 39.366 | Krvavica | 0 | Private Conservation 16 | 2 | |
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 | |
15680 | 15680 | 15679 | {"type": "Polygon", "coordinates": [[[-122.3278, 37.584], [-122.32787, 37.58495], [-122.32785, 37.58503], [-122.3278, 37.58512], [-122.32454, 37.58738], [-122.32439, 37.58746], [-122.32426, 37.58749], [-122.32339, 37.58752], [-122.32316, 37.58757], [-122.32295, 37.58766], [-122.32265, 37.58791], [-122.32253, 37.58797], [-122.32238, 37.58802], [-122.32142, 37.58816], [-122.32145, 37.58826], [-122.32097, 37.58825], [-122.32072, 37.58807], [-122.3202, 37.58694], [-122.31931, 37.58631], [-122.31857, 37.58615], [-122.31794, 37.58639], [-122.31797, 37.58625], [-122.31788, 37.58596], [-122.31775, 37.58567], [-122.31758, 37.5851], [-122.3241, 37.5806], [-122.3278, 37.584]]]} | Restricted Access 2 | 14014 | San Mateo Municipal Golf Course | 33037 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 105.785 | San Mateo Municipal GC | 1933 | Local Recreation Area 3 | 4 | |
12736 | 12736 | 12735 | {"type": "Polygon", "coordinates": [[[-122.31405, 37.24358], [-122.31388, 37.2472], [-122.29676, 37.24603], [-122.29663, 37.24252], [-122.30563, 37.24306], [-122.31405, 37.24358]]]} | Restricted Access 2 | 29768 | Sinnott | 31348 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 150.159 | Sinnott | 0 | Private Conservation 16 | 2 | |
4065 | 4065 | 4064 | {"type": "Polygon", "coordinates": [[[-122.31455, 37.22953], [-122.3055, 37.22936], [-122.30557, 37.22201], [-122.31453, 37.22204], [-122.31455, 37.22953]]]} | Restricted Access 2 | 44413 | Butano Crest West | 16543 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 162.51 | Butano Crest West | 0 | Private Conservation 16 | 2 | |
15625 | 15625 | 15624 | {"type": "MultiPolygon", "coordinates": [[[[-122.24865, 37.51867], [-122.24743, 37.51868], [-122.24741, 37.51813], [-122.24748, 37.51813], [-122.24749, 37.51816], [-122.24862, 37.51816], [-122.24865, 37.51867]]], [[[-122.25031, 37.52028], [-122.25023, 37.52041], [-122.24962, 37.5202], [-122.24918, 37.52094], [-122.24828, 37.52218], [-122.2483, 37.52221], [-122.24792, 37.52383], [-122.24781, 37.52382], [-122.2478, 37.52386], [-122.24781, 37.5241], [-122.24786, 37.52424], [-122.24796, 37.52444], [-122.24799, 37.52472], [-122.24791, 37.52535], [-122.24786, 37.52542], [-122.24778, 37.52547], [-122.24723, 37.52548], [-122.24707, 37.52552], [-122.24692, 37.52562], [-122.24685, 37.52574], [-122.2467, 37.52589], [-122.24634, 37.52667], [-122.245, 37.52927], [-122.24342, 37.53062], [-122.24231, 37.53147], [-122.24153, 37.53184], [-122.24148, 37.53156], [-122.24182, 37.53144], [-122.24329, 37.5305], [-122.24468, 37.52927], [-122.245, 37.52866], [-122.24525, 37.52848], [-122.24547, 37.52798], [-122.24599, 37.52722], [-122.24624, 37.52667], [-122.24633, 37.52654], [-122.24643, 37.52628], [-122.24654, 37.52603], [-122.24661, 37.52577], [-122.24721, 37.52417], [-122.24776, 37.52234], [-122.24798, 37.52223], [-122.24811, 37.52205], [-122.24773, 37.52171], [-122.24828, 37.51948], [-122.24999, 37.51947], [-122.25, 37.52016], [-122.25031, 37.52028]]], [[[-122.26048, 37.53983], [-122.25986, 37.54047], [-122.25946, 37.54084], [-122.25913, 37.54101], [-122.25855, 37.5412], [-122.25804, 37.54119], [-122.25772, 37.54131], [-122.25724, 37.54136], [-122.25559, 37.54134], [-122.25503, 37.54121], [-122.25145, 37.54121], [-122.25134, 37.54061], [-122.25128, 37.54022], [-122.25111, 37.53887], [-122.25235, 37.53852], [-122.25331, 37.5382], [-122.25366, 37.53831], [-122.25397, 37.53888], [-122.25428, 37.53932], [-122.25501, 37.53978], [-122.25625, 37.54008], [-122.2566, 37.54011], [-122.25696, 37.54005], [-122.25758, 37.53973], [-122.25905, 37.53885], [-122.25959, 37.53581], [-122.25953, 37.53523], [-122.25952, 37.53411], [-122.26037, 37.53411], [-122.26039, 37.53561], [-122.26051, 37.53857], [-122.26048, 37.53983]]], [[[-122.25028, 37.5486], [-122.24616, 37.55153], [-122.24454, 37.55092], [-122.2445, 37.55056], [-122.23268, 37.5485], [-122.22913, 37.54832], [-122.22573, 37.54575], [-122.22551, 37.54456], [-122.22647, 37.54375], [-122.22746, 37.54312], [-122.228, 37.54251], [-122.22814, 37.54218], [-122.2287, 37.54152], [-122.22976, 37.53961], [-122.23149, 37.53647], [-122.23186, 37.53603], [-122.23309, 37.53486], [-122.2344, 37.53393], [-122.23498, 37.53394], [-122.23331, 37.53504], [-122.23279, 37.53595], [-122.23386, 37.53877], [-122.23243, 37.5399], [-122.23463, 37.54114], [-122.23471, 37.54139], [-122.23202, 37.54174], [-122.23135, 37.54208], [-122.22994, 37.54172], [-122.22602, 37.54478], [-122.22612, 37.54565], [-122.22864, 37.54754], [-122.22881, 37.54742], [-122.2294, 37.54785], [-122.22964, 37.54796], [-122.2339, 37.54828], [-122.23459, 37.54768], [-122.23539, 37.54826], [-122.23601, 37.54817], [-122.24311, 37.54898], [-122.2432, 37.54887], [-122.24423, 37.54895], [-122.24467, 37.54932], [-122.24458, 37.54992], [-122.24415, 37.54987], [-122.24432, 37.55035], [-122.24487, 37.55048], [-122.24483, 37.54996], [-122.24511, 37.54992], [-122.24523, 37.55013], [-122.24553, 37.54982], [-122.24629, 37.54998], [-122.24731, 37.54929], [-122.2456, 37.54832], [-122.24616, 37.54769], [-122.24856, 37.54904], [-122.2492, 37.54861], [-122.24947, 37.5484], [-122.24989, 37.54788], [-122.25022, 37.54713], [-122.25046, 37.54651], [-122.2505, 37.54636], [-122.25049, 37.54618], [-122.2501, 37.54469], [-122.24881, 37.54254], [-122.24985, 37.54224], [-122.25108, 37.54487], [-122.25117, 37.54517], [-122.25127, 37.5459], [-122.25116, 37.54638], [-122.25055, 37.54751], [-122.25015, 37.5481], [-122.24992, 37.54835], [-122.2496, 37.5486], [-122.25028, 37.5486]]], [[[-122.25278, 37.54858], [-122.25136, 37.55035], [-122.25103, 37.55059], [-122.24968, 37.55201], [-122.24686, 37.55341], [-122.24684, 37.55426], [-122.24657, 37.55451], [-122.24683, 37.55476], [-122.24681, 37.55559], [-122.24618, 37.55477], [-122.24514, 37.55598], [-122.24549, 37.55472], [-122.24616, 37.55371], [-122.24753, 37.55203], [-122.25081, 37.54981], [-122.25228, 37.54852], [-122.25251, 37.54853], [-122.25248, 37.54857], [-122.25249, 37.54858], [-122.25278, 37.54858]]]]} | Restricted Access 2 | 24423 | Redwood Shores Ecological Reserve | 24252 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Redwood-Shores-ER | San Mateo 15 | 218.064 | Redwood Shores ER | 1976 | State Conservation Area 8 | 2 |
8497 | 8497 | 8496 | {"type": "Polygon", "coordinates": [[[-122.22153, 37.36198], [-122.22095, 37.36343], [-122.22116, 37.36353], [-122.22107, 37.36357], [-122.22091, 37.36383], [-122.22031, 37.36425], [-122.21982, 37.36432], [-122.21905, 37.36479], [-122.21859, 37.36468], [-122.21792, 37.36468], [-122.21681, 37.36444], [-122.21663, 37.36458], [-122.21652, 37.36457], [-122.21625, 37.36444], [-122.21573, 37.36435], [-122.21511, 37.36387], [-122.21468, 37.36376], [-122.21411, 37.36345], [-122.21396, 37.36339], [-122.21379, 37.36335], [-122.21362, 37.36334], [-122.21345, 37.36335], [-122.21329, 37.36339], [-122.21312, 37.36346], [-122.21298, 37.36354], [-122.21287, 37.36365], [-122.21278, 37.36376], [-122.21271, 37.36391], [-122.21252, 37.36381], [-122.21233, 37.36377], [-122.21212, 37.36376], [-122.21185, 37.3638], [-122.21156, 37.36357], [-122.21116, 37.36334], [-122.21102, 37.36323], [-122.21199, 37.3621], [-122.21094, 37.36096], [-122.20955, 37.35979], [-122.20929, 37.35959], [-122.20817, 37.3594], [-122.20651, 37.35691], [-122.21042, 37.352], [-122.21243, 37.35403], [-122.21338, 37.35413], [-122.21598, 37.35557], [-122.21904, 37.35912], [-122.22061, 37.36021], [-122.22153, 37.36198]]]} | Restricted Access 2 | 13289 | Coal Mine Ridge | 33341 | 6127 | Portola Valley Ranch Home Owners Association 895 | Private 7 | Home Owners Association 16 | Private 14 | 6127 | Portola Valley Ranch Home Owners Association 869 | Private 7 | Home Owners Association 15 | San Mateo 15 | 244.051 | Coal Mine Ridge | 1964 | Private Conservation 16 | 2 | ||
15688 | 15688 | 15687 | {"type": "MultiPolygon", "coordinates": [[[[-122.48702, 37.6263], [-122.48655, 37.62658], [-122.48643, 37.62662], [-122.48629, 37.62664], [-122.48616, 37.62664], [-122.48603, 37.62661], [-122.48592, 37.62657], [-122.48575, 37.62645], [-122.48565, 37.62631], [-122.48562, 37.6262], [-122.48558, 37.62569], [-122.48554, 37.6255], [-122.48541, 37.62524], [-122.48523, 37.62504], [-122.48501, 37.6249], [-122.48476, 37.62481], [-122.48384, 37.62463], [-122.48351, 37.62461], [-122.48332, 37.62463], [-122.48314, 37.62466], [-122.48161, 37.62511], [-122.48145, 37.62518], [-122.4813, 37.62526], [-122.4811, 37.62542], [-122.48093, 37.62562], [-122.48076, 37.62597], [-122.48052, 37.62649], [-122.48042, 37.62664], [-122.4803, 37.62675], [-122.48014, 37.62685], [-122.47997, 37.62693], [-122.47977, 37.62698], [-122.47875, 37.62705], [-122.47843, 37.6271], [-122.4688, 37.62708], [-122.46426, 37.62116], [-122.48041, 37.62146], [-122.48416, 37.62155], [-122.4842, 37.62157], [-122.48433, 37.62181], [-122.48449, 37.62195], [-122.48455, 37.62202], [-122.48465, 37.62231], [-122.48478, 37.62296], [-122.48492, 37.62338], [-122.48502, 37.6247], [-122.48516, 37.62476], [-122.48526, 37.62484], [-122.48533, 37.62493], [-122.48539, 37.62505], [-122.48659, 37.62582], [-122.48702, 37.6263]]], [[[-122.48741, 37.62712], [-122.48228, 37.62711], [-122.48228, 37.62601], [-122.48126, 37.62601], [-122.48125, 37.62656], [-122.48099, 37.62656], [-122.48098, 37.6271], [-122.48003, 37.6271], [-122.48021, 37.62703], [-122.48036, 37.62694], [-122.4805, 37.62682], [-122.48061, 37.6267], [-122.48073, 37.62653], [-122.48111, 37.6257], [-122.48124, 37.62553], [-122.48141, 37.6254], [-122.48169, 37.62527], [-122.48319, 37.62482], [-122.48338, 37.62478], [-122.48358, 37.62477], [-122.48382, 37.62479], [-122.48471, 37.62497], [-122.48493, 37.62506], [-122.4851, 37.62517], [-122.48523, 37.62533], [-122.4853, 37.62544], [-122.48535, 37.62557], [-122.48537, 37.6257], [-122.48542, 37.62622], [-122.48545, 37.62635], [-122.48556, 37.62653], [-122.48573, 37.62667], [-122.4859, 37.62675], [-122.48606, 37.62679], [-122.48625, 37.62681], [-122.48642, 37.62679], [-122.48666, 37.62672], [-122.48715, 37.62643], [-122.48726, 37.62655], [-122.48727, 37.62691], [-122.48741, 37.62712]]], [[[-122.49707, 37.62106], [-122.49634, 37.62137], [-122.49632, 37.62144], [-122.49668, 37.62221], [-122.49506, 37.62934], [-122.49503, 37.62979], [-122.49502, 37.62963], [-122.49501, 37.62962], [-122.49458, 37.62988], [-122.49433, 37.63], [-122.49411, 37.63001], [-122.49409, 37.62982], [-122.49222, 37.62982], [-122.49189, 37.62978], [-122.49148, 37.62965], [-122.49127, 37.62955], [-122.49115, 37.62947], [-122.49101, 37.62934], [-122.49083, 37.62911], [-122.49076, 37.62898], [-122.49068, 37.62876], [-122.49065, 37.62864], [-122.49057, 37.6272], [-122.48958, 37.62723], [-122.48938, 37.62671], [-122.48924, 37.62643], [-122.48908, 37.6262], [-122.48887, 37.62595], [-122.4887, 37.62578], [-122.48815, 37.62535], [-122.48786, 37.62507], [-122.48618, 37.62321], [-122.48574, 37.62275], [-122.48556, 37.62251], [-122.48553, 37.62225], [-122.48562, 37.62203], [-122.48591, 37.62164], [-122.49152, 37.62174], [-122.49152, 37.62169], [-122.49159, 37.62173], [-122.49344, 37.62181], [-122.4931, 37.62054], [-122.49707, 37.62106]]]]} | Restricted Access 2 | 15359 | Sharp Park Golf Course | 33048 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Mateo 15 | 407.344 | Sharp Park GC | 1972 | Local Recreation Area 3 | 4 | |
4149 | 4149 | 4148 | {"type": "MultiPolygon", "coordinates": [[[[-122.32741, 37.14284], [-122.32714, 37.14347], [-122.32654, 37.14419], [-122.32659, 37.14425], [-122.32635, 37.14448], [-122.32503, 37.14518], [-122.3204, 37.14206], [-122.32012, 37.14206], [-122.31984, 37.14197], [-122.31969, 37.14186], [-122.31953, 37.1417], [-122.31951, 37.14157], [-122.3194, 37.14146], [-122.31921, 37.14132], [-122.31909, 37.14122], [-122.31847, 37.14093], [-122.31833, 37.14084], [-122.31822, 37.14074], [-122.31806, 37.14068], [-122.31789, 37.14063], [-122.31761, 37.14047], [-122.31728, 37.14035], [-122.31671, 37.14023], [-122.31598, 37.14017], [-122.31506, 37.14021], [-122.31469, 37.14019], [-122.31474, 37.13998], [-122.31591, 37.13998], [-122.31621, 37.14008], [-122.31682, 37.13974], [-122.31636, 37.13934], [-122.31598, 37.13892], [-122.31583, 37.13895], [-122.31581, 37.13892], [-122.31557, 37.139], [-122.31498, 37.13835], [-122.31505, 37.13831], [-122.31505, 37.13829], [-122.31314, 37.13613], [-122.31577, 37.13477], [-122.32065, 37.13982], [-122.32108, 37.14022], [-122.32156, 37.14058], [-122.32192, 37.14082], [-122.32236, 37.14106], [-122.32309, 37.1414], [-122.32348, 37.14156], [-122.32514, 37.1421], [-122.32517, 37.14208], [-122.32741, 37.14284]]], [[[-122.33433, 37.13521], [-122.33247, 37.13613], [-122.33252, 37.13834], [-122.33203, 37.13838], [-122.33175, 37.13834], [-122.33151, 37.13861], [-122.33151, 37.13868], [-122.33135, 37.13904], [-122.33118, 37.13917], [-122.33089, 37.13931], [-122.33051, 37.13942], [-122.33031, 37.13963], [-122.3302, 37.13989], [-122.33012, 37.14016], [-122.3299, 37.14031], [-122.32948, 37.14052], [-122.32877, 37.14075], [-122.32857, 37.14103], [-122.32809, 37.14106], [-122.32753, 37.1412], [-122.32688, 37.14128], [-122.32644, 37.14131], [-122.326, 37.14148], [-122.32563, 37.14174], [-122.32349, 37.14099], [-122.323, 37.1408], [-122.32236, 37.14048], [-122.32194, 37.14021], [-122.3217, 37.14004], [-122.32132, 37.13973], [-122.32111, 37.13953], [-122.31997, 37.13828], [-122.31976, 37.1381], [-122.31617, 37.13441], [-122.3303, 37.12878], [-122.33433, 37.13521]]]]} | Restricted Access 2 | 47513 | Cascade Ranch | 31226 | 3377 | Cascade Ranch Historic Farm 724 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3377 | Cascade Ranch Historic Farm 709 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 420.574 | Cascade Ranch | 2003 | Private Conservation 16 | 2 | ||
5925 | 5925 | 5924 | {"type": "Polygon", "coordinates": [[[-122.44138, 37.61408], [-122.44117, 37.61412], [-122.44069, 37.61392], [-122.44002, 37.61339], [-122.43948, 37.61261], [-122.43864, 37.61177], [-122.43763, 37.61092], [-122.43671, 37.61028], [-122.43634, 37.60975], [-122.43625, 37.60948], [-122.43585, 37.6092], [-122.43502, 37.60891], [-122.43444, 37.60826], [-122.43427, 37.60785], [-122.43386, 37.60742], [-122.43315, 37.60696], [-122.433, 37.60668], [-122.43269, 37.60643], [-122.43245, 37.60595], [-122.43182, 37.60556], [-122.43113, 37.60494], [-122.43007, 37.60428], [-122.429, 37.60304], [-122.42866, 37.60291], [-122.42866, 37.60265], [-122.42805, 37.60208], [-122.42785, 37.60169], [-122.42702, 37.60087], [-122.42702, 37.60064], [-122.42725, 37.60053], [-122.4273, 37.60029], [-122.42656, 37.59972], [-122.4263, 37.59931], [-122.4259, 37.59895], [-122.42521, 37.59867], [-122.42492, 37.59842], [-122.42474, 37.59792], [-122.42394, 37.59723], [-122.42377, 37.59698], [-122.42371, 37.59661], [-122.42328, 37.59636], [-122.42239, 37.59643], [-122.42224, 37.59631], [-122.42218, 37.59526], [-122.42167, 37.59434], [-122.41931, 37.59171], [-122.41899, 37.59171], [-122.41879, 37.5918], [-122.41859, 37.59207], [-122.41859, 37.59288], [-122.41844, 37.59299], [-122.41819, 37.59299], [-122.41781, 37.5926], [-122.41764, 37.59228], [-122.41761, 37.59203], [-122.41793, 37.5915], [-122.41796, 37.59125], [-122.41784, 37.59111], [-122.41727, 37.59093], [-122.41727, 37.59073], [-122.41752, 37.59036], [-122.41764, 37.58917], [-122.41689, 37.58837], [-122.41661, 37.58784], [-122.41638, 37.58773], [-122.41637, 37.58752], [-122.41597, 37.58718], [-122.41505, 37.58692], [-122.41502, 37.58608], [-122.41416, 37.58534], [-122.41381, 37.58532], [-122.41347, 37.58553], [-122.4131, 37.58562], [-122.41298, 37.58553], [-122.41307, 37.5851], [-122.41295, 37.58495], [-122.41269, 37.58493], [-122.41238, 37.58502], [-122.4122, 37.58496], [-122.41154, 37.58502], [-122.4114, 37.58493], [-122.41143, 37.58452], [-122.41238, 37.58431], [-122.41261, 37.58418], [-122.41261, 37.58397], [-122.412, 37.58335], [-122.4114, 37.58305], [-122.41117, 37.58267], [-122.41082, 37.58262], [-122.41054, 37.58271], [-122.41016, 37.58271], [-122.40996, 37.58234], [-122.41008, 37.58209], [-122.41054, 37.58179], [-122.41057, 37.58127], [-122.41045, 37.58074], [-122.41085, 37.58049], [-122.41224, 37.58006], [-122.41246, 37.5801], [-122.41284, 37.58042], [-122.41341, 37.58063], [-122.4141, 37.58076], [-122.41482, 37.58061], [-122.41689, 37.58061], [-122.41741, 37.58068], [-122.41738, 37.58088], [-122.41707, 37.58104], [-122.41675, 37.58109], [-122.41517, 37.582], [-122.41506, 37.58221], [-122.41548, 37.58267], [-122.41563, 37.58301], [-122.41615, 37.58329], [-122.41661, 37.58365], [-122.41713, 37.58381], [-122.41902, 37.58388], [-122.41899, 37.58404], [-122.41856, 37.58443], [-122.4183, 37.58503], [-122.41836, 37.58534], [-122.41845, 37.58557], [-122.41905, 37.58617], [-122.41946, 37.58672], [-122.41974, 37.5869], [-122.42037, 37.587], [-122.42063, 37.58713], [-122.42075, 37.58745], [-122.42101, 37.5877], [-122.42196, 37.58796], [-122.42262, 37.58802], [-122.42382, 37.58789], [-122.42432, 37.58761], [-122.4246, 37.58764], [-122.42414, 37.58853], [-122.42417, 37.58871], [-122.42472, 37.58892], [-122.42742, 37.58853], [-122.42794, 37.58862], [-122.42788, 37.58876], [-122.42742, 37.58894], [-122.42711, 37.58917], [-122.42636, 37.58949], [-122.42575, 37.59011], [-122.42552, 37.59057], [-122.42564, 37.59086], [-122.42587, 37.59112], [-122.42584, 37.5913], [-122.42558, 37.59148], [-122.42549, 37.59171], [-122.42552, 37.59247], [-122.42567, 37.59279], [-122.42587, 37.59297], [-122.42595, 37.59322], [-122.42633, 37.59354], [-122.42742, 37.59402], [-122.42805, 37.59439], [-122.42857, 37.5945], [-122.43027, 37.59432], [-122.43061, 37.5945], [-122.43044, 37.59494], [-122.43047, 37.59526], [-122.43099, 37.59567], [-122.43102, 37.59599], [-122.43093, 37.59613], [-122.43038, 37.59631], [-122.42926, 37.59638], [-122.42906, 37.59652], [-122.42895, 37.59691], [-122.42906, 37.59716], [-122.4305, 37.59796], [-122.43119, 37.59812], [-122.43277, 37.59881], [-122.4343, 37.59993], [-122.43427, 37.60014], [-122.43378, 37.60073], [-122.43378, 37.60119], [-122.43401, 37.60158], [-122.43424, 37.60169], [-122.43556, 37.60183], [-122.43594, 37.60201], [-122.43628, 37.6024], [-122.43634, 37.60286], [-122.43651, 37.60304], [-122.43692, 37.60298], [-122.43738, 37.60302], [-122.43801, 37.6033], [-122.43893, 37.60321], [-122.43953, 37.60353], [-122.43979, 37.60387], [-122.43994, 37.60426], [-122.44066, 37.6052], [-122.44109, 37.60561], [-122.44117, 37.60579], [-122.44115, 37.60632], [-122.44103, 37.60662], [-122.44022, 37.60728], [-122.44002, 37.60735], [-122.43942, 37.60694], [-122.43801, 37.60659], [-122.43754, 37.60625], [-122.43712, 37.60623], [-122.43654, 37.60654], [-122.43643, 37.60696], [-122.4366, 37.60737], [-122.4372, 37.60797], [-122.43781, 37.60831], [-122.43795, 37.60865], [-122.43821, 37.609], [-122.43844, 37.60994], [-122.44025, 37.61158], [-122.44083, 37.61243], [-122.44137, 37.61362], [-122.44138, 37.61408]]]} | Restricted Access 2 | 408 | San Francisco Watershed Lands | 24889 | 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 | 478.92 | San Francisco Watershed Lands | None 474 | |||
15945 | 15945 | 15944 | {"type": "MultiPolygon", "coordinates": [[[[-122.31171, 37.31299], [-122.30924, 37.31361], [-122.30896, 37.31369], [-122.30858, 37.31384], [-122.30842, 37.31371], [-122.30972, 37.31236], [-122.31041, 37.31218], [-122.31059, 37.31255], [-122.3114, 37.31234], [-122.31171, 37.31299]]], [[[-122.31237, 37.32216], [-122.31219, 37.32245], [-122.31171, 37.32232], [-122.31152, 37.32177], [-122.31139, 37.32155], [-122.31124, 37.32135], [-122.311, 37.32114], [-122.31082, 37.3211], [-122.31068, 37.32109], [-122.31039, 37.32112], [-122.31007, 37.32111], [-122.30958, 37.32102], [-122.3093, 37.32104], [-122.30893, 37.3211], [-122.30819, 37.32115], [-122.30798, 37.32116], [-122.30769, 37.32113], [-122.30743, 37.32096], [-122.30737, 37.32069], [-122.3074, 37.32055], [-122.30755, 37.32034], [-122.30771, 37.32018], [-122.30753, 37.32006], [-122.30733, 37.31988], [-122.30726, 37.31955], [-122.30734, 37.31914], [-122.30742, 37.31893], [-122.30759, 37.31873], [-122.30783, 37.31852], [-122.3081, 37.31834], [-122.30844, 37.31823], [-122.30878, 37.31818], [-122.30918, 37.31817], [-122.30943, 37.31818], [-122.30974, 37.31816], [-122.30977, 37.31789], [-122.30973, 37.31743], [-122.30967, 37.31711], [-122.30943, 37.31694], [-122.30944, 37.3166], [-122.3096, 37.3164], [-122.30971, 37.31595], [-122.30971, 37.31546], [-122.30975, 37.31528], [-122.31004, 37.31473], [-122.3106, 37.31429], [-122.31021, 37.31412], [-122.31033, 37.31387], [-122.3103, 37.3137], [-122.31211, 37.31329], [-122.31205, 37.31341], [-122.31199, 37.31348], [-122.31177, 37.31363], [-122.31161, 37.31371], [-122.31161, 37.31372], [-122.3117, 37.31372], [-122.31186, 37.31378], [-122.31196, 37.3139], [-122.31198, 37.31402], [-122.31192, 37.31416], [-122.31186, 37.31426], [-122.31156, 37.31453], [-122.31127, 37.31466], [-122.31096, 37.31475], [-122.31063, 37.31501], [-122.31033, 37.31539], [-122.31029, 37.31559], [-122.3104, 37.31602], [-122.3102, 37.31676], [-122.31032, 37.31693], [-122.31036, 37.31705], [-122.3104, 37.3173], [-122.31046, 37.31785], [-122.31045, 37.3181], [-122.31037, 37.31842], [-122.31018, 37.31866], [-122.30979, 37.31874], [-122.3089, 37.31872], [-122.30854, 37.31878], [-122.3084, 37.31884], [-122.30819, 37.31901], [-122.30805, 37.31916], [-122.30795, 37.31958], [-122.30813, 37.31964], [-122.30833, 37.31973], [-122.30846, 37.3199], [-122.30848, 37.32018], [-122.3084, 37.32037], [-122.30819, 37.32058], [-122.3082, 37.3206], [-122.3087, 37.32057], [-122.30893, 37.32043], [-122.30943, 37.32048], [-122.30961, 37.32047], [-122.31028, 37.32057], [-122.31059, 37.32055], [-122.31089, 37.32055], [-122.31127, 37.32063], [-122.31159, 37.32082], [-122.31181, 37.32104], [-122.31201, 37.3213], [-122.31216, 37.32156], [-122.31237, 37.32216]]], [[[-122.29778, 37.37792], [-122.2977, 37.3782], [-122.29751, 37.37842], [-122.29705, 37.37865], [-122.29581, 37.37867], [-122.29579, 37.37994], [-122.29562, 37.37938], [-122.29518, 37.37891], [-122.29391, 37.3789], [-122.29387, 37.38057], [-122.28672, 37.38057], [-122.2867, 37.38161], [-122.2823, 37.3816], [-122.28227, 37.38814], [-122.28082, 37.38773], [-122.28025, 37.38768], [-122.2795, 37.38774], [-122.2783, 37.38797], [-122.27756, 37.38796], [-122.27657, 37.38789], [-122.27586, 37.38775], [-122.27522, 37.3878], [-122.2748, 37.3879], [-122.27428, 37.38789], [-122.27329, 37.38801], [-122.2733, 37.38159], [-122.27326, 37.37799], [-122.27373, 37.37798], [-122.27866, 37.37661], [-122.27777, 37.37518], [-122.27747, 37.37428], [-122.27673, 37.37381], [-122.27614, 37.37296], [-122.27641, 37.37176], [-122.27656, 37.37071], [-122.27657, 37.36964], [-122.27721, 37.36879], [-122.27712, 37.36698], [-122.2868, 37.36709], [-122.28677, 37.37424], [-122.28674, 37.37861], [-122.2915, 37.37861], [-122.29219, 37.37791], [-122.29239, 37.37791], [-122.29238, 37.37769], [-122.29211, 37.37757], [-122.29219, 37.37749], [-122.2926, 37.37757], [-122.29276, 37.3777], [-122.29279, 37.37787], [-122.29276, 37.37791], [-122.29277, 37.37792], [-122.29778, 37.37792]]]]} | Restricted Access 2 | 43105 | La Honda Creek Open Space Preserve | 20760 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 594.683 | La Honda Creek OSP | 1984 | Local Conservation Area 4 | 2 |
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]);