units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,394 rows where AGNCY_LEV = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 525
- Los Angeles, City of 485
- San Jose, City of 253
- San Francisco, City and County of 238
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 144
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 90
- Modesto, City of 85
- Santa Rosa, City of 82
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Cruz, City of 72
- Torrance, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- Davis, City of 65
- San Luis Obispo, City of 64
- Santa Barbara, City of 64
- Newport Beach, City of 64
- Glendale, City of 61
- Bakersfield, City of 61
- Manteca, City of 61
- Riverside, City of 60
- …
DES_TP >30
- Local Park 7,352
- Local Recreation Area 1,414
- Local Other or Unknown 661
- Local Conservation Area 149
- Local Historic or Cultural Area 38
- Local Resource Management Area 6
- National Monument or Landmark 5
- State Conservation Area 2
- 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
- …
MNG_AG_TYP 14
- City Agency 10,292
- Open Space District 21
- Recreation/Parks District 19
- County Agency 16
- Non Profit - Other 11
- Commercial 9
- Non Profit - Conservation 7
- State Agency 5
- County Agency - Parks 4
- Other 3
- County Agency - Other 2
- Non Profit - Land Trust 2
- Port/Harbor District 2
- Community Services District 1
ACCESS_TYP 4
- Open Access 9,898
- Restricted Access 260
- No Public Access 207
- Unknown Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17068 | 17068 | 17067 | {"type": "Polygon", "coordinates": [[[-118.41271, 34.21563], [-118.41251, 34.21562], [-118.41224, 34.21561], [-118.41271, 34.21543], [-118.41278, 34.21558], [-118.41276, 34.21562], [-118.41271, 34.21563]]]} | Open Access 1 | 45531 | Bellaire Avenue Pocket Park | 28362 | 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://cd2.lacity.org/DISTRICT2/CD2Resources/index.htm | Los Angeles 6 | 0.138 | Bellaire Avenue PP | 0 | Local Park 2 | 4 |
17067 | 17067 | 17066 | {"type": "Polygon", "coordinates": [[[-121.76791, 37.22188], [-121.7678, 37.22199], [-121.76752, 37.22184], [-121.76754, 37.22178], [-121.76753, 37.22174], [-121.76718, 37.22154], [-121.76716, 37.22149], [-121.7669, 37.22132], [-121.76693, 37.22126], [-121.76691, 37.2212], [-121.76669, 37.22107], [-121.76666, 37.22107], [-121.76662, 37.22102], [-121.76656, 37.221], [-121.76657, 37.22092], [-121.7663, 37.22076], [-121.7664, 37.22065], [-121.76639, 37.2206], [-121.76615, 37.22045], [-121.76608, 37.22047], [-121.76604, 37.22044], [-121.766, 37.22042], [-121.76602, 37.22032], [-121.76575, 37.22015], [-121.76575, 37.22011], [-121.76572, 37.22006], [-121.76555, 37.21996], [-121.76557, 37.21992], [-121.76558, 37.21988], [-121.76554, 37.21981], [-121.76547, 37.21978], [-121.7655, 37.21972], [-121.76505, 37.21929], [-121.76511, 37.21924], [-121.76512, 37.21917], [-121.7651, 37.21912], [-121.76504, 37.21908], [-121.76508, 37.21899], [-121.76499, 37.2189], [-121.76516, 37.21858], [-121.7651, 37.21845], [-121.76515, 37.21837], [-121.76515, 37.21833], [-121.76513, 37.21829], [-121.76531, 37.21817], [-121.76532, 37.21813], [-121.7652, 37.218], [-121.76492, 37.21776], [-121.76511, 37.21764], [-121.76526, 37.21758], [-121.76544, 37.21754], [-121.7656, 37.21754], [-121.76578, 37.21757], [-121.76662, 37.21783], [-121.76665, 37.21786], [-121.76666, 37.2179], [-121.76663, 37.21795], [-121.76646, 37.2181], [-121.76624, 37.21789], [-121.76568, 37.21816], [-121.76524, 37.21843], [-121.76521, 37.21848], [-121.76521, 37.21852], [-121.76537, 37.21871], [-121.76527, 37.21878], [-121.76516, 37.21883], [-121.76513, 37.21888], [-121.76514, 37.21894], [-121.76518, 37.21899], [-121.76524, 37.21901], [-121.76524, 37.21916], [-121.76537, 37.21936], [-121.7656, 37.21952], [-121.76558, 37.2196], [-121.76562, 37.21966], [-121.76572, 37.21969], [-121.76568, 37.21978], [-121.76593, 37.21995], [-121.76587, 37.22002], [-121.76587, 37.22007], [-121.76613, 37.22022], [-121.76617, 37.22028], [-121.76656, 37.22048], [-121.76652, 37.22054], [-121.76653, 37.2206], [-121.76673, 37.22071], [-121.76668, 37.22075], [-121.76666, 37.22079], [-121.76666, 37.22084], [-121.76669, 37.22089], [-121.76676, 37.22092], [-121.7668, 37.22098], [-121.76706, 37.22114], [-121.76703, 37.22119], [-121.76704, 37.22125], [-121.76727, 37.22139], [-121.76732, 37.22146], [-121.76742, 37.22148], [-121.76741, 37.22151], [-121.76769, 37.22166], [-121.76767, 37.2217], [-121.76768, 37.22174], [-121.76791, 37.22188]]]} | Open Access 1 | 38003 | Pocket Park No. 22 | 23832 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.747 | PP No. 22 | 0 | Local Park 2 | 4 | |
17066 | 17066 | 17065 | {"type": "Polygon", "coordinates": [[[-121.75072, 38.57381], [-121.75068, 38.57385], [-121.75067, 38.57395], [-121.75049, 38.57408], [-121.75035, 38.57409], [-121.75035, 38.57399], [-121.7503, 38.57395], [-121.75016, 38.57394], [-121.75011, 38.57395], [-121.75011, 38.57366], [-121.75016, 38.57367], [-121.75028, 38.57367], [-121.75032, 38.57366], [-121.75035, 38.57362], [-121.75065, 38.57367], [-121.75065, 38.57373], [-121.75072, 38.57381]]]} | Open Access 1 | 20971 | Northstar Pocket Park | 22894 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.474 | Northstar PP | 0 | Local Park 2 | 4 | |
17065 | 17065 | 17064 | {"type": "Polygon", "coordinates": [[[-121.7242, 37.95297], [-121.72419, 37.95332], [-121.72412, 37.95332], [-121.72407, 37.9533], [-121.72405, 37.95326], [-121.72406, 37.95297], [-121.7242, 37.95297]]]} | Open Access 1 | 47939 | Giotto Pocket Park | 32097 | 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.112 | Giotto PP | 0 | Local Park 2 | 4 | |
17064 | 17064 | 17063 | {"type": "Polygon", "coordinates": [[[-121.76669, 37.22574], [-121.76663, 37.22596], [-121.76591, 37.22583], [-121.76587, 37.22585], [-121.76581, 37.22583], [-121.76573, 37.22582], [-121.76565, 37.22586], [-121.7653, 37.2258], [-121.76528, 37.22575], [-121.76496, 37.22569], [-121.76491, 37.22572], [-121.76483, 37.22569], [-121.76475, 37.22571], [-121.76399, 37.22558], [-121.76395, 37.22554], [-121.76389, 37.22553], [-121.76383, 37.22553], [-121.76377, 37.22556], [-121.76341, 37.22549], [-121.76336, 37.2254], [-121.76308, 37.22534], [-121.76301, 37.22529], [-121.76293, 37.22528], [-121.76287, 37.2253], [-121.76288, 37.22524], [-121.76284, 37.22519], [-121.7625, 37.22512], [-121.76196, 37.22487], [-121.76201, 37.22481], [-121.76254, 37.22507], [-121.76289, 37.22513], [-121.76293, 37.22519], [-121.76298, 37.22521], [-121.76305, 37.22522], [-121.76311, 37.2252], [-121.76347, 37.22527], [-121.76346, 37.22534], [-121.76349, 37.22538], [-121.76378, 37.22543], [-121.76383, 37.22542], [-121.76391, 37.22546], [-121.764, 37.22546], [-121.76438, 37.22554], [-121.76438, 37.2256], [-121.7647, 37.22566], [-121.76481, 37.2256], [-121.76486, 37.22562], [-121.76494, 37.22562], [-121.76496, 37.22566], [-121.76532, 37.22572], [-121.76535, 37.22577], [-121.76564, 37.22582], [-121.76579, 37.22574], [-121.76585, 37.22575], [-121.76591, 37.22574], [-121.76593, 37.22576], [-121.76628, 37.22582], [-121.76633, 37.22568], [-121.76669, 37.22574]]]} | Open Access 1 | 13735 | Pocket Park No. 23 | 23833 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.085 | PP No. 23 | 0 | Local Park 2 | 4 | |
17063 | 17063 | 17062 | {"type": "Polygon", "coordinates": [[[-121.76351, 37.30514], [-121.76338, 37.30509], [-121.76282, 37.30517], [-121.76274, 37.30486], [-121.76297, 37.30491], [-121.76349, 37.30511], [-121.76351, 37.30514]]]} | Open Access 1 | 13733 | Pocket Park No. 20 | 23830 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.259 | PP No. 20 | 1984 | Local Park 2 | 4 | |
17062 | 17062 | 17061 | {"type": "MultiPolygon", "coordinates": [[[[-121.76611, 37.32191], [-121.76591, 37.32205], [-121.76582, 37.32206], [-121.76254, 37.32081], [-121.7625, 37.32079], [-121.76248, 37.32075], [-121.76251, 37.32068], [-121.76255, 37.32069], [-121.76252, 37.32071], [-121.76252, 37.32075], [-121.76264, 37.3208], [-121.76275, 37.32081], [-121.76562, 37.32189], [-121.76566, 37.32193], [-121.76575, 37.32197], [-121.76579, 37.32197], [-121.76581, 37.32196], [-121.76581, 37.32191], [-121.76595, 37.32167], [-121.76592, 37.32153], [-121.76602, 37.32154], [-121.76611, 37.32191]]], [[[-121.76598, 37.32139], [-121.76582, 37.32138], [-121.76585, 37.32123], [-121.76577, 37.32089], [-121.7656, 37.32091], [-121.76564, 37.32082], [-121.76572, 37.32075], [-121.76571, 37.32068], [-121.76566, 37.32065], [-121.76561, 37.32064], [-121.76556, 37.32066], [-121.76552, 37.3207], [-121.76566, 37.32037], [-121.76558, 37.3201], [-121.76539, 37.32005], [-121.76543, 37.32002], [-121.76552, 37.31999], [-121.76554, 37.31993], [-121.76513, 37.3182], [-121.76416, 37.31835], [-121.76396, 37.31844], [-121.76385, 37.31855], [-121.7638, 37.31837], [-121.76521, 37.31816], [-121.76598, 37.32139]]]]} | Open Access 1 | 9194 | Pocket Park No. 9 | 23839 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.933 | PP No. 9 | 0 | Local Park 2 | 4 | |
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 | |
17053 | 17053 | 17052 | {"type": "Polygon", "coordinates": [[[-118.20385, 34.15912], [-118.20364, 34.15913], [-118.20283, 34.15904], [-118.20265, 34.15903], [-118.20242, 34.15906], [-118.20215, 34.15918], [-118.20198, 34.15931], [-118.20187, 34.15946], [-118.20181, 34.15961], [-118.20163, 34.16029], [-118.20152, 34.16049], [-118.20134, 34.16069], [-118.20113, 34.16084], [-118.20035, 34.16128], [-118.19998, 34.16144], [-118.19952, 34.16158], [-118.19932, 34.16163], [-118.19902, 34.16167], [-118.19849, 34.16169], [-118.19592, 34.16158], [-118.19553, 34.16156], [-118.19518, 34.16157], [-118.19473, 34.16163], [-118.19442, 34.1617], [-118.19389, 34.16188], [-118.19365, 34.16167], [-118.19365, 34.16163], [-118.19384, 34.16147], [-118.19386, 34.16142], [-118.19384, 34.16133], [-118.19377, 34.1612], [-118.19376, 34.16113], [-118.19382, 34.16092], [-118.19381, 34.16077], [-118.19383, 34.16072], [-118.19397, 34.16063], [-118.19415, 34.16047], [-118.1942, 34.16046], [-118.19428, 34.16047], [-118.19437, 34.16057], [-118.19449, 34.16065], [-118.19459, 34.16067], [-118.19469, 34.16066], [-118.19481, 34.16059], [-118.19508, 34.16038], [-118.1952, 34.16036], [-118.19532, 34.16032], [-118.19559, 34.16013], [-118.19567, 34.16001], [-118.19576, 34.15995], [-118.19586, 34.15985], [-118.19589, 34.15979], [-118.1959, 34.1593], [-118.19593, 34.15921], [-118.19598, 34.15913], [-118.19606, 34.15906], [-118.19614, 34.15902], [-118.19629, 34.15897], [-118.1965, 34.15894], [-118.19678, 34.15894], [-118.19707, 34.15878], [-118.19761, 34.15832], [-118.19787, 34.15792], [-118.19805, 34.15789], [-118.1985, 34.1582], [-118.19855, 34.15817], [-118.19866, 34.15816], [-118.199, 34.15799], [-118.1992, 34.15792], [-118.19932, 34.15784], [-118.19949, 34.15777], [-118.19957, 34.1577], [-118.19971, 34.15763], [-118.19978, 34.1576], [-118.19992, 34.15761], [-118.20004, 34.15771], [-118.2004, 34.15772], [-118.20115, 34.15799], [-118.20281, 34.15819], [-118.20278, 34.1576], [-118.20345, 34.15779], [-118.20361, 34.15821], [-118.20366, 34.15888], [-118.20384, 34.15885], [-118.20385, 34.15912]]]} | Restricted Access 2 | 6955 | Scholl Canyon Golf Course & Tennis Center | 29385 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 6098 | American Golf 1103 | Private 7 | Commercial 18 | http://www.schollcanyongc.com/ | Los Angeles 6 | 60.199 | Scholl Canyon GC & Tennis Ctr. | None 1427 | ||
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 |
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]);