units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,219 rows where MNG_AG_TYP = 3 sorted by MNG_AG_ID descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 175
- San Diego, County of 123
- Santa Barbara, County of 119
- Orange, County of 95
- Lake, County of 56
- Sacramento, County of 56
- Butte, County of 53
- Santa Cruz, County of 51
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 44
- Riverside, County of 39
- San Luis Obispo, County of 31
- Placer, County of 28
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- San Bernardino, County of 20
- Yolo, County of 18
- Fresno, County of 17
- Merced, County of 16
- Tulare, County of 15
- Humboldt, County of 12
- Mono, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- Napa, County of 5
- Modoc, County of 5
- …
DES_TP >30
- Local Park 635
- Local Other or Unknown 213
- Local Recreation Area 114
- Local Conservation Area 103
- Local Historic or Cultural Area 21
- National Recreation Area 3
- National Forest 2
- National Monument or Landmark 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,078
- Restricted Access 59
- Unknown Access 36
- No Public Access 26
MNG_AG_TYP 1
- County Agency · 1,199 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4205 | 4205 | 4204 | {"type": "Polygon", "coordinates": [[[-120.91483, 39.93803], [-120.91232, 39.93808], [-120.91216, 39.93828], [-120.91089, 39.93831], [-120.91086, 39.93744], [-120.91281, 39.93744], [-120.91293, 39.93722], [-120.91326, 39.93721], [-120.91325, 39.93651], [-120.91482, 39.93651], [-120.91483, 39.93803]]]} | Open Access 1 | 48871 | Quincy Skatepark | 33592 | 362 | Plumas, County of 664 | County 3 | County Agency 3 | http://www.countyofplumas.com/ | County 3 | 362 | Plumas, County of 652 | County 3 | County Agency 3 | Plumas 57 | 10.115 | Quincy Skatepark | None 367 | |||
11486 | 11486 | 11485 | {"type": "Polygon", "coordinates": [[[-121.23036, 40.31128], [-121.22869, 40.31078], [-121.22893, 40.31053], [-121.22915, 40.31023], [-121.22982, 40.31054], [-121.23019, 40.31006], [-121.2305, 40.3102], [-121.23071, 40.30993], [-121.23103, 40.31009], [-121.23108, 40.31008], [-121.23123, 40.31016], [-121.23127, 40.31012], [-121.23164, 40.3103], [-121.23135, 40.31089], [-121.23114, 40.31086], [-121.23077, 40.31138], [-121.23036, 40.31128]]]} | Open Access 1 | 48187 | Chester Park and Ballfields | 32850 | 362 | Plumas, County of 664 | County 3 | County Agency 3 | http://www.countyofplumas.com/ | County 3 | 362 | Plumas, County of 652 | County 3 | County Agency 3 | Plumas 57 | 5.319 | Chester Park and Ballfields | 0 | None 1021 | ||
15018 | 15018 | 15017 | {"type": "Polygon", "coordinates": [[[-120.93479, 40.13815], [-120.93477, 40.13868], [-120.9346, 40.13866], [-120.93442, 40.13872], [-120.93425, 40.13909], [-120.93388, 40.13918], [-120.93353, 40.13908], [-120.93183, 40.13888], [-120.93185, 40.13818], [-120.9312, 40.13818], [-120.93121, 40.13773], [-120.93479, 40.13815]]]} | Open Access 1 | 48463 | Greenville Community Park | 33173 | 362 | Plumas, County of 664 | County 3 | County Agency 3 | http://www.countyofplumas.com/ | County 3 | 362 | Plumas, County of 652 | County 3 | County Agency 3 | https://plumascounty.org/Parks-and-picnic-areas | Plumas 57 | 7.462 | Greenville Community Park | 0 | Local Park 2 | 4 |
15021 | 15021 | 15020 | {"type": "Polygon", "coordinates": [[[-121.02525, 39.27137], [-121.02458, 39.27178], [-121.02463, 39.2722], [-121.02458, 39.27234], [-121.02427, 39.27257], [-121.02436, 39.27291], [-121.02413, 39.27301], [-121.02351, 39.2731], [-121.02323, 39.2731], [-121.02296, 39.27305], [-121.02255, 39.27293], [-121.02227, 39.27278], [-121.02207, 39.27253], [-121.02238, 39.27212], [-121.02238, 39.27195], [-121.02298, 39.2717], [-121.02307, 39.27154], [-121.02315, 39.27146], [-121.02322, 39.2713], [-121.02336, 39.27113], [-121.02397, 39.27013], [-121.02405, 39.27005], [-121.02429, 39.27012], [-121.02424, 39.27023], [-121.02421, 39.27049], [-121.02429, 39.27056], [-121.02445, 39.27055], [-121.02472, 39.27038], [-121.02453, 39.27084], [-121.02463, 39.27121], [-121.02525, 39.27137]]]} | Open Access 1 | 45668 | Tobiassen Park | 28508 | 361 | Nevada, County of 1134 | County 3 | County Agency 3 | http://mynevadacounty.com/ | County 3 | 361 | Nevada, County of 1089 | County 3 | County Agency 3 | Nevada 30 | 10.972 | Tobiassen Park | 0 | Local Park 2 | 4 | |
3724 | 3724 | 3723 | {"type": "Polygon", "coordinates": [[[-118.20363, 36.80669], [-118.20289, 36.807], [-118.20237, 36.80627], [-118.20224, 36.80618], [-118.20303, 36.80585], [-118.20363, 36.80669]]]} | Open Access 1 | 44705 | Dehy Park | 18020 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 360 | Inyo, County of 662 | County 3 | County Agency 3 | Inyo 43 | 1.985 | Dehy Park | 0 | Local Park 2 | 4 | |
4156 | 4156 | 4155 | {"type": "Polygon", "coordinates": [[[-122.20164, 39.52119], [-122.2011, 39.5212], [-122.2011, 39.52062], [-122.20164, 39.52061], [-122.20164, 39.52119]]]} | Open Access 1 | 48863 | Memorial Park | 33583 | 359 | Glenn, County of 725 | County 3 | County Agency 3 | http://www.countyofglenn.net/ | County 3 | 359 | Glenn, County of 710 | County 3 | County Agency 3 | Glenn 55 | 0.742 | Memorial Park | 0 | Local Park 2 | 4 | |
14562 | 14562 | 14561 | {"type": "Polygon", "coordinates": [[[-122.19397, 39.75117], [-122.19396, 39.75163], [-122.19291, 39.7516], [-122.19294, 39.75113], [-122.193, 39.75108], [-122.19392, 39.75108], [-122.19397, 39.75117]]]} | Open Access 1 | 48862 | Legion Memorial Park | 33582 | 359 | Glenn, County of 725 | County 3 | County Agency 3 | http://www.countyofglenn.net/ | County 3 | 359 | Glenn, County of 710 | County 3 | County Agency 3 | Glenn 55 | 1.295 | Legion Memorial Park | 0 | Local Park 2 | 4 | |
14458 | 14458 | 14457 | {"type": "Polygon", "coordinates": [[[-122.52636, 39.31903], [-122.52637, 39.31943], [-122.5251, 39.32296], [-122.52302, 39.32853], [-122.52303, 39.32854], [-122.52363, 39.32846], [-122.52301, 39.33189], [-122.5221, 39.33213], [-122.52146, 39.33351], [-122.52147, 39.33352], [-122.52615, 39.33354], [-122.52618, 39.34106], [-122.52153, 39.34078], [-122.52151, 39.34079], [-122.52166, 39.34795], [-122.52124, 39.35165], [-122.52558, 39.35156], [-122.52505, 39.35517], [-122.51546, 39.35536], [-122.51509, 39.35543], [-122.51507, 39.35551], [-122.51507, 39.35552], [-122.52086, 39.35545], [-122.52011, 39.35957], [-122.51765, 39.35917], [-122.51725, 39.36293], [-122.51262, 39.36292], [-122.51273, 39.36466], [-122.51209, 39.36462], [-122.51208, 39.36463], [-122.51212, 39.36627], [-122.51216, 39.37706], [-122.50724, 39.37681], [-122.49639, 39.37713], [-122.49613, 39.37347], [-122.49333, 39.37343], [-122.49328, 39.36618], [-122.48982, 39.36607], [-122.48974, 39.36264], [-122.4979, 39.36258], [-122.49749, 39.35637], [-122.49597, 39.3563], [-122.49588, 39.35551], [-122.48838, 39.35532], [-122.48843, 39.34826], [-122.48842, 39.33347], [-122.48846, 39.33111], [-122.48844, 39.33083], [-122.48853, 39.31922], [-122.48858, 39.30481], [-122.48873, 39.30475], [-122.4932, 39.30468], [-122.49319, 39.30527], [-122.49324, 39.30836], [-122.49341, 39.31258], [-122.4934, 39.31363], [-122.4944, 39.31557], [-122.49816, 39.31564], [-122.49811, 39.3192], [-122.50313, 39.31914], [-122.52636, 39.31903]]]} | Open Access 1 | 47088 | East Park Reservoir | 30742 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 358 | Colusa, County of 1068 | County 3 | County Agency 3 | Colusa 49 | 4263.017 | East Park Reservoir | 0 | Local Recreation Area 3 | 4 | |
4342 | 4342 | 4341 | {"type": "Polygon", "coordinates": [[[-120.74524, 40.43205], [-120.7452, 40.43213], [-120.74515, 40.43217], [-120.74508, 40.43219], [-120.74501, 40.43218], [-120.74495, 40.43216], [-120.7449, 40.43211], [-120.74489, 40.43206], [-120.7449, 40.432], [-120.74494, 40.43195], [-120.745, 40.43192], [-120.74507, 40.43191], [-120.74514, 40.43193], [-120.7452, 40.43197], [-120.74524, 40.43205]]]} | Open Access 1 | 45592 | Lake Forest Park | 28418 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 0.17 | Lake Forest Park | 0 | Local Park 2 | 4 | |
12365 | 12365 | 12364 | {"type": "Polygon", "coordinates": [[[-121.13882, 41.1215], [-121.1388, 41.12256], [-121.13851, 41.12256], [-121.13851, 41.1227], [-121.13831, 41.1227], [-121.13798, 41.12334], [-121.13683, 41.12331], [-121.13678, 41.12411], [-121.13849, 41.12478], [-121.13372, 41.12466], [-121.13375, 41.12141], [-121.13483, 41.12142], [-121.1348, 41.12231], [-121.13481, 41.12232], [-121.13606, 41.12234], [-121.13611, 41.12143], [-121.13872, 41.12145], [-121.13882, 41.1215]]]} | Open Access 1 | 26506 | Clara Beiber Memorial Park | 17378 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 29.359 | Clara Beiber Memorial Park | 0 | Local Park 2 | 4 | |
13006 | 13006 | 13005 | {"type": "MultiPolygon", "coordinates": [[[[-120.68104, 40.45295], [-120.68099, 40.46019], [-120.67649, 40.46022], [-120.67654, 40.45661], [-120.67653, 40.4566], [-120.66706, 40.45665], [-120.667, 40.46027], [-120.66226, 40.4603], [-120.6623, 40.45668], [-120.6531, 40.45655], [-120.65312, 40.45293], [-120.65304, 40.44917], [-120.66237, 40.44922], [-120.66239, 40.44043], [-120.66338, 40.44176], [-120.66359, 40.44199], [-120.66482, 40.4428], [-120.66579, 40.44331], [-120.66713, 40.44409], [-120.6671, 40.45302], [-120.68104, 40.45295]]], [[[-120.69991, 40.43132], [-120.67685, 40.43119], [-120.67664, 40.4383], [-120.67663, 40.44185], [-120.66715, 40.44196], [-120.66712, 40.44374], [-120.6654, 40.44268], [-120.66459, 40.44227], [-120.66384, 40.44171], [-120.66272, 40.44014], [-120.66252, 40.43976], [-120.66257, 40.43835], [-120.66716, 40.43833], [-120.66725, 40.43476], [-120.66527, 40.43474], [-120.66533, 40.43308], [-120.66498, 40.4331], [-120.66395, 40.43311], [-120.66334, 40.43308], [-120.66261, 40.43303], [-120.6639, 40.43309], [-120.6649, 40.43309], [-120.66554, 40.43306], [-120.66589, 40.43303], [-120.6672, 40.43283], [-120.66692, 40.43187], [-120.66677, 40.43189], [-120.66669, 40.43169], [-120.66653, 40.43117], [-120.66621, 40.43004], [-120.66606, 40.42961], [-120.66606, 40.42947], [-120.66595, 40.42852], [-120.66656, 40.4289], [-120.66691, 40.42853], [-120.66647, 40.42826], [-120.66593, 40.42826], [-120.66556, 40.42755], [-120.66555, 40.42742], [-120.66707, 40.42744], [-120.66708, 40.42711], [-120.66746, 40.42741], [-120.66747, 40.42751], [-120.6955, 40.42767], [-120.69768, 40.4277], [-120.69986, 40.4277], [-120.69991, 40.43132]], [[-120.66836, 40.42939], [-120.66836, 40.42938], [-120.66777, 40.42911], [-120.66749, 40.42957], [-120.66773, 40.42965], [-120.66809, 40.4298], [-120.66836, 40.42939]]]]} | Open Access 1 | 31210 | Susanville Ranch Park | 5230 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | http://www.susanvilleranchpark.com/ | Lassen 54 | 1083.674 | Susanville Ranch Park | 0 | Local Park 2 | 4 |
14927 | 14927 | 14926 | {"type": "Polygon", "coordinates": [[[-121.05053, 40.29888], [-121.05041, 40.29895], [-121.05002, 40.29909], [-121.04992, 40.29928], [-121.04993, 40.3001], [-121.04991, 40.30054], [-121.04995, 40.30076], [-121.05009, 40.3012], [-121.05036, 40.3026], [-121.05035, 40.30285], [-121.05022, 40.30338], [-121.04992, 40.30358], [-121.04899, 40.30369], [-121.04872, 40.30348], [-121.04859, 40.30305], [-121.04872, 40.30279], [-121.04882, 40.30251], [-121.04853, 40.30131], [-121.04835, 40.30045], [-121.04823, 40.29965], [-121.04858, 40.29925], [-121.05, 40.29859], [-121.05053, 40.29888]]]} | Open Access 1 | 45503 | Clear Creek Park | 28335 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 17.372 | Clear Creek Park | 0 | Local Park 2 | 4 | |
14965 | 14965 | 14964 | {"type": "Polygon", "coordinates": [[[-120.52341, 40.29987], [-120.52322, 40.30012], [-120.52303, 40.30027], [-120.52307, 40.30052], [-120.52318, 40.3009], [-120.52313, 40.30104], [-120.52303, 40.30109], [-120.52292, 40.30119], [-120.52286, 40.30126], [-120.52242, 40.30161], [-120.52148, 40.30112], [-120.52143, 40.30107], [-120.52173, 40.3007], [-120.52205, 40.30035], [-120.52233, 40.29995], [-120.5226, 40.29976], [-120.5227, 40.29966], [-120.5231, 40.29967], [-120.52341, 40.29987]]]} | Open Access 1 | 45579 | Janesville Park | 28404 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 4.808 | Janesville Park | 0 | Local Park 2 | 4 | |
14977 | 14977 | 14976 | {"type": "Polygon", "coordinates": [[[-120.52303, 40.3739], [-120.52281, 40.37423], [-120.52276, 40.37436], [-120.52276, 40.37473], [-120.5228, 40.37498], [-120.52221, 40.37504], [-120.52204, 40.37449], [-120.52192, 40.37367], [-120.52292, 40.37384], [-120.52291, 40.37388], [-120.52303, 40.3739]]]} | Open Access 1 | 45596 | Leavitt Lake Park | 28422 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 2.292 | Leavitt Lake Park | 0 | Local Park 2 | 4 | |
12733 | 12733 | 12732 | {"type": "MultiPolygon", "coordinates": [[[[-122.50606, 38.01702], [-122.50538, 38.01773], [-122.50389, 38.0179], [-122.5039, 38.01851], [-122.4971, 38.01865], [-122.48, 38.02023], [-122.47926, 38.02067], [-122.47925, 38.02058], [-122.47924, 38.02057], [-122.46957, 38.02491], [-122.46829, 38.02814], [-122.46444, 38.03432], [-122.45826, 38.01394], [-122.45798, 38.00928], [-122.45797, 38.00928], [-122.45718, 38.01038], [-122.45356, 37.99846], [-122.46201, 38.00454], [-122.47026, 38.00744], [-122.47894, 38.01033], [-122.48622, 38.01267], [-122.48627, 38.01271], [-122.48923, 38.01368], [-122.49539, 38.01456], [-122.50181, 38.01539], [-122.50328, 38.01578], [-122.50332, 38.0158], [-122.50338, 38.01576], [-122.50344, 38.01707], [-122.50606, 38.01702]]], [[[-122.49754, 38.02919], [-122.49296, 38.02924], [-122.49287, 38.02566], [-122.49743, 38.02564], [-122.49754, 38.02919]]]]} | Open Access 1 | 29763 | Water Lots | 27293 | 353 | Marin, County of 1034 | County 3 | County Agency 3 | http://www.marincounty.org/recreation/parks-in-marin | County 3 | 353 | Marin, County of 996 | County 3 | County Agency 3 | Marin 23 | 1356.794 | Water Lots | 1976 | Local Other or Unknown 14 | 4 | |
3331 | 3331 | 3330 | {"type": "Polygon", "coordinates": [[[-123.5325, 38.79904], [-123.53139, 38.79955], [-123.53069, 38.799], [-123.53039, 38.79909], [-123.52955, 38.7979], [-123.52979, 38.79762], [-123.53088, 38.79674], [-123.5325, 38.79904]]]} | Open Access 1 | 29749 | Bower Park | 16307 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | Mendocino 24 | 9.995 | Bower Park | 0 | Local Park 2 | 4 | |
4186 | 4186 | 4185 | {"type": "Polygon", "coordinates": [[[-123.20725, 39.27079], [-123.2067, 39.27099], [-123.20635, 39.27092], [-123.20581, 39.27127], [-123.2057, 39.27079], [-123.20565, 39.27078], [-123.20548, 39.27018], [-123.20624, 39.27012], [-123.20625, 39.2701], [-123.20614, 39.26983], [-123.20541, 39.2699], [-123.2054, 39.26983], [-123.20702, 39.26969], [-123.20725, 39.27079]]]} | Open Access 1 | 48864 | Redwood Valley Lions Club Park | 33588 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/redwood-valley-lions-club-park | Mendocino 24 | 4.164 | Redwood Valley Lions Club Park | 0 | Local Park 2 | 4 |
5212 | 5212 | 5211 | {"type": "Polygon", "coordinates": [[[-123.7721, 39.56968], [-123.77167, 39.5697], [-123.77145, 39.56927], [-123.771, 39.56816], [-123.77128, 39.56814], [-123.77136, 39.56839], [-123.77169, 39.56866], [-123.77174, 39.56906], [-123.77185, 39.56918], [-123.7721, 39.56968]]]} | Open Access 1 | 46783 | Coastal View Point | 30237 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | Mendocino 24 | 1.451 | Coastal View Point | None 422 | |||
9402 | 9402 | 9401 | {"type": "Polygon", "coordinates": [[[-123.4405, 39.05938], [-123.44049, 39.05965], [-123.44041, 39.05975], [-123.44021, 39.05983], [-123.43997, 39.0601], [-123.43987, 39.06018], [-123.43962, 39.06044], [-123.4395, 39.06053], [-123.43949, 39.06058], [-123.4393, 39.06079], [-123.43906, 39.06087], [-123.43892, 39.06095], [-123.43876, 39.06095], [-123.43795, 39.06072], [-123.43766, 39.0607], [-123.4375, 39.06076], [-123.43727, 39.06098], [-123.43715, 39.06109], [-123.43686, 39.06123], [-123.43655, 39.06093], [-123.43605, 39.06052], [-123.43589, 39.0604], [-123.43528, 39.06002], [-123.43639, 39.05958], [-123.43805, 39.05866], [-123.4405, 39.05938]]]} | Open Access 1 | 49017 | Indian Creek County Park | 33715 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/indian-creek | Mendocino 24 | 17.437 | Indian Creek County Park | 1973 | Local Park 2 | 4 |
14982 | 14982 | 14981 | {"type": "Polygon", "coordinates": [[[-123.135, 39.12443], [-123.13499, 39.13171], [-123.12626, 39.13116], [-123.12633, 39.12775], [-123.12597, 39.1242], [-123.135, 39.12443]]]} | Open Access 1 | 45610 | Mill Creek Park | 28437 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/millcreek.htm | Mendocino 24 | 148.09 | Mill Creek 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]);