units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,440 rows where DES_TP = 3 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 211
- Los Angeles, City of 116
- San Francisco, City and County of 80
- San Luis Obispo, City of 26
- Long Beach, City of 25
- Glendale, City of 24
- Davis, City of 23
- 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
- Santa Cruz, City of 14
- San Bernardino, City of 14
- San Marcos, City of 14
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Mission Viejo, City of 11
- Fresno, City of 10
- Oceanside, City of 10
- Riverside, City of 9
- Irvine, City of 9
- Roseville, City of 9
- Santa Barbara, City of 8
- South San Francisco, City of 8
- Escondido, City of 8
- Chico, City of 8
- …
ACCESS_TYP 4
- Open Access 1,226
- Restricted Access 168
- No Public Access 40
- Unknown Access 6
MNG_AG_TYP 1
- City Agency · 1,440 ✖
DES_TP 1
- Local Recreation Area · 1,440 ✖
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 | |
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 | |
17028 | 17028 | 17027 | {"type": "Polygon", "coordinates": [[[-121.4802, 38.47983], [-121.48019, 38.48034], [-121.48016, 38.48082], [-121.48016, 38.48122], [-121.48014, 38.48126], [-121.48008, 38.48127], [-121.48008, 38.48132], [-121.47963, 38.48133], [-121.47962, 38.48127], [-121.47841, 38.48128], [-121.4784, 38.48134], [-121.47683, 38.48135], [-121.47683, 38.47983], [-121.4802, 38.47983]]]} | Open Access 1 | 21239 | Pannell / Meadowview Community Center Park | 23388 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 11.904 | Pannell / Meadowview Community Ctr. Park | 0 | Local Recreation Area 3 | 4 | |
17027 | 17027 | 17026 | {"type": "Polygon", "coordinates": [[[-121.51167, 38.52299], [-121.51127, 38.52385], [-121.51106, 38.52434], [-121.51102, 38.52436], [-121.50753, 38.52435], [-121.50683, 38.52435], [-121.50651, 38.52439], [-121.50624, 38.52446], [-121.50627, 38.52396], [-121.50634, 38.52347], [-121.5064, 38.52341], [-121.50646, 38.52338], [-121.50657, 38.52337], [-121.50664, 38.52341], [-121.5068, 38.52376], [-121.50686, 38.52383], [-121.50704, 38.52384], [-121.50716, 38.52382], [-121.50788, 38.52353], [-121.50803, 38.52351], [-121.50815, 38.52353], [-121.50816, 38.52389], [-121.50873, 38.52389], [-121.50874, 38.52388], [-121.50872, 38.52355], [-121.50877, 38.52349], [-121.50894, 38.52351], [-121.50924, 38.52359], [-121.50959, 38.5236], [-121.50977, 38.52349], [-121.50977, 38.52335], [-121.50983, 38.52313], [-121.50989, 38.5231], [-121.51084, 38.52326], [-121.51093, 38.52326], [-121.51108, 38.52321], [-121.51122, 38.5231], [-121.51127, 38.52299], [-121.51167, 38.52299]]]} | Open Access 1 | 21201 | Belle Cooledge Community Center Park | 15982 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 10.444 | Belle Cooledge Community Ctr. Park | 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]);