units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 7,117
- Recreation/Parks District 908
- State Agency 874
- County Agency 821
- Non Profit - Land Trust 406
- Federal Agency 360
- Open Space District 278
- County Agency - Parks 185
- Water District 172
- Community Services District 162
- Home Owners Association 158
- Non Profit - Conservation 117
- Flood District 81
- Irrigation District 35
- Non Profit - Other 32
- School District 32
- Cemetery District 29
- Port/Harbor District 24
- County Agency - Other 22
- Special District - Other 14
- Commercial 11
- Joint Powers Authority 7
- Sanitation District 6
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 1
- …
MNG_AGENCY >30
- California Department of Fish and Wildlife 343
- San Diego, City of 333
- Los Angeles, City of 327
- California Department of Parks and Recreation 311
- Mountains Recreation and Conservation Authority 210
- Sacramento, City of 178
- San Jose, City of 165
- San Francisco, City and County of 148
- East Bay Regional Park District 143
- Ventura, City of 119
- Los Angeles, County of 118
- Long Beach, City of 111
- Roseville, City of 101
- San Diego, County of 90
- Oakland, City of 87
- Consumnes Community Services District 86
- United States Bureau of Land Management 80
- United States Forest Service 74
- Orange, County of 71
- United States Fish and Wildlife Service 70
- California State Lands Commission 70
- Santa Barbara, County of 68
- Hayward Area Recreation and Park District 67
- Irvine, City of 65
- United States National Park Service 64
- Napa, City of 59
- Davis, City of 57
- Tracy, City of 57
- Stockton, City of 56
- Poway, City of 55
- …
DES_TP >30
- Local Park 6,221
- Local Recreation Area 1,549
- Local Other or Unknown 808
- Private Conservation 463
- Local Conservation Area 377
- State Conservation Area 322
- Private Recreation or Education 199
- State Park 176
- State Resource Management Area 116
- State Recreation Area 109
- National Forest 65
- National Wildlife Refuge 65
- Local Historic or Cultural Area 58
- State Historic or Cultural Area 56
- Recreation Management Area 46
- National Public Lands 43
- National Recreation Area 32
- National Monument or Landmark 28
- State Other or Unknown 27
- National Park 18
- Local Resource Management Area 15
- Resource Management Area 14
- Federal Other or Unknown 13
- Private Other or Unknown 13
- Conservation Area 11
- Private Agricultural 10
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 4
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 10,045
- Restricted Access 919
- No Public Access 694
- Unknown Access 224
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5187 | 5187 | 5186 | {"type": "MultiPolygon", "coordinates": [[[[-123.78065, 39.3808], [-123.77832, 39.38069], [-123.77834, 39.38249], [-123.77831, 39.3829], [-123.77605, 39.38242], [-123.77616, 39.38388], [-123.77492, 39.38378], [-123.77493, 39.38348], [-123.77385, 39.38345], [-123.77379, 39.38208], [-123.77504, 39.38217], [-123.77449, 39.38175], [-123.77435, 39.38146], [-123.77341, 39.38151], [-123.77329, 39.38204], [-123.7726, 39.3819], [-123.77135, 39.38189], [-123.77148, 39.37831], [-123.77176, 39.37302], [-123.77029, 39.37301], [-123.76991, 39.37268], [-123.76908, 39.37281], [-123.76908, 39.3727], [-123.76849, 39.37269], [-123.7685, 39.37249], [-123.7709, 39.37243], [-123.77173, 39.37243], [-123.77179, 39.3717], [-123.77179, 39.37116], [-123.7711, 39.37115], [-123.77107, 39.37183], [-123.77092, 39.37187], [-123.77047, 39.37181], [-123.7705, 39.37115], [-123.77044, 39.36946], [-123.77164, 39.36945], [-123.7718, 39.37116], [-123.7739, 39.37126], [-123.77637, 39.37143], [-123.77618, 39.37867], [-123.78058, 39.37891], [-123.78058, 39.38049], [-123.78065, 39.3808]]], [[[-123.78522, 39.36825], [-123.78083, 39.36804], [-123.78062, 39.36458], [-123.78503, 39.36474], [-123.78518, 39.3664], [-123.78522, 39.36825]]], [[[-123.82222, 39.38018], [-123.82212, 39.38021], [-123.82191, 39.3802], [-123.82189, 39.38023], [-123.82184, 39.38018], [-123.82176, 39.38017], [-123.8217, 39.38021], [-123.8217, 39.38027], [-123.82175, 39.38039], [-123.82172, 39.38045], [-123.82167, 39.3805], [-123.8216, 39.38052], [-123.82156, 39.38056], [-123.82153, 39.3807], [-123.82154, 39.38085], [-123.82142, 39.38099], [-123.82138, 39.38103], [-123.8213, 39.38102], [-123.82107, 39.38105], [-123.82083, 39.38102], [-123.8207, 39.38093], [-123.82059, 39.38095], [-123.82028, 39.3809], [-123.82014, 39.3809], [-123.82007, 39.38093], [-123.8201, 39.38119], [-123.82016, 39.38126], [-123.82022, 39.3814], [-123.82027, 39.38145], [-123.82051, 39.38159], [-123.82063, 39.3817], [-123.82069, 39.38201], [-123.82062, 39.38208], [-123.82054, 39.38211], [-123.82045, 39.38205], [-123.82035, 39.38204], [-123.8202, 39.38201], [-123.81993, 39.3819], [-123.81981, 39.38191], [-123.81974, 39.38197], [-123.81978, 39.38201], [-123.81973, 39.38202], [-123.81658, 39.381], [-123.81587, 39.3824], [-123.82026, 39.38364], [-123.82017, 39.38376], [-123.82017, 39.38409], [-123.82011, 39.38417], [-123.82005, 39.38423], [-123.81997, 39.38427], [-123.81986, 39.38429], [-123.81975, 39.38425], [-123.81971, 39.3843], [-123.81959, 39.38429], [-123.81955, 39.38431], [-123.81954, 39.38434], [-123.81961, 39.38441], [-123.81994, 39.38456], [-123.81997, 39.3846], [-123.81996, 39.38464], [-123.81991, 39.38467], [-123.81974, 39.38466], [-123.81962, 39.38468], [-123.81957, 39.38474], [-123.81967, 39.38491], [-123.81992, 39.3851], [-123.82001, 39.38515], [-123.82025, 39.38519], [-123.82031, 39.38524], [-123.82048, 39.38532], [-123.82054, 39.38543], [-123.8206, 39.38548], [-123.82065, 39.38561], [-123.82067, 39.38575], [-123.8208, 39.38592], [-123.82106, 39.38606], [-123.8211, 39.38611], [-123.82107, 39.38613], [-123.82099, 39.38613], [-123.82066, 39.38606], [-123.82062, 39.38606], [-123.82056, 39.38599], [-123.82046, 39.38593], [-123.82041, 39.38595], [-123.82042, 39.38603], [-123.82037, 39.38609], [-123.82031, 39.38611], [-123.82025, 39.3861], [-123.82022, 39.38612], [-123.82021, 39.38616], [-123.81972, 39.38601], [-123.81946, 39.38601], [-123.81944, 39.38606], [-123.81946, 39.38612], [-123.81942, 39.38613], [-123.81941, 39.38617], [-123.81922, 39.38617], [-123.81911, 39.38613], [-123.81905, 39.38616], [-123.81897, 39.38613], [-123.81892, 39.38615], [-123.81877, 39.3864], [-123.81871, 39.38645], [-123.81861, 39.38648], [-123.81856, 39.38652], [-123.81821, 39.38645], [-123.81804, 39.387], [-123.81693, 39.38671], [-123.81705, 39.38638], [-123.81721, 39.38603], [-123.8173, 39.38579], [-123.8154, 39.38534], [-123.81369, 39.3849], [-123.81385, 39.38445], [-123.81401, 39.38441], [-123.81404, 39.38434], [-123.81395, 39.38423], [-123.81413, 39.38376], [-123.81419, 39.38349], [-123.81457, 39.38328], [-123.81423, 39.38314], [-123.8144, 39.3825], [-123.81462, 39.38208], [-123.81507, 39.38048], [-123.81532, 39.37975], [-123.81049, 39.37932], [-123.80851, 39.37919], [-123.80842, 39.37843], [-123.80765, 39.37834], [-123.80764, 39.37835], [-123.80766, 39.37911], [-123.80765, 39.3793], [-123.80512, 39.37927], [-123.80129, 39.37935], [-123.80195, 39.37728], [-123.8022, 39.37663], [-123.80263, 39.37588], [-123.80262, 39.37587], [-123.7997, 39.37583], [-123.79574, 39.37582], [-123.7934, 39.37584], [-123.79342, 39.37678], [-123.793, 39.37681], [-123.79288, 39.37814], [-123.79274, 39.37938], [-123.78995, 39.3794], [-123.79005, 39.37491], [-123.79014, 39.37216], [-123.78978, 39.36677], [-123.7901, 39.36659], [-123.79037, 39.36689], [-123.79075, 39.3671], [-123.79108, 39.3671], [-123.79121, 39.36746], [-123.79148, 39.3677], [-123.79197, 39.36776], [-123.79206, 39.36771], [-123.79211, 39.36761], [-123.79208, 39.36845], [-123.79368, 39.36849], [-123.79929, 39.3685], [-123.79904, 39.36984], [-123.79907, 39.37224], [-123.80504, 39.37231], [-123.80784, 39.37232], [-123.80775, 39.37441], [-123.80928, 39.37459], [-123.8102, 39.37429], [-123.81113, 39.37496], [-123.81217, 39.37536], [-123.8159, 39.37529], [-123.81591, 39.37586], [-123.81634, 39.37586], [-123.81634, 39.37529], [-123.81628, 39.37495], [-123.81627, 39.37449], [-123.81616, 39.37393], [-123.81544, 39.37237], [-123.81521, 39.37202], [-123.81598, 39.37205], [-123.81641, 39.37218], [-123.81668, 39.37219], [-123.81692, 39.3723], [-123.81606, 39.37224], [-123.81551, 39.37222], [-123.8155, 39.37223], [-123.81555, 39.37237], [-123.81707, 39.37248], [-123.81722, 39.37302], [-123.81794, 39.37356], [-123.81807, 39.3735], [-123.81836, 39.37356], [-123.81856, 39.37356], [-123.8188, 39.37351], [-123.81904, 39.37348], [-123.81904, 39.37361], [-123.81931, 39.37367], [-123.81949, 39.37377], [-123.81966, 39.37377], [-123.81996, 39.37395], [-123.82016, 39.37393], [-123.82012, 39.3741], [-123.82016, 39.37425], [-123.82016, 39.37435], [-123.8202, 39.37446], [-123.82028, 39.37453], [-123.82057, 39.3747], [-123.82064, 39.37489], [-123.82085, 39.37498], [-123.82099, 39.37508], [-123.82113, 39.37508], [-123.82126, 39.37512], [-123.82135, 39.37509], [-123.8214, 39.37514], [-123.82164, 39.37525], [-123.82174, 39.37536], [-123.82188, 39.37559], [-123.82211, 39.37578], [-123.82217, 39.37585], [-123.8222, 39.37595], [-123.822, 39.37594], [-123.82184, 39.37585], [-123.82181, 39.37579], [-123.82171, 39.37576], [-123.82167, 39.37572], [-123.82149, 39.37574], [-123.82142, 39.37579], [-123.82133, 39.37579], [-123.82117, 39.37576], [-123.82104, 39.37568], [-123.82085, 39.37561], [-123.82058, 39.37562], [-123.8202, 39.3757], [-123.82017, 39.37572], [-123.82001, 39.37575], [-123.81996, 39.37577], [-123.81978, 39.37596], [-123.81975, 39.37616], [-123.81978, 39.37629], [-123.81956, 39.37643], [-123.81942, 39.37642], [-123.81904, 39.37643], [-123.81883, 39.37648], [-123.81857, 39.37646], [-123.81843, 39.37653], [-123.81835, 39.37663], [-123.81829, 39.37676], [-123.81828, 39.37703], [-123.81814, 39.37704], [-123.818, 39.37704], [-123.8178, 39.37693], [-123.8177, 39.37684], [-123.81751, 39.37679], [-123.81745, 39.37675], [-123.81738, 39.37673], [-123.81729, 39.37673], [-123.81726, 39.37683], [-123.81731, 39.3769], [-123.8174, 39.37693], [-123.8175, 39.37702], [-123.81778, 39.37716], [-123.81788, 39.37725], [-123.8181, 39.37736], [-123.81834, 39.37743], [-123.81881, 39.37739], [-123.81899, 39.37734], [-123.8191, 39.37736], [-123.81915, 39.37745], [-123.81915, 39.37749], [-123.81909, 39.37758], [-123.81891, 39.37795], [-123.81887, 39.378], [-123.81887, 39.37818], [-123.81891, 39.37827], [-123.81901, 39.37833], [-123.81906, 39.37835], [-123.81912, 39.37839], [-123.81924, 39.37843], [-123.81934, 39.3785], [-123.81953, 39.3787], [-123.81972, 39.37868], [-123.8198, 39.37874], [-123.81989, 39.37878], [-123.81998, 39.37874], [-123.82007, 39.37863], [-123.82018, 39.37854], [-123.82028, 39.37848], [-123.82055, 39.37842], [-123.82063, 39.37844], [-123.82073, 39.37852], [-123.82084, 39.37857], [-123.82089, 39.37864], [-123.82091, 39.37871], [-123.82091, 39.37878], [-123.82087, 39.37886], [-123.82073, 39.37895], [-123.82073, 39.37902], [-123.82098, 39.37909], [-123.8211, 39.37915], [-123.82116, 39.37922], [-123.82124, 39.37924], [-123.82131, 39.37921], [-123.82137, 39.37915], [-123.82152, 39.37912], [-123.82159, 39.37912], [-123.82175, 39.37919], [-123.82179, 39.37942], [-123.82194, 39.37947], [-123.82195, 39.37951], [-123.8219, 39.3796], [-123.82195, 39.37964], [-123.82201, 39.3796], [-123.82206, 39.37961], [-123.82208, 39.37963], [-123.82204, 39.3797], [-123.82217, 39.37977], [-123.82224, 39.37988], [-123.82226, 39.38], [-123.82222, 39.38018]], [[-123.81623, 39.37681], [-123.81622, 39.37679], [-123.8159, 39.37673], [-123.81589, 39.37674], [-123.81619, 39.37691], [-123.81623, 39.37681]]], [[[-123.82052, 39.39172], [-123.82045, 39.39178], [-123.82028, 39.3918], [-123.82016, 39.39179], [-123.82009, 39.39175], [-123.82002, 39.39174], [-123.81994, 39.39173], [-123.81989, 39.39177], [-123.81972, 39.39177], [-123.81961, 39.39183], [-123.81959, 39.39188], [-123.8196, 39.392], [-123.81955, 39.392], [-123.81931, 39.39194], [-123.81925, 39.39189], [-123.81917, 39.39186], [-123.81908, 39.39176], [-123.81863, 39.39154], [-123.81617, 39.39123], [-123.81538, 39.39114], [-123.81536, 39.39012], [-123.81537, 39.38977], [-123.81505, 39.38928], [-123.81274, 39.38894], [-123.81262, 39.38863], [-123.81319, 39.38871], [-123.8131, 39.38815], [-123.81315, 39.38787], [-123.81369, 39.38684], [-123.81403, 39.38685], [-123.81427, 39.38687], [-123.81445, 39.38694], [-123.81476, 39.38688], [-123.81494, 39.3869], [-123.81506, 39.38694], [-123.81522, 39.38693], [-123.81542, 39.38697], [-123.81581, 39.38712], [-123.81609, 39.38738], [-123.81657, 39.3875], [-123.81684, 39.38746], [-123.81701, 39.38749], [-123.81737, 39.3877], [-123.81736, 39.38773], [-123.81738, 39.38778], [-123.81743, 39.38787], [-123.81749, 39.38805], [-123.81754, 39.3881], [-123.81769, 39.3884], [-123.8178, 39.38857], [-123.81791, 39.38867], [-123.81801, 39.38873], [-123.8181, 39.38883], [-123.81821, 39.38885], [-123.8183, 39.38884], [-123.81843, 39.3888], [-123.81849, 39.3888], [-123.81852, 39.3888], [-123.81863, 39.38889], [-123.81879, 39.3889], [-123.81903, 39.38896], [-123.81909, 39.38898], [-123.8192, 39.38907], [-123.8193, 39.38909], [-123.81938, 39.38914], [-123.81954, 39.38932], [-123.81956, 39.38936], [-123.81944, 39.38941], [-123.81925, 39.3894], [-123.81906, 39.38932], [-123.81894, 39.38929], [-123.81861, 39.38914], [-123.81824, 39.38907], [-123.81817, 39.38914], [-123.81818, 39.38919], [-123.81817, 39.38923], [-123.81822, 39.38928], [-123.81823, 39.38932], [-123.81817, 39.38943], [-123.81795, 39.38955], [-123.81792, 39.38965], [-123.81793, 39.38976], [-123.81801, 39.38987], [-123.81809, 39.38994], [-123.81824, 39.39], [-123.81829, 39.39007], [-123.81821, 39.39018], [-123.81823, 39.39025], [-123.81835, 39.39027], [-123.81846, 39.39039], [-123.81854, 39.39041], [-123.81859, 39.3903], [-123.81875, 39.39036], [-123.81891, 39.39039], [-123.81904, 39.39047], [-123.81922, 39.39055], [-123.81944, 39.39062], [-123.81949, 39.39078], [-123.8196, 39.39088], [-123.81967, 39.39099], [-123.81977, 39.3911], [-123.81993, 39.39116], [-123.82003, 39.39124], [-123.82018, 39.39137], [-123.82021, 39.39145], [-123.82027, 39.39156], [-123.82043, 39.39166], [-123.8205, 39.39168], [-123.82052, 39.39172]]], [[[-123.82051, 39.37236], [-123.82051, 39.37243], [-123.82027, 39.37255], [-123.82018, 39.37258], [-123.81884, 39.37196], [-123.81894, 39.37171], [-123.82051, 39.37236]]]]} | Open Access 1 | 20491 | Jug Handle State Natural Reserve | 31545 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=441 | Mendocino 24 | 775.877 | Jug Handle SNR | 1976 | State Conservation Area 8 | 2 |
5188 | 5188 | 5187 | {"type": "Polygon", "coordinates": [[[-117.20886, 32.88259], [-117.20836, 32.88274], [-117.20752, 32.8841], [-117.20734, 32.88338], [-117.20777, 32.88341], [-117.20787, 32.88338], [-117.20831, 32.88268], [-117.20884, 32.88253], [-117.20886, 32.88259]]]} | Open Access 1 | 46763 | East Gate Mini-Park #1 | 30214 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.815 | East Gate Mini-Park #1 | 0 | Local Park 2 | 4 | |
5189 | 5189 | 5188 | {"type": "Polygon", "coordinates": [[[-122.24846, 40.17789], [-122.24809, 40.17808], [-122.24765, 40.17757], [-122.24805, 40.17738], [-122.24846, 40.17789]]]} | Open Access 1 | 16457 | Carl Coleman Courts | 16850 | 1267 | Red Bluff, City of 493 | City 2 | City Agency 2 | http://www.cityofredbluff.org/citydepartments/parksandrecreation/ | City 2 | 1267 | Red Bluff, City of 484 | City 2 | City Agency 2 | Tehama 18 | 0.645 | Carl Coleman Courts | 0 | Local Recreation Area 3 | 4 | |
5190 | 5190 | 5189 | {"type": "Polygon", "coordinates": [[[-116.9854, 32.75274], [-116.98539, 32.75383], [-116.98392, 32.75381], [-116.98395, 32.75166], [-116.98499, 32.75167], [-116.98497, 32.75273], [-116.9854, 32.75274]]]} | Open Access 1 | 4996 | Estrella Park | 29276 | 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 | 6.925 | Estrella Park | 0 | Local Park 2 | 4 | |
5191 | 5191 | 5190 | {"type": "Polygon", "coordinates": [[[-121.6856, 37.93691], [-121.6856, 37.93746], [-121.68543, 37.93746], [-121.68543, 37.93691], [-121.6856, 37.93691]]]} | Open Access 1 | 47953 | Sawyer Pocket Park | 32123 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 0.225 | Sawyer PP | 0 | Local Park 2 | 4 | |
5192 | 5192 | 5191 | {"type": "Polygon", "coordinates": [[[-117.94549, 33.87542], [-117.94548, 33.8764], [-117.94546, 33.87698], [-117.94376, 33.87684], [-117.94367, 33.87682], [-117.94362, 33.87677], [-117.94347, 33.87634], [-117.9434, 33.87595], [-117.94312, 33.8753], [-117.94359, 33.8752], [-117.94542, 33.87532], [-117.94545, 33.87534], [-117.94546, 33.87542], [-117.94549, 33.87542]]]} | Open Access 1 | 5550 | Muckenthaler Cultural Center | 22582 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 8.615 | Muckenthaler Cultural Ctr. | 0 | Local Recreation Area 3 | 4 | |
5193 | 5193 | 5192 | {"type": "Polygon", "coordinates": [[[-122.42275, 37.64511], [-122.42239, 37.64563], [-122.42222, 37.64588], [-122.42208, 37.64571], [-122.4227, 37.64509], [-122.42275, 37.64511]]]} | Open Access 1 | 15578 | Francisco Terrace Playlot | 19046 | 1341 | South San Francisco, City of 60 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | San Mateo 15 | 0.301 | Francisco Terrace Playlot | 0 | Local Recreation Area 3 | 4 | |
5194 | 5194 | 5193 | {"type": "Polygon", "coordinates": [[[-122.40018, 37.66434], [-122.40011, 37.66463], [-122.39923, 37.66446], [-122.39958, 37.66423], [-122.40018, 37.66434]]]} | Open Access 1 | 15580 | Gardiner Lot | 19209 | 1341 | South San Francisco, City of 60 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | San Mateo 15 | 0.528 | Gardiner Lot | 0 | Local Other or Unknown 14 | 4 | |
5195 | 5195 | 5194 | {"type": "Polygon", "coordinates": [[[-122.42524, 37.66988], [-122.4246, 37.67055], [-122.42363, 37.67039], [-122.42299, 37.6698], [-122.42258, 37.6689], [-122.42434, 37.66836], [-122.42454, 37.6687], [-122.42436, 37.66885], [-122.42524, 37.66988]]]} | Open Access 1 | 15582 | Hillside Athletic Field | 19979 | 1341 | South San Francisco, City of 60 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | San Mateo 15 | 8.293 | Hillside Athletic Field | 0 | Local Recreation Area 3 | 4 | |
5196 | 5196 | 5195 | {"type": "Polygon", "coordinates": [[[-121.44705, 37.7373], [-121.44705, 37.73738], [-121.44679, 37.73756], [-121.44636, 37.73713], [-121.44658, 37.73699], [-121.44668, 37.73699], [-121.44705, 37.7373]]]} | Open Access 1 | 24737 | Patzer Park | 23527 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.498 | Patzer Park | 0 | Local Park 2 | 4 | |
5197 | 5197 | 5196 | {"type": "Polygon", "coordinates": [[[-118.41586, 33.93121], [-118.41479, 33.93127], [-118.41119, 33.93127], [-118.41118, 33.93095], [-118.41483, 33.93094], [-118.41583, 33.931], [-118.41586, 33.93121]]]} | Open Access 1 | 6163 | Clutter's Park | 17448 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 3.69 | Clutter's Park | 0 | Local Park 2 | 4 | |
5198 | 5198 | 5197 | {"type": "Polygon", "coordinates": [[[-118.31567, 33.89103], [-118.31566, 33.89157], [-118.31476, 33.89157], [-118.31476, 33.89035], [-118.31559, 33.89035], [-118.31559, 33.89094], [-118.31562, 33.89095], [-118.31563, 33.89103], [-118.31567, 33.89103]]]} | Open Access 1 | 6046 | Freeman Park | 19091 | 1117 | Gardena, City of 297 | City 2 | City Agency 2 | http://www.ci.gardena.ca.us/ | City 2 | 1117 | Gardena, City of 293 | City 2 | City Agency 2 | Los Angeles 6 | 2.702 | Freeman Park | 0 | Local Park 2 | 4 | |
5199 | 5199 | 5198 | {"type": "Polygon", "coordinates": [[[-117.65837, 33.63225], [-117.65835, 33.63227], [-117.65821, 33.63231], [-117.65795, 33.63233], [-117.65783, 33.63242], [-117.65752, 33.63232], [-117.65735, 33.63233], [-117.65733, 33.63239], [-117.65718, 33.63239], [-117.65721, 33.63178], [-117.65731, 33.63152], [-117.6573, 33.63142], [-117.65727, 33.63131], [-117.65719, 33.63111], [-117.65714, 33.63103], [-117.65827, 33.63102], [-117.65825, 33.63123], [-117.65826, 33.63171], [-117.65832, 33.63204], [-117.65838, 33.6322], [-117.65837, 33.63225]]]} | Open Access 1 | 24600 | Barcelona Park | 15811 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 3.579 | Barcelona Park | 0 | Local Park 2 | 4 | |
5200 | 5200 | 5199 | {"type": "MultiPolygon", "coordinates": [[[[-117.67339, 33.63513], [-117.67274, 33.63562], [-117.67252, 33.63583], [-117.67227, 33.63618], [-117.67222, 33.63633], [-117.67221, 33.63656], [-117.67246, 33.63654], [-117.67268, 33.63669], [-117.67244, 33.63722], [-117.6725, 33.63728], [-117.67219, 33.6375], [-117.67205, 33.63786], [-117.67164, 33.63811], [-117.67151, 33.63824], [-117.67119, 33.63911], [-117.67077, 33.63963], [-117.67087, 33.6397], [-117.67099, 33.6397], [-117.67073, 33.63992], [-117.67073, 33.63982], [-117.67051, 33.63964], [-117.67033, 33.63966], [-117.66992, 33.64057], [-117.66954, 33.64096], [-117.66945, 33.64111], [-117.66885, 33.64158], [-117.66848, 33.64251], [-117.66832, 33.64266], [-117.66798, 33.64287], [-117.66827, 33.64325], [-117.66818, 33.64358], [-117.66789, 33.64361], [-117.66762, 33.64368], [-117.66672, 33.64404], [-117.66673, 33.64407], [-117.66671, 33.64409], [-117.66663, 33.64436], [-117.66654, 33.64454], [-117.66653, 33.64478], [-117.66671, 33.64513], [-117.66644, 33.64529], [-117.66621, 33.6455], [-117.66576, 33.64614], [-117.66609, 33.64631], [-117.66561, 33.64698], [-117.66528, 33.64684], [-117.665, 33.64719], [-117.6645, 33.64762], [-117.6641, 33.64793], [-117.66394, 33.64812], [-117.66366, 33.64852], [-117.66336, 33.64919], [-117.66328, 33.64947], [-117.66326, 33.64975], [-117.66333, 33.65004], [-117.66269, 33.6505], [-117.66179, 33.65181], [-117.66136, 33.65233], [-117.66137, 33.65234], [-117.66167, 33.65252], [-117.66134, 33.6529], [-117.66134, 33.65292], [-117.66102, 33.65276], [-117.66085, 33.65298], [-117.66065, 33.65342], [-117.66055, 33.65389], [-117.66055, 33.65437], [-117.66061, 33.6548], [-117.66, 33.65484], [-117.65976, 33.65482], [-117.65968, 33.65519], [-117.65928, 33.65561], [-117.65938, 33.65626], [-117.65867, 33.65672], [-117.65831, 33.6571], [-117.65831, 33.65768], [-117.65798, 33.65901], [-117.6576, 33.65927], [-117.65734, 33.65879], [-117.65697, 33.65874], [-117.657, 33.65856], [-117.6572, 33.65837], [-117.65731, 33.65822], [-117.65742, 33.65803], [-117.65754, 33.65771], [-117.65792, 33.65713], [-117.65795, 33.65704], [-117.65875, 33.65555], [-117.65935, 33.65425], [-117.6601, 33.65256], [-117.66033, 33.65196], [-117.66043, 33.65158], [-117.66057, 33.65085], [-117.66076, 33.65005], [-117.66086, 33.64976], [-117.66102, 33.64943], [-117.66128, 33.64905], [-117.66152, 33.64873], [-117.66183, 33.6484], [-117.66393, 33.64652], [-117.66437, 33.64608], [-117.66523, 33.64506], [-117.66547, 33.64484], [-117.66577, 33.64461], [-117.66577, 33.64459], [-117.66548, 33.64438], [-117.66545, 33.64438], [-117.66567, 33.6442], [-117.66566, 33.64374], [-117.66572, 33.64358], [-117.66587, 33.64342], [-117.66625, 33.6431], [-117.6666, 33.64292], [-117.66687, 33.64298], [-117.66717, 33.64284], [-117.66729, 33.64269], [-117.66785, 33.64256], [-117.66798, 33.64247], [-117.66821, 33.64209], [-117.66812, 33.64196], [-117.66796, 33.64192], [-117.66805, 33.64171], [-117.66802, 33.64162], [-117.66807, 33.64159], [-117.66811, 33.64152], [-117.66814, 33.64135], [-117.66831, 33.64116], [-117.66842, 33.6411], [-117.66876, 33.64094], [-117.66886, 33.64086], [-117.66935, 33.64026], [-117.66943, 33.64], [-117.66943, 33.6396], [-117.6695, 33.63936], [-117.66957, 33.63925], [-117.66977, 33.63906], [-117.66982, 33.63904], [-117.66988, 33.63904], [-117.67001, 33.63894], [-117.67, 33.63892], [-117.66998, 33.63894], [-117.66997, 33.63892], [-117.66999, 33.63889], [-117.67037, 33.63855], [-117.67046, 33.63843], [-117.67051, 33.63831], [-117.67053, 33.63818], [-117.67052, 33.63791], [-117.67054, 33.6378], [-117.67058, 33.6377], [-117.67066, 33.63759], [-117.67085, 33.6374], [-117.67092, 33.63729], [-117.671, 33.6371], [-117.67106, 33.63699], [-117.6712, 33.63685], [-117.67138, 33.63672], [-117.67148, 33.63663], [-117.67155, 33.63652], [-117.67161, 33.63639], [-117.67164, 33.63626], [-117.67164, 33.63614], [-117.67158, 33.63589], [-117.67158, 33.63579], [-117.67161, 33.63567], [-117.67173, 33.63547], [-117.67182, 33.63538], [-117.67193, 33.63531], [-117.67206, 33.63526], [-117.67235, 33.63519], [-117.6725, 33.63512], [-117.67257, 33.63507], [-117.6726, 33.635], [-117.67261, 33.63493], [-117.6726, 33.63486], [-117.67254, 33.63481], [-117.67278, 33.63461], [-117.67339, 33.63513]]], [[[-117.65995, 33.65983], [-117.65924, 33.66003], [-117.65848, 33.66011], [-117.65819, 33.66003], [-117.65767, 33.65947], [-117.65796, 33.65928], [-117.65824, 33.65925], [-117.65828, 33.65934], [-117.65852, 33.65956], [-117.65987, 33.65959], [-117.65995, 33.65983]]], [[[-117.65959, 33.65875], [-117.65959, 33.65888], [-117.65889, 33.65885], [-117.65891, 33.65877], [-117.65895, 33.65874], [-117.65959, 33.65875]]], [[[-117.68678, 33.6252], [-117.68659, 33.62536], [-117.68659, 33.62543], [-117.68657, 33.62543], [-117.6865, 33.62548], [-117.68648, 33.62556], [-117.68633, 33.62556], [-117.68596, 33.62587], [-117.68596, 33.62595], [-117.68587, 33.62599], [-117.68582, 33.62606], [-117.68573, 33.62605], [-117.68526, 33.62643], [-117.68532, 33.62649], [-117.6852, 33.62658], [-117.6852, 33.62666], [-117.68522, 33.6267], [-117.68503, 33.62686], [-117.68514, 33.62696], [-117.68497, 33.62711], [-117.68497, 33.62718], [-117.68491, 33.62718], [-117.68483, 33.62723], [-117.68481, 33.62727], [-117.68481, 33.62734], [-117.68486, 33.6274], [-117.68446, 33.62773], [-117.68449, 33.62782], [-117.6844, 33.62787], [-117.68438, 33.62792], [-117.68439, 33.628], [-117.68436, 33.62801], [-117.68428, 33.62816], [-117.68412, 33.62838], [-117.68425, 33.62864], [-117.68444, 33.62881], [-117.6843, 33.62881], [-117.68415, 33.62878], [-117.68372, 33.62864], [-117.6836, 33.62862], [-117.68339, 33.62862], [-117.68323, 33.62865], [-117.68151, 33.62911], [-117.68136, 33.62913], [-117.68106, 33.62924], [-117.67999, 33.63011], [-117.67993, 33.63022], [-117.67988, 33.63034], [-117.67987, 33.63061], [-117.67992, 33.63077], [-117.68004, 33.63097], [-117.67952, 33.63048], [-117.67922, 33.63072], [-117.67927, 33.6308], [-117.67924, 33.63082], [-117.67922, 33.63086], [-117.67908, 33.63084], [-117.67885, 33.63102], [-117.67886, 33.63105], [-117.67863, 33.63124], [-117.67868, 33.63134], [-117.67862, 33.63138], [-117.67861, 33.63143], [-117.67849, 33.63141], [-117.67825, 33.63159], [-117.67834, 33.63168], [-117.67811, 33.63188], [-117.67811, 33.63192], [-117.67802, 33.63196], [-117.678, 33.63201], [-117.67792, 33.632], [-117.67767, 33.63219], [-117.6777, 33.63223], [-117.67752, 33.6324], [-117.67757, 33.63256], [-117.67752, 33.63258], [-117.67747, 33.63264], [-117.67747, 33.63268], [-117.67753, 33.63274], [-117.67752, 33.63277], [-117.67754, 33.63279], [-117.67746, 33.63292], [-117.67756, 33.63303], [-117.67736, 33.63326], [-117.67738, 33.63333], [-117.67733, 33.63335], [-117.67728, 33.63341], [-117.67728, 33.63347], [-117.67732, 33.63351], [-117.67726, 33.63356], [-117.67694, 33.63395], [-117.67628, 33.63376], [-117.67616, 33.63382], [-117.67608, 33.63378], [-117.67598, 33.63378], [-117.6759, 33.63385], [-117.6758, 33.63381], [-117.67533, 33.63387], [-117.67534, 33.63383], [-117.67638, 33.633], [-117.67634, 33.63293], [-117.67668, 33.63278], [-117.67654, 33.63259], [-117.67676, 33.63247], [-117.67682, 33.63237], [-117.67692, 33.63222], [-117.67707, 33.63206], [-117.67732, 33.63185], [-117.67736, 33.63187], [-117.67755, 33.63172], [-117.67752, 33.63169], [-117.67758, 33.63163], [-117.67741, 33.6315], [-117.67752, 33.6313], [-117.67762, 33.631], [-117.67774, 33.63077], [-117.67784, 33.63066], [-117.67822, 33.63049], [-117.67843, 33.63045], [-117.67858, 33.63041], [-117.67873, 33.63033], [-117.67922, 33.62995], [-117.67936, 33.62983], [-117.67953, 33.62966], [-117.67974, 33.62941], [-117.67996, 33.6291], [-117.68007, 33.62885], [-117.68026, 33.62851], [-117.68036, 33.6284], [-117.68043, 33.6283], [-117.68046, 33.62814], [-117.68045, 33.62796], [-117.68041, 33.62781], [-117.68036, 33.62767], [-117.68023, 33.6275], [-117.68052, 33.62727], [-117.68196, 33.62851], [-117.68348, 33.62728], [-117.68366, 33.62698], [-117.68422, 33.62639], [-117.68449, 33.62599], [-117.68467, 33.62614], [-117.68476, 33.62613], [-117.68482, 33.62606], [-117.68492, 33.62614], [-117.6866, 33.62477], [-117.68678, 33.6252]]], [[[-117.68005, 33.63097], [-117.68008, 33.631], [-117.68008, 33.63101], [-117.68008, 33.63101], [-117.68005, 33.63097]]], [[[-117.6958, 33.61292], [-117.69566, 33.61315], [-117.69531, 33.6131], [-117.69534, 33.61303], [-117.69537, 33.61282], [-117.69535, 33.6126], [-117.69529, 33.6124], [-117.69517, 33.6122], [-117.695, 33.61203], [-117.69481, 33.61188], [-117.69458, 33.61178], [-117.69392, 33.61163], [-117.69373, 33.61158], [-117.69351, 33.61149], [-117.69334, 33.6114], [-117.6932, 33.61128], [-117.69295, 33.61101], [-117.69265, 33.61115], [-117.69293, 33.611], [-117.69283, 33.61082], [-117.69273, 33.61049], [-117.69274, 33.61034], [-117.69272, 33.60982], [-117.69276, 33.60956], [-117.69286, 33.60933], [-117.69371, 33.60809], [-117.69478, 33.60647], [-117.69406, 33.60611], [-117.69396, 33.60604], [-117.69397, 33.60564], [-117.69405, 33.6057], [-117.69417, 33.60568], [-117.6942, 33.60573], [-117.69427, 33.60577], [-117.69435, 33.60577], [-117.69441, 33.60573], [-117.69449, 33.60587], [-117.69489, 33.60609], [-117.69498, 33.60608], [-117.69501, 33.60616], [-117.69508, 33.6062], [-117.69518, 33.6062], [-117.6952, 33.60618], [-117.69553, 33.60618], [-117.69519, 33.60656], [-117.69537, 33.60666], [-117.6946, 33.60724], [-117.69315, 33.60938], [-117.69309, 33.60949], [-117.69303, 33.60965], [-117.69301, 33.60987], [-117.69302, 33.61041], [-117.69306, 33.61064], [-117.69316, 33.61084], [-117.6933, 33.61103], [-117.69349, 33.61119], [-117.6937, 33.61131], [-117.69395, 33.6114], [-117.69456, 33.61153], [-117.69472, 33.61159], [-117.69488, 33.61165], [-117.69503, 33.61174], [-117.69525, 33.6119], [-117.69539, 33.61206], [-117.69554, 33.61229], [-117.69562, 33.61252], [-117.69566, 33.61279], [-117.6958, 33.61292]]], [[[-117.69774, 33.60765], [-117.6977, 33.60775], [-117.69716, 33.60756], [-117.69725, 33.60735], [-117.69747, 33.6071], [-117.6976, 33.60676], [-117.69762, 33.60675], [-117.69765, 33.60675], [-117.69772, 33.60697], [-117.69768, 33.60698], [-117.69764, 33.60702], [-117.69761, 33.60709], [-117.69752, 33.60709], [-117.6973, 33.60734], [-117.69774, 33.60765]]], [[[-117.70033, 33.60529], [-117.6999, 33.60538], [-117.69965, 33.60541], [-117.69945, 33.60555], [-117.69944, 33.60551], [-117.69969, 33.60533], [-117.69981, 33.6053], [-117.69995, 33.60531], [-117.69999, 33.6053], [-117.70005, 33.60525], [-117.70006, 33.60516], [-117.70033, 33.60529]]], [[[-117.71085, 33.59544], [-117.71082, 33.59549], [-117.71058, 33.59556], [-117.71037, 33.59593], [-117.71035, 33.59601], [-117.71028, 33.5976], [-117.71024, 33.59776], [-117.71014, 33.59793], [-117.70997, 33.5981], [-117.70937, 33.5984], [-117.70891, 33.5987], [-117.70874, 33.59888], [-117.70816, 33.59962], [-117.70764, 33.60037], [-117.70749, 33.60051], [-117.70706, 33.60056], [-117.70696, 33.6006], [-117.70696, 33.60061], [-117.70704, 33.60069], [-117.70466, 33.60241], [-117.70299, 33.60304], [-117.70259, 33.60311], [-117.70246, 33.60262], [-117.70286, 33.60255], [-117.70332, 33.60226], [-117.70443, 33.60183], [-117.70473, 33.60156], [-117.70501, 33.6009], [-117.70616, 33.60032], [-117.70682, 33.60018], [-117.70777, 33.59954], [-117.70807, 33.59917], [-117.70852, 33.59842], [-117.70868, 33.5984], [-117.70907, 33.59813], [-117.70966, 33.59784], [-117.70974, 33.59778], [-117.70981, 33.59767], [-117.70985, 33.59756], [-117.70993, 33.59575], [-117.71015, 33.59517], [-117.71085, 33.59544]]]]} | Open Access 1 | 15865 | Aliso Creek Greenbelt | 15372 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 138.055 | Aliso Creek Greenbelt | 0 | Local Recreation Area 3 | 4 | |
5201 | 5201 | 5200 | {"type": "Polygon", "coordinates": [[[-121.46404, 37.74007], [-121.46402, 37.7402], [-121.46398, 37.74035], [-121.4638, 37.74082], [-121.46369, 37.74103], [-121.46354, 37.74122], [-121.46326, 37.74106], [-121.46298, 37.74106], [-121.46297, 37.74002], [-121.46397, 37.74002], [-121.46404, 37.74007]]]} | Open Access 1 | 24745 | Daniel Busch Park | 17919 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 2.397 | Daniel Busch Park | 0 | Local Park 2 | 4 | |
5202 | 5202 | 5201 | {"type": "Polygon", "coordinates": [[[-121.73096, 37.96109], [-121.73096, 37.9614], [-121.73047, 37.9614], [-121.73066, 37.9611], [-121.73074, 37.96112], [-121.73086, 37.96109], [-121.73096, 37.96109]]]} | Open Access 1 | 47924 | Amber Park | 32051 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 0.281 | Amber Park | 0 | Local Park 2 | 4 | |
5203 | 5203 | 5202 | {"type": "Polygon", "coordinates": [[[-122.41064, 37.79593], [-122.4101, 37.796], [-122.41003, 37.79567], [-122.41042, 37.79562], [-122.41045, 37.79578], [-122.41061, 37.79577], [-122.41064, 37.79593]]]} | Open Access 1 | 6373 | Woh Hei Yuen Park | 27668 | 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 Francisco 13 | 0.387 | Woh Hei Yuen Park | 0 | Local Park 2 | 4 | |
5204 | 5204 | 5203 | {"type": "Polygon", "coordinates": [[[-121.44241, 37.7118], [-121.44234, 37.71184], [-121.44231, 37.71192], [-121.44216, 37.71192], [-121.44215, 37.71185], [-121.44207, 37.71179], [-121.44207, 37.71125], [-121.44241, 37.71124], [-121.44241, 37.7118]]]} | Open Access 1 | 24746 | Westside Pioneer | 27430 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.516 | Westside Pioneer | None 421 | |||
5205 | 5205 | 5204 | {"type": "Polygon", "coordinates": [[[-117.77667, 34.12738], [-117.77663, 34.12742], [-117.77636, 34.12743], [-117.77637, 34.12718], [-117.77666, 34.12718], [-117.77667, 34.12738]]]} | Open Access 1 | 12355 | La Verne City Parkland | 20812 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 0.181 | La Verne City Parkland | 0 | Local Park 2 | 4 | |
5206 | 5206 | 5205 | {"type": "Polygon", "coordinates": [[[-122.02374, 37.59788], [-122.02349, 37.59807], [-122.02325, 37.59787], [-122.02351, 37.59768], [-122.02374, 37.59788]]]} | Open Access 1 | 12669 | Fred Castro Park | 19073 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.232 | Fred Castro Park | 0 | 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]);