units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER
MNG_AGENCY >30
- San Diego, City of 211
- Los Angeles, City of 116
- San Francisco, City and County of 80
- Mountains Recreation and Conservation Authority 58
- Los Angeles, County of 31
- Conejo Open Space Conservation Agency 29
- East Bay Regional Park District 28
- Las Virgenes Municipal Water District 28
- San Luis Obispo, City of 26
- Long Beach, City of 25
- Glendale, City of 24
- Davis, City of 23
- Santa Barbara, County of 19
- Santa Clarita, City of 18
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Los Angeles - Department of Parks and Recreation, County of 15
- Santa Cruz, City of 14
- Conejo Recreation and Park District 14
- San Bernardino, City of 14
- San Marcos, City of 14
- East Bay Municipal Utility District 13
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Sunrise Recreation and Park District 12
- …
MNG_AG_TYP 17
- City Agency 1,440
- Recreation/Parks District 164
- County Agency 117
- Open Space District 88
- Water District 69
- County Agency - Parks 37
- Irrigation District 23
- Community Services District 14
- Flood District 12
- Port/Harbor District 5
- School District 5
- County Agency - Other 4
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,640
- Restricted Access 220
- No Public Access 113
- Unknown Access 16
MNG_AG_LEV 3 ✖
- City 1,440
- Special District 391
- County 158
DES_TP 1
- Local Recreation Area · 1,989 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17061 | 17061 | 17060 | {"type": "Polygon", "coordinates": [[[-118.18962, 34.14217], [-118.18947, 34.14226], [-118.18929, 34.14243], [-118.18907, 34.14278], [-118.18904, 34.1429], [-118.18898, 34.14331], [-118.1889, 34.14346], [-118.18882, 34.14354], [-118.18874, 34.14359], [-118.18865, 34.14363], [-118.1885, 34.14366], [-118.18835, 34.14366], [-118.1882, 34.14362], [-118.18745, 34.14325], [-118.18624, 34.14242], [-118.18638, 34.1418], [-118.18647, 34.14153], [-118.18666, 34.14107], [-118.18684, 34.14075], [-118.18737, 34.14048], [-118.1888, 34.13965], [-118.18904, 34.14048], [-118.18919, 34.14068], [-118.18922, 34.14076], [-118.18929, 34.14098], [-118.18929, 34.1411], [-118.18962, 34.14217]]]} | Open Access 1 | 6962 | Eagle Rock Recreation Center | 18347 | 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 | 21.266 | Eagle Rock Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17060 | 17060 | 17059 | {"type": "Polygon", "coordinates": [[[-118.52603, 34.04074], [-118.52584, 34.04176], [-118.52566, 34.04209], [-118.52555, 34.04307], [-118.52552, 34.04343], [-118.52529, 34.04459], [-118.5251, 34.0447], [-118.52499, 34.04446], [-118.52465, 34.04399], [-118.52427, 34.04367], [-118.52438, 34.04357], [-118.52439, 34.04346], [-118.52438, 34.04335], [-118.52369, 34.04267], [-118.52353, 34.04227], [-118.52351, 34.04195], [-118.52352, 34.04162], [-118.52354, 34.04145], [-118.52382, 34.041], [-118.52333, 34.04086], [-118.52344, 34.04061], [-118.52411, 34.04083], [-118.52413, 34.04044], [-118.52444, 34.04055], [-118.52447, 34.03997], [-118.52501, 34.04047], [-118.52589, 34.04059], [-118.52603, 34.04074]]]} | Open Access 1 | 6339 | Palisades Park & Recreation Center | 28791 | 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 | http://www.laparks.org/dos/reccenter/facility/palisadesRC.htm | Los Angeles 6 | 17.543 | Palisades Park & Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
17059 | 17059 | 17058 | {"type": "Polygon", "coordinates": [[[-118.35534, 34.01483], [-118.35527, 34.01483], [-118.35522, 34.01487], [-118.35483, 34.01488], [-118.35482, 34.01478], [-118.35463, 34.01478], [-118.35462, 34.01481], [-118.35459, 34.01483], [-118.35418, 34.01483], [-118.35415, 34.01324], [-118.35422, 34.01321], [-118.35422, 34.01315], [-118.35369, 34.01306], [-118.35267, 34.01268], [-118.35262, 34.01267], [-118.35244, 34.0126], [-118.35201, 34.01244], [-118.35155, 34.01232], [-118.35169, 34.01201], [-118.35174, 34.01198], [-118.35177, 34.01183], [-118.35143, 34.01178], [-118.35119, 34.01176], [-118.35042, 34.01179], [-118.35038, 34.01174], [-118.3502, 34.01174], [-118.35017, 34.01178], [-118.35006, 34.01178], [-118.34966, 34.01171], [-118.34938, 34.01163], [-118.35013, 34.01064], [-118.35019, 34.01064], [-118.35049, 34.01087], [-118.3512, 34.01124], [-118.3514, 34.01131], [-118.35213, 34.01149], [-118.35392, 34.01216], [-118.35418, 34.01222], [-118.35444, 34.01226], [-118.35519, 34.01226], [-118.35525, 34.0123], [-118.35533, 34.01232], [-118.3553, 34.01258], [-118.35534, 34.01483]]]} | Open Access 1 | 6302 | Jim Gilliam Recreation Center | 20411 | 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 | 17.629 | Jim Gilliam Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17057 | 17057 | 17056 | {"type": "Polygon", "coordinates": [[[-118.23285, 33.93139], [-118.23204, 33.93139], [-118.23201, 33.93135], [-118.2318, 33.93037], [-118.23285, 33.93037], [-118.23285, 33.93139]]]} | Open Access 1 | 6228 | Imperial Courts Recreation Center | 20179 | 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 | 2.43 | Imperial Courts Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17056 | 17056 | 17055 | {"type": "Polygon", "coordinates": [[[-118.24936, 33.93257], [-118.24848, 33.93258], [-118.24841, 33.93254], [-118.24704, 33.93254], [-118.24703, 33.93182], [-118.24935, 33.9318], [-118.24936, 33.93257]]]} | Open Access 1 | 6226 | William Nickerson Recreation Center | 27554 | 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 | 4.333 | William Nickerson Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17055 | 17055 | 17054 | {"type": "Polygon", "coordinates": [[[-118.29152, 33.89445], [-118.29149, 33.89458], [-118.29148, 33.89678], [-118.29142, 33.89681], [-118.2911, 33.8968], [-118.29028, 33.89676], [-118.29007, 33.89672], [-118.28974, 33.89662], [-118.28931, 33.8964], [-118.28932, 33.8956], [-118.28934, 33.89554], [-118.28932, 33.89551], [-118.28926, 33.89547], [-118.28927, 33.89517], [-118.29152, 33.89445]]]} | Open Access 1 | 6202 | Rosecrans Recreation Center | 24617 | 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 | 10.51 | Rosecrans Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17054 | 17054 | 17053 | {"type": "Polygon", "coordinates": [[[-118.32102, 33.73089], [-118.32096, 33.73102], [-118.32087, 33.73109], [-118.3203, 33.73132], [-118.32022, 33.73136], [-118.32006, 33.73149], [-118.31998, 33.73159], [-118.31991, 33.7317], [-118.31986, 33.73185], [-118.31985, 33.73199], [-118.31855, 33.73198], [-118.31855, 33.72938], [-118.32101, 33.72939], [-118.32102, 33.73089]]]} | Open Access 1 | 5942 | Martin J. Bogdanovich Recreation Center and Park | 21905 | 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 | 14.3 | Martin J. Bogdanovich Rec. Ctr. and Park | 0 | Local Recreation Area 3 | 4 | |
17052 | 17052 | 17051 | {"type": "Polygon", "coordinates": [[[-118.3746, 34.21924], [-118.37049, 34.21923], [-118.37046, 34.21918], [-118.37045, 34.21764], [-118.3705, 34.21764], [-118.37052, 34.2176], [-118.37057, 34.21759], [-118.3746, 34.21759], [-118.3746, 34.21924]]]} | Open Access 1 | 14547 | Sun Valley Park & Recreation Center | 25981 | 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 | 17.229 | Sun Valley Park & Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17051 | 17051 | 17050 | {"type": "Polygon", "coordinates": [[[-117.74578, 34.02877], [-117.74542, 34.02878], [-117.74539, 34.02875], [-117.74539, 34.02862], [-117.74577, 34.02861], [-117.74578, 34.02877]]]} | Restricted Access 2 | 46518 | Renacimiento Community Center | 29805 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/81-renacimiento-community-center | Los Angeles 6 | 0.157 | Renacimiento Community Ctr. | 0 | Local Recreation Area 3 | 4 |
17050 | 17050 | 17049 | {"type": "MultiPolygon", "coordinates": [[[[-118.07661, 34.66475], [-118.07606, 34.66475], [-118.07502, 34.66449], [-118.07376, 34.66452], [-118.07375, 34.66468], [-118.06801, 34.66468], [-118.06796, 34.66371], [-118.06794, 34.66087], [-118.06803, 34.66079], [-118.07648, 34.66082], [-118.07657, 34.66089], [-118.07661, 34.66475]]], [[[-118.08351, 34.66425], [-118.07694, 34.66429], [-118.07691, 34.66192], [-118.07694, 34.66159], [-118.07694, 34.6609], [-118.07703, 34.66082], [-118.08342, 34.66077], [-118.08345, 34.66335], [-118.08351, 34.66425]]]]} | Restricted Access 2 | 46506 | Lancaster National Soccer Center | 29790 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | Los Angeles 6 | 140.153 | Lancaster Nat. Soccer Ctr. | 0 | Local Recreation Area 3 | 4 | |
17049 | 17049 | 17048 | {"type": "Polygon", "coordinates": [[[-118.10867, 34.09787], [-118.1084, 34.09799], [-118.10834, 34.09808], [-118.10827, 34.09805], [-118.10823, 34.0981], [-118.10818, 34.09809], [-118.10813, 34.09816], [-118.10801, 34.09811], [-118.1084, 34.09743], [-118.10867, 34.09787]]]} | Restricted Access 2 | 46476 | Grapevine Arbor Park and Adult Recreation Center | 29751 | 1301 | San Gabriel, City of 740 | City 2 | City Agency 2 | http://www.sangabrielcity.com/ | City 2 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | Los Angeles 6 | 0.517 | Grapevine Arbor Park and Adult Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17048 | 17048 | 17047 | {"type": "Polygon", "coordinates": [[[-118.41338, 33.74626], [-118.41322, 33.74627], [-118.40776, 33.74687], [-118.40791, 33.7467], [-118.40907, 33.74548], [-118.40922, 33.74528], [-118.40941, 33.74493], [-118.40945, 33.74479], [-118.40949, 33.74479], [-118.41043, 33.74285], [-118.411, 33.74311], [-118.41123, 33.74353], [-118.41138, 33.74367], [-118.41169, 33.74396], [-118.41217, 33.74425], [-118.41234, 33.74446], [-118.41232, 33.74459], [-118.41269, 33.74525], [-118.41338, 33.74626]]]} | Open Access 1 | 46085 | Point Vicente Interpretive Center | 29431 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 26.518 | Point Vicente Interpretive Ctr. | 0 | Local Recreation Area 3 | 4 | |
17043 | 17043 | 17042 | {"type": "Polygon", "coordinates": [[[-118.63949, 34.1344], [-118.63897, 34.13477], [-118.63865, 34.13468], [-118.63872, 34.13445], [-118.63852, 34.13401], [-118.63818, 34.13385], [-118.63733, 34.1336], [-118.63662, 34.1335], [-118.63601, 34.13367], [-118.63546, 34.13369], [-118.6351, 34.13385], [-118.63501, 34.13385], [-118.63502, 34.13375], [-118.63524, 34.13345], [-118.63564, 34.13275], [-118.63565, 34.13271], [-118.63949, 34.13272], [-118.63949, 34.1344]]]} | Open Access 1 | 45649 | Calabasas Creekside Park & Community Center | 28465 | 1040 | Calabasas, City of 313 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation.html | City 2 | 1040 | Calabasas, City of 310 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation/creekside.html | Los Angeles 6 | 12.212 | Calabasas Creekside Park & Community Ctr. | 0 | Local Recreation Area 3 | 4 |
17042 | 17042 | 17041 | {"type": "Polygon", "coordinates": [[[-118.37326, 34.27372], [-118.36895, 34.2735], [-118.36894, 34.27339], [-118.36827, 34.27335], [-118.3682, 34.27332], [-118.3682, 34.27247], [-118.36822, 34.27225], [-118.36828, 34.2722], [-118.36834, 34.27218], [-118.36839, 34.27207], [-118.36845, 34.27199], [-118.36856, 34.2719], [-118.36875, 34.27177], [-118.36887, 34.27172], [-118.36924, 34.27164], [-118.36933, 34.27158], [-118.36934, 34.27154], [-118.36933, 34.27138], [-118.36919, 34.27127], [-118.3688, 34.27111], [-118.36873, 34.27105], [-118.36865, 34.27091], [-118.36862, 34.27081], [-118.36862, 34.27071], [-118.36868, 34.27055], [-118.36874, 34.27046], [-118.36878, 34.27038], [-118.36881, 34.2701], [-118.36881, 34.26999], [-118.36876, 34.26986], [-118.36871, 34.26981], [-118.36861, 34.26974], [-118.36851, 34.26964], [-118.36848, 34.26958], [-118.36848, 34.26953], [-118.36828, 34.26945], [-118.36821, 34.26921], [-118.36819, 34.269], [-118.3725, 34.26887], [-118.3728, 34.26881], [-118.37297, 34.26886], [-118.37307, 34.26895], [-118.37311, 34.26911], [-118.3728, 34.27074], [-118.37326, 34.27372]]]} | Restricted Access 2 | 47236 | Hansen Dam Equestrian Center | 30949 | 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 | http://hansendamhorsecenter.com/ | Los Angeles 6 | 52.323 | Hansen Dam Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 |
17040 | 17040 | 17039 | {"type": "MultiPolygon", "coordinates": [[[[-117.45663, 33.95565], [-117.45632, 33.95587], [-117.45598, 33.95604], [-117.45559, 33.95619], [-117.45518, 33.95628], [-117.4551, 33.95629], [-117.45398, 33.95629], [-117.45397, 33.95621], [-117.45293, 33.95622], [-117.4533, 33.95591], [-117.45356, 33.9556], [-117.45389, 33.95566], [-117.45399, 33.95566], [-117.45399, 33.95458], [-117.45538, 33.95457], [-117.45593, 33.95505], [-117.45662, 33.95554], [-117.45663, 33.95565]]], [[[-117.46118, 33.95825], [-117.45644, 33.9549], [-117.45602, 33.95457], [-117.45558, 33.95416], [-117.45532, 33.95387], [-117.45508, 33.95357], [-117.45486, 33.95325], [-117.45468, 33.95293], [-117.45472, 33.95285], [-117.45507, 33.95274], [-117.45536, 33.95269], [-117.45743, 33.95268], [-117.45803, 33.95369], [-117.45885, 33.95382], [-117.46023, 33.95608], [-117.46069, 33.95728], [-117.46071, 33.95727], [-117.46062, 33.95703], [-117.46072, 33.95701], [-117.46118, 33.95825]]]]} | Restricted Access 2 | 30001 | Van Buren Golf Center | 33095 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 41.11 | Van Buren Golf Ctr. | 0 | Local Recreation Area 3 | 4 | |
17039 | 17039 | 17038 | {"type": "Polygon", "coordinates": [[[-121.29458, 37.95402], [-121.29455, 37.95407], [-121.29456, 37.95412], [-121.29396, 37.95531], [-121.29388, 37.95538], [-121.29374, 37.95544], [-121.29362, 37.95545], [-121.29271, 37.9554], [-121.2927, 37.95548], [-121.2927, 37.95549], [-121.29374, 37.95554], [-121.29215, 37.95577], [-121.29166, 37.95409], [-121.29334, 37.9539], [-121.2945, 37.95393], [-121.29454, 37.95394], [-121.29458, 37.95402]]]} | Open Access 1 | 29645 | Weber Point Event Center | 27326 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 9.256 | Weber Point Event Ctr. | 0 | Local Recreation Area 3 | 4 | |
17038 | 17038 | 17037 | {"type": "Polygon", "coordinates": [[[-121.38028, 38.71566], [-121.37876, 38.71566], [-121.37877, 38.71427], [-121.37896, 38.71426], [-121.37894, 38.71421], [-121.37891, 38.71418], [-121.3788, 38.71416], [-121.3788, 38.71329], [-121.38008, 38.71329], [-121.38006, 38.71389], [-121.38001, 38.71466], [-121.38007, 38.71497], [-121.38027, 38.71498], [-121.38028, 38.71566]]]} | Open Access 1 | 28341 | Capehart Youth Center | 16833 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 7.519 | Capehart Youth Ctr. | 0 | Local Recreation Area 3 | 4 | |
17035 | 17035 | 17034 | {"type": "Polygon", "coordinates": [[[-121.076, 38.68331], [-121.07338, 38.68435], [-121.07326, 38.68359], [-121.07237, 38.68276], [-121.072, 38.68255], [-121.07182, 38.68187], [-121.07311, 38.68189], [-121.07452, 38.68212], [-121.075, 38.68217], [-121.07565, 38.68221], [-121.0757, 38.68245], [-121.07588, 38.68303], [-121.07583, 38.68311], [-121.07589, 38.68329], [-121.076, 38.68331]]]} | Open Access 1 | 24126 | Teen Center & Skate Park | 26216 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | El Dorado 34 | 14.338 | Teen Ctr. & Skate Park | 0 | Local Recreation Area 3 | 4 | |
17033 | 17033 | 17032 | {"type": "Polygon", "coordinates": [[[-122.85063, 38.62187], [-122.85033, 38.62203], [-122.85026, 38.62196], [-122.85036, 38.62188], [-122.85022, 38.62174], [-122.85, 38.62187], [-122.85036, 38.62223], [-122.84998, 38.62226], [-122.8494, 38.62223], [-122.84941, 38.62281], [-122.84722, 38.62334], [-122.8473, 38.62058], [-122.85008, 38.62055], [-122.85049, 38.62114], [-122.85063, 38.62187]]]} | Open Access 1 | 23634 | Villag Chanticleer Conference Center | 27108 | 1131 | Healdsburg, City of 374 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | Sonoma 16 | 16.784 | Villag Chanticleer Conference Ctr. | 0 | Local Recreation Area 3 | 4 | |
17032 | 17032 | 17031 | {"type": "Polygon", "coordinates": [[[-123.01796, 38.80475], [-123.01776, 38.80483], [-123.01761, 38.80461], [-123.01763, 38.80459], [-123.01759, 38.80453], [-123.01776, 38.80445], [-123.01796, 38.80475]]]} | Open Access 1 | 23631 | Veterans Memorial Center | 27022 | 1059 | Cloverdale, City of 410 | City 2 | City Agency 2 | http://www.cloverdale.net/index.aspx?nid=152 | City 2 | 1059 | Cloverdale, City of 404 | City 2 | City Agency 2 | Sonoma 16 | 0.172 | Veterans Memorial Ctr. | 0 | Local Recreation Area 3 | 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]);