units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
DES_TP >30
- Local Park 7,486
- Local Recreation Area 1,440
- Local Other or Unknown 663
- Local Conservation Area 143
- Local Historic or Cultural Area 37
- Local Resource Management Area 6
- National Monument or Landmark 5
- None 1
- None 1
- National Forest 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 9,925
- Restricted Access 363
- No Public Access 207
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,524 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1114 | 1114 | 1113 | {"type": "Polygon", "coordinates": [[[-118.7559, 34.15989], [-118.75536, 34.16003], [-118.75504, 34.16018], [-118.75477, 34.15985], [-118.7547, 34.15989], [-118.75465, 34.15985], [-118.7547, 34.15977], [-118.75426, 34.15923], [-118.75461, 34.15907], [-118.7549, 34.15895], [-118.75544, 34.15881], [-118.75565, 34.15878], [-118.75568, 34.1588], [-118.7559, 34.15989]]]} | Open Access 1 | 7086 | Sumac Park | 25952 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 3.565 | Sumac Park | 0 | Local Park 2 | 4 | |
1244 | 1244 | 1243 | {"type": "Polygon", "coordinates": [[[-118.75782, 34.14997], [-118.75728, 34.1502], [-118.75717, 34.15022], [-118.75588, 34.15073], [-118.75575, 34.15081], [-118.75566, 34.15093], [-118.75562, 34.15105], [-118.75565, 34.15116], [-118.75578, 34.15144], [-118.7558, 34.15161], [-118.75578, 34.15167], [-118.75575, 34.15168], [-118.75537, 34.15161], [-118.75497, 34.15156], [-118.75442, 34.15158], [-118.7544, 34.15156], [-118.7543, 34.15109], [-118.75429, 34.15092], [-118.7543, 34.15034], [-118.75437, 34.15019], [-118.75443, 34.15012], [-118.75454, 34.15006], [-118.75517, 34.14985], [-118.75535, 34.14977], [-118.75551, 34.14964], [-118.75559, 34.14954], [-118.75564, 34.14946], [-118.75571, 34.14928], [-118.75696, 34.14927], [-118.75696, 34.14847], [-118.75721, 34.14848], [-118.7572, 34.14881], [-118.75728, 34.14907], [-118.75782, 34.14997]]]} | Open Access 1 | 7084 | Chumash Park | 17244 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 12.237 | Chumash Park | 0 | Local Park 2 | 4 | |
1249 | 1249 | 1248 | {"type": "Polygon", "coordinates": [[[-118.74028, 34.14602], [-118.74025, 34.14701], [-118.74023, 34.14701], [-118.74007, 34.14713], [-118.73888, 34.14804], [-118.73793, 34.1474], [-118.7382, 34.14683], [-118.73883, 34.14538], [-118.73887, 34.14538], [-118.73978, 34.14564], [-118.7397, 34.14577], [-118.7399, 34.14588], [-118.74001, 34.14577], [-118.74025, 34.14595], [-118.74028, 34.14602]]]} | Open Access 1 | 7089 | Old Agoura Park | 23080 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 9.855 | Old Agoura Park | 0 | Local Park 2 | 4 | |
1773 | 1773 | 1772 | {"type": "Polygon", "coordinates": [[[-118.77475, 34.15589], [-118.77452, 34.15647], [-118.77348, 34.15621], [-118.77348, 34.15481], [-118.77451, 34.15481], [-118.77453, 34.15483], [-118.77453, 34.15544], [-118.77457, 34.15559], [-118.77464, 34.15574], [-118.77475, 34.15589]]]} | Open Access 1 | 7087 | Morrison Park | 22498 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 4.326 | Morrison Park | 0 | Local Park 2 | 4 | |
7521 | 7521 | 7520 | {"type": "Polygon", "coordinates": [[[-118.7838, 34.15183], [-118.78372, 34.15187], [-118.78361, 34.15191], [-118.78334, 34.15197], [-118.78238, 34.15198], [-118.7814, 34.15192], [-118.78138, 34.15189], [-118.78139, 34.15118], [-118.7818, 34.15118], [-118.78182, 34.1511], [-118.78186, 34.15112], [-118.78195, 34.15111], [-118.78196, 34.15119], [-118.78237, 34.15119], [-118.78238, 34.15108], [-118.78286, 34.15109], [-118.78296, 34.15118], [-118.78313, 34.15125], [-118.78332, 34.15125], [-118.78343, 34.15121], [-118.78362, 34.15156], [-118.7838, 34.15183]]]} | Open Access 1 | 7090 | Reyes Adobe Park | 24309 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 4.476 | Reyes Adobe Park | 0 | Local Park 2 | 4 | |
7527 | 7527 | 7526 | {"type": "Polygon", "coordinates": [[[-118.77622, 34.15274], [-118.77577, 34.15299], [-118.77544, 34.15314], [-118.77519, 34.15322], [-118.77464, 34.15337], [-118.7746, 34.15336], [-118.77421, 34.15251], [-118.77414, 34.15225], [-118.77411, 34.15199], [-118.77412, 34.15095], [-118.77415, 34.15094], [-118.77455, 34.1509], [-118.77534, 34.1507], [-118.77562, 34.15066], [-118.77562, 34.15092], [-118.77566, 34.15128], [-118.77569, 34.15133], [-118.77565, 34.15137], [-118.77562, 34.15141], [-118.77562, 34.15146], [-118.77564, 34.15151], [-118.77557, 34.15157], [-118.77557, 34.15183], [-118.77622, 34.15274]]]} | Open Access 1 | 7091 | Forest Cove Park | 29023 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 9.579 | Forest Cove Park | 0 | Local Park 2 | 4 | |
7532 | 7532 | 7531 | {"type": "Polygon", "coordinates": [[[-118.78099, 34.1609], [-118.78027, 34.16187], [-118.78099, 34.16417], [-118.7801, 34.16517], [-118.77827, 34.16492], [-118.77762, 34.1641], [-118.778, 34.16254], [-118.77969, 34.15982], [-118.77969, 34.1598], [-118.77867, 34.15972], [-118.77867, 34.15968], [-118.77935, 34.15968], [-118.77986, 34.15963], [-118.77994, 34.15966], [-118.78006, 34.16036], [-118.7801, 34.16048], [-118.78021, 34.16064], [-118.78038, 34.16078], [-118.78054, 34.16084], [-118.78099, 34.1609]]]} | Open Access 1 | 7109 | Agoura Hills City Parkland | 15289 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 28.668 | Agoura Hills City Parkland | 0 | Local Park 2 | 4 | |
7534 | 7534 | 7533 | {"type": "Polygon", "coordinates": [[[-118.78014, 34.14754], [-118.78008, 34.14761], [-118.78006, 34.14768], [-118.77994, 34.14767], [-118.77967, 34.14771], [-118.77895, 34.14786], [-118.77864, 34.1479], [-118.77715, 34.14789], [-118.77638, 34.14778], [-118.77611, 34.14778], [-118.77413, 34.14793], [-118.77413, 34.14783], [-118.77432, 34.14788], [-118.77524, 34.14781], [-118.77589, 34.14763], [-118.77771, 34.1475], [-118.77817, 34.14749], [-118.77833, 34.14745], [-118.77934, 34.14745], [-118.78014, 34.14754]]]} | No Public Access 3 | 7112 | Agoura Hills City Parkland | 15288 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 3.654 | Agoura Hills City Parkland | 0 | Local Park 2 | 4 | |
16095 | 16095 | 16094 | {"type": "Polygon", "coordinates": [[[-118.74322, 34.13739], [-118.74273, 34.13773], [-118.7424, 34.13775], [-118.74194, 34.1385], [-118.74154, 34.13874], [-118.74103, 34.13875], [-118.74075, 34.13873], [-118.74055, 34.13832], [-118.74076, 34.13825], [-118.741, 34.13822], [-118.74111, 34.13819], [-118.74123, 34.13814], [-118.74132, 34.13807], [-118.74156, 34.13795], [-118.74167, 34.13786], [-118.74175, 34.1379], [-118.74179, 34.13782], [-118.74184, 34.13753], [-118.74189, 34.13743], [-118.74195, 34.13733], [-118.74201, 34.13727], [-118.74209, 34.13723], [-118.74285, 34.13708], [-118.74295, 34.13708], [-118.74305, 34.13713], [-118.74322, 34.13739]]]} | Open Access 1 | 12512 | Agoura Hills Open Space | 29518 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 4.255 | Agoura Hills OS | 0 | Local Recreation Area 3 | 4 | |
16909 | 16909 | 16908 | {"type": "Polygon", "coordinates": [[[-118.77815, 34.14346], [-118.77784, 34.14376], [-118.77784, 34.14381], [-118.77752, 34.14415], [-118.77741, 34.14423], [-118.77726, 34.14428], [-118.77716, 34.14429], [-118.77696, 34.14427], [-118.77668, 34.14417], [-118.77653, 34.1441], [-118.7765, 34.14407], [-118.77656, 34.14399], [-118.77656, 34.14391], [-118.7765, 34.14383], [-118.7764, 34.1438], [-118.77667, 34.14384], [-118.7767, 34.14377], [-118.77664, 34.14368], [-118.77673, 34.14333], [-118.77709, 34.14327], [-118.77735, 34.14256], [-118.77759, 34.14262], [-118.77779, 34.14302], [-118.77815, 34.14346]]]} | Open Access 1 | 46240 | Agoura Hills Recreation and Event Center | 29519 | 3364 | Joni and Friends 1181 | Non Profit 6 | Non Profit - Other 22 | http://www.joniandfriends.org/ | Non Governmental Organization 10 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities/agoura-hills-recreation-center | Los Angeles 6 | 3.899 | Agoura Hills Rec. and Event Ctr. | 0 | Local Recreation Area 3 | 4 |
480 | 480 | 479 | {"type": "Polygon", "coordinates": [[[-122.25181, 37.74294], [-122.25094, 37.74333], [-122.2502, 37.74331], [-122.2502, 37.74256], [-122.25026, 37.74211], [-122.25158, 37.74235], [-122.25161, 37.74252], [-122.25168, 37.74271], [-122.25181, 37.74294]]]} | Open Access 1 | 1631 | Tillman Park | 26365 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 3.586 | Tillman Park | 0 | Local Park 2 | 4 | |
1754 | 1754 | 1753 | {"type": "Polygon", "coordinates": [[[-122.26219, 37.76826], [-122.26215, 37.76912], [-122.26062, 37.76844], [-122.26111, 37.76773], [-122.26212, 37.76817], [-122.26217, 37.76821], [-122.26219, 37.76826]]]} | Open Access 1 | 13146 | Franklin Park | 19060 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.958 | Franklin Park | 0 | Local Park 2 | 4 | |
1964 | 1964 | 1963 | {"type": "Polygon", "coordinates": [[[-122.23324, 37.73433], [-122.23167, 37.73513], [-122.2312, 37.73448], [-122.23129, 37.73391], [-122.23247, 37.73335], [-122.23324, 37.73433]]]} | Open Access 1 | 15110 | Godfrey Park | 19352 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.982 | Godfrey Park | 0 | Local Park 2 | 4 | |
1965 | 1965 | 1964 | {"type": "Polygon", "coordinates": [[[-122.23947, 37.7313], [-122.23907, 37.73176], [-122.2378, 37.73113], [-122.23824, 37.73064], [-122.23947, 37.7313]]]} | Open Access 1 | 15113 | Doc Harrington Park | 18177 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.094 | Doc Harrington Park | 0 | Local Park 2 | 4 | |
1968 | 1968 | 1967 | {"type": "Polygon", "coordinates": [[[-122.24109, 37.75354], [-122.2401, 37.75443], [-122.23818, 37.75321], [-122.2392, 37.7522], [-122.24109, 37.75354]]]} | Open Access 1 | 15123 | Krusi Park | 20727 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 7.492 | Krusi Park | 2000 | Local Park 2 | 4 | |
1969 | 1969 | 1968 | {"type": "Polygon", "coordinates": [[[-122.23152, 37.75852], [-122.2309, 37.75909], [-122.22784, 37.75697], [-122.22846, 37.75639], [-122.23152, 37.75852]]]} | Open Access 1 | 15126 | Lincoln Park | 21260 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 7.412 | Lincoln Park | 0 | Local Park 2 | 4 | |
3429 | 3429 | 3428 | {"type": "Polygon", "coordinates": [[[-122.28869, 37.78989], [-122.28434, 37.79], [-122.28434, 37.78999], [-122.2844, 37.78926], [-122.28472, 37.78911], [-122.28521, 37.78928], [-122.28707, 37.78929], [-122.28729, 37.78923], [-122.28753, 37.78908], [-122.28867, 37.78906], [-122.28869, 37.78989]]]} | Open Access 1 | 48739 | Estuary Park | 33465 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | https://www.alamedaca.gov/Departments/Recreation-Parks/Estuary-Park | Alameda 17 | 7.72 | Estuary Park | 2017 | Local Park 2 | 4 |
4062 | 4062 | 4061 | {"type": "Polygon", "coordinates": [[[-122.30734, 37.78918], [-122.30729, 37.7897], [-122.30701, 37.78969], [-122.30686, 37.78973], [-122.30677, 37.78959], [-122.3068, 37.78922], [-122.30689, 37.78916], [-122.30734, 37.78918]]]} | Open Access 1 | 47050 | City View Skate Park | 30700 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 0.667 | City View Skate Park | 0 | Local Recreation Area 3 | 4 | |
4101 | 4101 | 4100 | {"type": "Polygon", "coordinates": [[[-122.2971, 37.78993], [-122.29707, 37.79023], [-122.29505, 37.79057], [-122.29505, 37.78997], [-122.29569, 37.79], [-122.29571, 37.78985], [-122.2971, 37.78993]]]} | Open Access 1 | 47052 | Main Street Dog Park | 30702 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.363 | Main Street Dog Park | 0 | Local Park 2 | 4 | |
4104 | 4104 | 4103 | {"type": "Polygon", "coordinates": [[[-122.28814, 37.78267], [-122.28814, 37.78306], [-122.28666, 37.78304], [-122.28669, 37.78184], [-122.28791, 37.78185], [-122.28808, 37.78232], [-122.28799, 37.78241], [-122.28798, 37.78247], [-122.28798, 37.78253], [-122.28804, 37.78262], [-122.28814, 37.78267]]]} | Open Access 1 | 47045 | Bayport Park | 30695 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.003 | Bayport 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]);