superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 465
- San Diego, City of 433
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 218
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 124
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 94
- Modesto, City of 84
- Stockton, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 69
- Chula Vista, City of 69
- Brentwood, City of 68
- Poway, City of 67
- Newport Beach, City of 65
- Santa Barbara, City of 64
- Davis, City of 64
- San Luis Obispo, City of 63
- Napa, City of 62
- Clovis, City of 62
- Bakersfield, City of 61
- Manteca, City of 60
- Anaheim, City of 59
- …
ACCESS_TYP 4
- Open Access 9,670
- Restricted Access 356
- No Public Access 155
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,210 ✖
Link | rowid ▲ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15638 | 15638 | 15637 | {"type": "Polygon", "coordinates": [[[-118.30381, 33.8416], [-118.30351, 33.84181], [-118.30348, 33.84181], [-118.30348, 33.84153], [-118.30381, 33.84153], [-118.30381, 33.8416]]]} | Open Access 1 | Denker and Torrance Pocket Park | 28812 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.158 | Denker and Torrance PP | ||
15637 | 15637 | 15636 | {"type": "Polygon", "coordinates": [[[-118.28476, 33.94818], [-118.28463, 33.94818], [-118.28463, 33.9478], [-118.28476, 33.9478], [-118.28476, 33.94818]]]} | Open Access 1 | 97th Street Pocket Park | 28803 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.128 | 97th Street PP | ||
15636 | 15636 | 15635 | {"type": "Polygon", "coordinates": [[[-118.26074, 33.99884], [-118.26054, 33.99884], [-118.26054, 33.99864], [-118.26074, 33.99864], [-118.26074, 33.99884]]]} | Open Access 1 | McKinley Avenue Pocket Park | 28744 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.105 | McKinley Avenue PP | ||
15635 | 15635 | 15634 | {"type": "Polygon", "coordinates": [[[-119.70562, 36.82441], [-119.70528, 36.82441], [-119.70528, 36.82399], [-119.70561, 36.82399], [-119.70562, 36.82441]]]} | Open Access 1 | Well 2 Pocket Park | 27340 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.341 | Well 2 PP | ||
15634 | 15634 | 15633 | {"type": "Polygon", "coordinates": [[[-121.75843, 37.31072], [-121.75837, 37.31075], [-121.75822, 37.31075], [-121.75822, 37.31063], [-121.75835, 37.31052], [-121.75835, 37.31019], [-121.75832, 37.3101], [-121.75788, 37.30937], [-121.75761, 37.30857], [-121.75794, 37.30839], [-121.7582, 37.30916], [-121.75845, 37.30964], [-121.75856, 37.31004], [-121.75856, 37.31025], [-121.75855, 37.31038], [-121.75849, 37.31059], [-121.75843, 37.31072]]]} | Open Access 1 | Pocket Park No.1 | 23840 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.828 | PP No.1 | 2004 | |
15633 | 15633 | 15632 | {"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.76555, 37.32066], [-121.76552, 37.3207], [-121.76566, 37.32037], [-121.76558, 37.32011], [-121.76539, 37.32005], [-121.76543, 37.32002], [-121.76552, 37.31999], [-121.76554, 37.31992], [-121.76513, 37.31821], [-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 | Pocket Park No. 9 | 23839 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.945 | PP No. 9 | ||
15632 | 15632 | 15631 | {"type": "Polygon", "coordinates": [[[-121.76202, 37.3228], [-121.76181, 37.32286], [-121.76161, 37.32298], [-121.76142, 37.32279], [-121.76175, 37.32258], [-121.76187, 37.32271], [-121.76202, 37.3228]]]} | Open Access 1 | Pocket Park No. 8 | 23838 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.273 | PP No. 8 | ||
15631 | 15631 | 15630 | {"type": "Polygon", "coordinates": [[[-121.77639, 37.32081], [-121.77612, 37.32119], [-121.77631, 37.32163], [-121.77623, 37.32153], [-121.77614, 37.32145], [-121.77603, 37.32139], [-121.77586, 37.32132], [-121.77569, 37.3213], [-121.77558, 37.3213], [-121.77505, 37.3214], [-121.77494, 37.3214], [-121.77473, 37.32136], [-121.77464, 37.32132], [-121.77452, 37.32123], [-121.77444, 37.32112], [-121.7744, 37.32104], [-121.77425, 37.32017], [-121.77413, 37.31974], [-121.77374, 37.31908], [-121.77368, 37.31894], [-121.77366, 37.31879], [-121.77368, 37.3186], [-121.77376, 37.31843], [-121.77386, 37.3183], [-121.77402, 37.31818], [-121.77409, 37.31816], [-121.77418, 37.31816], [-121.77424, 37.31822], [-121.77434, 37.31857], [-121.7743, 37.31864], [-121.7743, 37.3187], [-121.77437, 37.31876], [-121.77436, 37.31882], [-121.77482, 37.3196], [-121.77485, 37.3199], [-121.775, 37.32023], [-121.77517, 37.32092], [-121.77593, 37.32081], [-121.77594, 37.32078], [-121.77599, 37.32075], [-121.77602, 37.32072], [-121.77607, 37.32073], [-121.77623, 37.32072], [-121.77624, 37.32077], [-121.77628, 37.32081], [-121.77633, 37.32082], [-121.77639, 37.32081]]]} | Open Access 1 | Pocket Park No. 6 | 23836 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.796 | PP No. 6 | 2004 | |
15630 | 15630 | 15629 | {"type": "MultiPolygon", "coordinates": [[[[-121.77122, 37.32389], [-121.77105, 37.32387], [-121.77102, 37.32368], [-121.77098, 37.32363], [-121.77095, 37.32344], [-121.77113, 37.32346], [-121.77115, 37.32364], [-121.77119, 37.32368], [-121.77122, 37.32389]]], [[[-121.77133, 37.32443], [-121.77116, 37.32444], [-121.77111, 37.32402], [-121.77128, 37.32402], [-121.77133, 37.32443]]], [[[-121.77142, 37.32496], [-121.77125, 37.32498], [-121.77117, 37.32458], [-121.77135, 37.32456], [-121.77142, 37.32496]]]]} | Open Access 1 | Pocket Park No. 4 | 23834 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.527 | PP No. 4 | 2004 | |
15629 | 15629 | 15628 | {"type": "Polygon", "coordinates": [[[-121.76669, 37.22574], [-121.76663, 37.22596], [-121.76591, 37.22583], [-121.76587, 37.22585], [-121.76581, 37.22583], [-121.76574, 37.22582], [-121.76565, 37.22586], [-121.7653, 37.2258], [-121.76528, 37.22575], [-121.76496, 37.22569], [-121.7649, 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.76335, 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.76392, 37.22546], [-121.764, 37.22546], [-121.76438, 37.22554], [-121.76439, 37.22561], [-121.76469, 37.22566], [-121.76481, 37.2256], [-121.76486, 37.22562], [-121.76494, 37.22562], [-121.76497, 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.76627, 37.22582], [-121.76633, 37.22568], [-121.76669, 37.22574]]]} | Open Access 1 | Pocket Park No. 23 | 23833 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.09 | PP No. 23 | ||
15628 | 15628 | 15627 | {"type": "Polygon", "coordinates": [[[-121.76791, 37.22188], [-121.7678, 37.22199], [-121.76752, 37.22184], [-121.76754, 37.22179], [-121.76752, 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.76616, 37.22045], [-121.76608, 37.22047], [-121.766, 37.22042], [-121.76601, 37.22032], [-121.76575, 37.22015], [-121.76575, 37.22011], [-121.76572, 37.22006], [-121.76555, 37.21996], [-121.76558, 37.21988], [-121.76554, 37.21981], [-121.76547, 37.21978], [-121.76549, 37.21972], [-121.76505, 37.21929], [-121.76511, 37.21924], [-121.76512, 37.21917], [-121.7651, 37.21912], [-121.76504, 37.21908], [-121.76507, 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.76514, 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.76569, 37.21978], [-121.76593, 37.21995], [-121.76587, 37.22002], [-121.76588, 37.22007], [-121.76613, 37.22022], [-121.76617, 37.22028], [-121.76656, 37.22048], [-121.76652, 37.22054], [-121.76653, 37.22059], [-121.76673, 37.22071], [-121.76668, 37.22075], [-121.76666, 37.22079], [-121.76666, 37.22084], [-121.76669, 37.22088], [-121.76676, 37.22092], [-121.7668, 37.22098], [-121.76706, 37.22114], [-121.76703, 37.2212], [-121.76705, 37.22125], [-121.76727, 37.22139], [-121.76732, 37.22146], [-121.76742, 37.22148], [-121.76742, 37.22151], [-121.76769, 37.22166], [-121.76767, 37.2217], [-121.76768, 37.22174], [-121.76791, 37.22188]]]} | Open Access 1 | Pocket Park No. 22 | 23832 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.76 | PP No. 22 | ||
15627 | 15627 | 15626 | {"type": "MultiPolygon", "coordinates": [[[[-118.20568, 34.02733], [-118.20539, 34.02778], [-118.20493, 34.02779], [-118.20493, 34.02775], [-118.20499, 34.0276], [-118.20503, 34.0276], [-118.20511, 34.02738], [-118.20517, 34.0271], [-118.20568, 34.02733]]], [[[-118.20739, 34.02678], [-118.20683, 34.02766], [-118.20523, 34.02694], [-118.2053, 34.02684], [-118.20538, 34.02676], [-118.20611, 34.02621], [-118.20739, 34.02678]]], [[[-118.20668, 34.02778], [-118.20572, 34.02785], [-118.20551, 34.02776], [-118.20544, 34.02778], [-118.20572, 34.02735], [-118.20668, 34.02778]]]]} | Open Access 1 | Ramon Garcia Recreation Center | 24110 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 5.705 | Ramon Garcia Rec. Ctr. | ||
15626 | 15626 | 15625 | {"type": "Polygon", "coordinates": [[[-118.46539, 33.99607], [-118.46473, 33.99643], [-118.46421, 33.99576], [-118.46399, 33.99551], [-118.46423, 33.99539], [-118.46427, 33.9954], [-118.46441, 33.99553], [-118.46441, 33.99551], [-118.46429, 33.99538], [-118.46428, 33.99531], [-118.46421, 33.99531], [-118.46419, 33.99533], [-118.4642, 33.99537], [-118.46398, 33.99548], [-118.46333, 33.99472], [-118.46333, 33.99468], [-118.4636, 33.99429], [-118.46539, 33.99607]]]} | Open Access 1 | Oakwood Recreation Center | 23039 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.557 | Oakwood Rec. Ctr. | ||
15622 | 15622 | 15621 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 0.468 | Civic Ctr. Park | ||
15620 | 15620 | 15619 | {"type": "Polygon", "coordinates": [[[-118.244, 33.99945], [-118.244, 34.00174], [-118.24354, 34.00179], [-118.24362, 33.99941], [-118.244, 33.99945]]]} | Open Access 1 | Fred Roberts Recreation Center | http://www.laparks.org/ | 29143 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 2.494 | Fred Roberts Rec. Ctr. | |
15619 | 15619 | 15618 | {"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.04445], [-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.04101], [-118.52333, 34.04086], [-118.52344, 34.04061], [-118.5241, 34.04082], [-118.52413, 34.04044], [-118.52444, 34.04054], [-118.52447, 34.03997], [-118.52501, 34.04047], [-118.52589, 34.04059], [-118.52603, 34.04074]]]} | Open Access 1 | Palisades Park & Recreation Center | http://www.laparks.org/dos/reccenter/facility/palisadesRC.htm | 28791 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 17.56 | Palisades Park & Rec. Ctr. | |
15618 | 15618 | 15617 | {"type": "Polygon", "coordinates": [[[-118.2263, 34.08911], [-118.22518, 34.08976], [-118.22487, 34.08994], [-118.22508, 34.08832], [-118.22601, 34.0884], [-118.2263, 34.08911]]]} | Open Access 1 | Cypress Recreation Center | http://www.laparks.org/dos/reccenter/facility/cypressRC.htm | 28725 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.501 | Cypress Rec. Ctr. | |
15616 | 15616 | 15615 | {"type": "MultiPolygon", "coordinates": [[[[-117.04446, 32.557], [-117.04413, 32.55699], [-117.04415, 32.5563], [-117.04445, 32.55646], [-117.04446, 32.557]]], [[[-117.04445, 32.55613], [-117.04415, 32.55597], [-117.04415, 32.55467], [-117.04444, 32.55467], [-117.04445, 32.55613]]], [[[-117.04445, 32.55264], [-117.04444, 32.55455], [-117.04415, 32.55456], [-117.04416, 32.55236], [-117.04445, 32.5524], [-117.04445, 32.55264]]]]} | Open Access 1 | San Ysidro Community Park and Recreation Center | 25001 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 3.149 | San Ysidro Community Park and Rec. Ctr. | ||
15615 | 15615 | 15614 | {"type": "Polygon", "coordinates": [[[-118.19124, 34.08545], [-118.19087, 34.08586], [-118.18962, 34.08586], [-118.19055, 34.08484], [-118.19095, 34.08509], [-118.19086, 34.0852], [-118.19124, 34.08545]]]} | Open Access 1 | Rose Hill Recreation Center | 24611 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.266 | Rose Hill Rec. Ctr. | ||
15612 | 15612 | 15611 | {"type": "Polygon", "coordinates": [[[-117.04676, 32.56542], [-117.04503, 32.56542], [-117.04504, 32.56485], [-117.04551, 32.56485], [-117.04578, 32.5649], [-117.0459, 32.56494], [-117.04676, 32.56542]]]} | Open Access 1 | Colonel Irving Salomon San Ysidro Community Activity Center | https://www.sandiego.gov/park-and-recreation/centers/recctr/colonel | 31314 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1.766 | Colonel Irving Salomon San Ysidro Community Activity Ctr. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);