units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,414 rows where AGNCY_LEV = 2 and DES_TP = 3 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 7
ACCESS_TYP 4
- Open Access 1,229
- Restricted Access 140
- No Public Access 39
- Unknown Access 6
DES_TP 1
- Local Recreation Area · 1,414 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15031 | 15031 | 15030 | {"type": "Polygon", "coordinates": [[[-122.83393, 41.61987], [-122.83324, 41.62052], [-122.83325, 41.62054], [-122.83331, 41.62054], [-122.83314, 41.62075], [-122.83212, 41.62027], [-122.83205, 41.62032], [-122.83181, 41.62017], [-122.83282, 41.61921], [-122.83393, 41.61987]]]} | Open Access 1 | 45683 | Walker Field | 28497 | 1701 | Fort Jones, City of 1135 | City 2 | City Agency 2 | City 2 | 1701 | Fort Jones, City of 1090 | City 2 | City Agency 2 | Siskiyou 28 | 3.716 | Walker Field | 0 | Local Recreation Area 3 | 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 | |
4107 | 4107 | 4106 | {"type": "Polygon", "coordinates": [[[-122.30486, 37.78899], [-122.30487, 37.78905], [-122.3047, 37.79053], [-122.30344, 37.79025], [-122.30345, 37.79004], [-122.30357, 37.79001], [-122.30361, 37.78948], [-122.30357, 37.78946], [-122.30359, 37.7889], [-122.30486, 37.78899]]]} | Open Access 1 | 47048 | Multipurpose Field | 30698 | 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.381 | Multipurpose Field | 0 | Local Recreation Area 3 | 4 | |
14448 | 14448 | 14447 | {"type": "Polygon", "coordinates": [[[-122.29245, 37.77738], [-122.29241, 37.77968], [-122.292, 37.77973], [-122.29174, 37.77979], [-122.29165, 37.77978], [-122.29156, 37.77971], [-122.29141, 37.77947], [-122.29133, 37.77887], [-122.29138, 37.77735], [-122.29245, 37.77738]]]} | Open Access 1 | 47059 | Main Street Soccer Field | 30710 | 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 | 6.06 | Main Street Soccer Field | 0 | Local Recreation Area 3 | 4 | |
14417 | 14417 | 14416 | {"type": "Polygon", "coordinates": [[[-123.9855, 40.88189], [-123.98541, 40.88195], [-123.98525, 40.88184], [-123.98534, 40.88177], [-123.9855, 40.88189]]]} | Open Access 1 | 47033 | City of Blue Lake Tot Lot | 30684 | 1443 | Blue Lake, City of 716 | City 2 | City Agency 2 | http://bluelake.ca.gov/ | City 2 | 1443 | Blue Lake, City of 699 | City 2 | City Agency 2 | Humboldt 45 | 0.047 | City of Blue Lake Tot Lot | 0 | Local Recreation Area 3 | 4 | |
4419 | 4419 | 4418 | {"type": "Polygon", "coordinates": [[[-118.31176, 34.17125], [-118.31155, 34.17146], [-118.31116, 34.17117], [-118.31137, 34.17097], [-118.31176, 34.17125]]]} | Open Access 1 | 46274 | Santa Anita Playlot | 29558 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 0.353 | Santa Anita Playlot | 0 | Local Recreation Area 3 | 4 | |
6763 | 6763 | 6762 | {"type": "Polygon", "coordinates": [[[-118.32115, 34.19015], [-118.32142, 34.19036], [-118.32249, 34.19248], [-118.32247, 34.19252], [-118.32111, 34.19382], [-118.32105, 34.19384], [-118.31895, 34.19231], [-118.31893, 34.19227], [-118.32115, 34.19015]]]} | Open Access 1 | 5196 | McCambridge Park and Recreation Center | 29541 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 17.277 | McCambridge Park and Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
12611 | 12611 | 12610 | {"type": "Polygon", "coordinates": [[[-118.3045, 34.17652], [-118.30428, 34.17673], [-118.304, 34.17654], [-118.3039, 34.17665], [-118.30416, 34.17684], [-118.30387, 34.17712], [-118.30379, 34.17713], [-118.30328, 34.17677], [-118.30406, 34.17602], [-118.30415, 34.17609], [-118.30405, 34.1762], [-118.3045, 34.17652]]]} | Open Access 1 | 29307 | Robert R. Ovrom Park and Community Center | 29535 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 1.464 | Robert R. Ovrom Park and Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
13775 | 13775 | 13774 | {"type": "Polygon", "coordinates": [[[-118.30569, 34.2043], [-118.30536, 34.20526], [-118.30482, 34.20631], [-118.30485, 34.20634], [-118.30447, 34.20831], [-118.3044, 34.20885], [-118.3044, 34.20905], [-118.30441, 34.20932], [-118.3045, 34.2098], [-118.30478, 34.21066], [-118.30495, 34.2113], [-118.30514, 34.21186], [-118.3048, 34.21198], [-118.30448, 34.21216], [-118.30405, 34.21258], [-118.30397, 34.21284], [-118.30396, 34.21311], [-118.30379, 34.21316], [-118.30369, 34.21305], [-118.30356, 34.21282], [-118.30369, 34.21252], [-118.30357, 34.21209], [-118.30382, 34.2116], [-118.30382, 34.21134], [-118.30349, 34.21114], [-118.30242, 34.21098], [-118.30216, 34.21137], [-118.30195, 34.21128], [-118.30288, 34.20918], [-118.30317, 34.2082], [-118.30299, 34.20777], [-118.3024, 34.2075], [-118.30183, 34.20757], [-118.30114, 34.20747], [-118.30031, 34.20799], [-118.30006, 34.20793], [-118.30033, 34.20757], [-118.30037, 34.20724], [-118.30176, 34.20593], [-118.29979, 34.20421], [-118.29844, 34.20413], [-118.29839, 34.20362], [-118.29851, 34.20278], [-118.29836, 34.20278], [-118.29863, 34.20265], [-118.29873, 34.20257], [-118.29883, 34.2025], [-118.299, 34.20235], [-118.29915, 34.20228], [-118.29922, 34.20227], [-118.29934, 34.20227], [-118.29942, 34.20229], [-118.29959, 34.20236], [-118.29994, 34.20255], [-118.30011, 34.20259], [-118.3004, 34.20259], [-118.30062, 34.20253], [-118.30087, 34.20239], [-118.30097, 34.20232], [-118.30116, 34.20207], [-118.30145, 34.20175], [-118.30165, 34.20159], [-118.30243, 34.20112], [-118.3026, 34.20114], [-118.30281, 34.20125], [-118.30292, 34.20129], [-118.30394, 34.20147], [-118.30419, 34.20148], [-118.30424, 34.20169], [-118.30453, 34.20221], [-118.30504, 34.20306], [-118.30563, 34.20399], [-118.30569, 34.20414], [-118.30569, 34.2043]]]} | Restricted Access 2 | 46258 | DeBell Golf Course | 29545 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.debellgolf.com/ | Los Angeles 6 | 95.759 | DeBell GC | 0 | Local Recreation Area 3 | 4 |
4947 | 4947 | 4946 | {"type": "Polygon", "coordinates": [[[-122.16884, 38.07871], [-122.16854, 38.07916], [-122.1682, 38.07936], [-122.16783, 38.07951], [-122.16755, 38.07969], [-122.16756, 38.08011], [-122.16751, 38.08034], [-122.16729, 38.08055], [-122.16721, 38.08092], [-122.1669, 38.081], [-122.16654, 38.08118], [-122.16654, 38.08149], [-122.16666, 38.08169], [-122.16696, 38.08185], [-122.16793, 38.082], [-122.16805, 38.08215], [-122.1671, 38.08249], [-122.16632, 38.08239], [-122.16569, 38.08243], [-122.16459, 38.0827], [-122.16413, 38.08274], [-122.16375, 38.08249], [-122.16313, 38.08232], [-122.16256, 38.08227], [-122.16194, 38.08265], [-122.1615, 38.08322], [-122.16133, 38.08356], [-122.1602, 38.08327], [-122.15965, 38.08302], [-122.15923, 38.08311], [-122.15905, 38.08335], [-122.15909, 38.08365], [-122.15944, 38.0839], [-122.16023, 38.08416], [-122.16091, 38.08435], [-122.16162, 38.08442], [-122.16132, 38.08447], [-122.16036, 38.08443], [-122.15955, 38.0843], [-122.1591, 38.08407], [-122.15879, 38.08377], [-122.15838, 38.08295], [-122.15771, 38.08145], [-122.15953, 38.08104], [-122.15989, 38.0808], [-122.15998, 38.08036], [-122.15973, 38.08008], [-122.1594, 38.08002], [-122.15843, 38.08023], [-122.15773, 38.08039], [-122.15737, 38.08059], [-122.15697, 38.08023], [-122.1573, 38.07991], [-122.15721, 38.07952], [-122.1572, 38.07937], [-122.15636, 38.07899], [-122.15572, 38.07886], [-122.15521, 38.07879], [-122.15431, 38.07806], [-122.15439, 38.07758], [-122.15475, 38.07713], [-122.15529, 38.07692], [-122.1555, 38.07735], [-122.15737, 38.07771], [-122.15789, 38.07798], [-122.15838, 38.078], [-122.15877, 38.07787], [-122.15881, 38.07735], [-122.15841, 38.07702], [-122.1578, 38.07674], [-122.15658, 38.07661], [-122.15619, 38.07631], [-122.15681, 38.07606], [-122.15729, 38.07595], [-122.15868, 38.07592], [-122.16034, 38.07582], [-122.16222, 38.07559], [-122.16301, 38.07601], [-122.16423, 38.07647], [-122.16455, 38.07673], [-122.16487, 38.07694], [-122.16538, 38.07704], [-122.16529, 38.07722], [-122.16541, 38.0776], [-122.16625, 38.07763], [-122.16653, 38.07753], [-122.16675, 38.07768], [-122.1684, 38.07835], [-122.16851, 38.07845], [-122.1688, 38.07852], [-122.16884, 38.07871]]]} | Open Access 1 | 1683 | Tourtelot Open Space | 26481 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 160.466 | Tourtelot OS | 0 | Local Recreation Area 3 | 4 | |
9116 | 9116 | 9115 | {"type": "Polygon", "coordinates": [[[-122.15372, 38.04874], [-122.15327, 38.04939], [-122.15218, 38.04892], [-122.15261, 38.04822], [-122.15372, 38.04874]]]} | Open Access 1 | 15108 | Little League Field Park | 21345 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 2.318 | Little League Field Park | 0 | Local Recreation Area 3 | 4 | |
16015 | 16015 | 16014 | {"type": "MultiPolygon", "coordinates": [[[[-122.18915, 38.08111], [-122.18816, 38.08142], [-122.1876, 38.08186], [-122.18707, 38.08256], [-122.18641, 38.08251], [-122.1861, 38.08224], [-122.18578, 38.08227], [-122.18525, 38.08227], [-122.18498, 38.08245], [-122.18491, 38.08277], [-122.18515, 38.08286], [-122.18559, 38.08313], [-122.18531, 38.08345], [-122.18483, 38.08442], [-122.18478, 38.0848], [-122.1846, 38.08522], [-122.18437, 38.08554], [-122.18417, 38.08592], [-122.18386, 38.08611], [-122.18338, 38.08619], [-122.18322, 38.08634], [-122.18326, 38.08673], [-122.18348, 38.087], [-122.18394, 38.08727], [-122.18403, 38.08742], [-122.18363, 38.08795], [-122.18298, 38.08819], [-122.18236, 38.08866], [-122.18132, 38.08925], [-122.18064, 38.0893], [-122.18013, 38.08825], [-122.1792, 38.08617], [-122.17659, 38.07977], [-122.17735, 38.0795], [-122.17753, 38.07921], [-122.17752, 38.07896], [-122.17727, 38.0787], [-122.17747, 38.07845], [-122.17795, 38.07806], [-122.17832, 38.07825], [-122.17973, 38.07916], [-122.17993, 38.07978], [-122.18045, 38.08027], [-122.18114, 38.08053], [-122.18193, 38.08063], [-122.1826, 38.08075], [-122.18322, 38.08108], [-122.18372, 38.08066], [-122.18441, 38.08059], [-122.18483, 38.08024], [-122.18455, 38.0798], [-122.18388, 38.07958], [-122.18252, 38.07975], [-122.18118, 38.07959], [-122.18099, 38.07933], [-122.1813, 38.07936], [-122.18182, 38.07936], [-122.18226, 38.07933], [-122.18284, 38.07934], [-122.18345, 38.07933], [-122.18358, 38.07912], [-122.18476, 38.07946], [-122.1859, 38.07942], [-122.1873, 38.07874], [-122.18801, 38.0788], [-122.18853, 38.07914], [-122.1888, 38.07996], [-122.18905, 38.0806], [-122.18915, 38.08111]]], [[[-122.18868, 38.07605], [-122.18835, 38.0769], [-122.18748, 38.07752], [-122.18798, 38.07842], [-122.187, 38.07861], [-122.18632, 38.07899], [-122.18576, 38.0792], [-122.18505, 38.07926], [-122.18436, 38.07915], [-122.18442, 38.07899], [-122.18503, 38.07903], [-122.18529, 38.07876], [-122.18529, 38.07832], [-122.18486, 38.07801], [-122.18498, 38.07727], [-122.18522, 38.07681], [-122.18497, 38.07637], [-122.18415, 38.076], [-122.18356, 38.07545], [-122.18302, 38.07514], [-122.183, 38.07434], [-122.18248, 38.07396], [-122.18199, 38.07394], [-122.18166, 38.07403], [-122.18159, 38.07436], [-122.18161, 38.07488], [-122.18113, 38.07504], [-122.18088, 38.07517], [-122.18063, 38.07481], [-122.18071, 38.07442], [-122.1809, 38.07441], [-122.18101, 38.07425], [-122.18086, 38.074], [-122.18088, 38.07323], [-122.18102, 38.073], [-122.1809, 38.07262], [-122.18191, 38.07227], [-122.18349, 38.07287], [-122.18434, 38.07286], [-122.18486, 38.07238], [-122.18484, 38.07182], [-122.18531, 38.0716], [-122.18757, 38.07463], [-122.18868, 38.07605]]]]} | Open Access 1 | 2138 | Braito Open Space | 540 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 226.873 | Braito OS | 0 | Local Recreation Area 3 | 4 | |
16817 | 16817 | 16816 | {"type": "Polygon", "coordinates": [[[-122.17156, 38.09068], [-122.16649, 38.10078], [-122.16562, 38.10052], [-122.16535, 38.10047], [-122.16508, 38.10045], [-122.16489, 38.10046], [-122.16467, 38.10048], [-122.1643, 38.10055], [-122.16331, 38.101], [-122.16302, 38.1011], [-122.16279, 38.10116], [-122.16249, 38.10118], [-122.16231, 38.10117], [-122.16209, 38.10112], [-122.16174, 38.10098], [-122.1613, 38.1007], [-122.15939, 38.09942], [-122.15913, 38.09926], [-122.15853, 38.09897], [-122.15787, 38.09874], [-122.15754, 38.09866], [-122.15706, 38.09857], [-122.15675, 38.09854], [-122.1557, 38.09848], [-122.15316, 38.09839], [-122.1528, 38.09836], [-122.15254, 38.09829], [-122.15167, 38.09784], [-122.15103, 38.09757], [-122.15082, 38.09751], [-122.14879, 38.0972], [-122.14715, 38.09659], [-122.14643, 38.09624], [-122.1456, 38.09574], [-122.14421, 38.09498], [-122.14407, 38.09493], [-122.14397, 38.09284], [-122.14199, 38.09147], [-122.14182, 38.09033], [-122.14203, 38.09011], [-122.14324, 38.09017], [-122.14439, 38.09111], [-122.14572, 38.09169], [-122.14613, 38.09103], [-122.14527, 38.09077], [-122.14375, 38.08907], [-122.14378, 38.08884], [-122.14294, 38.08821], [-122.14284, 38.08776], [-122.14308, 38.08765], [-122.14439, 38.08795], [-122.14472, 38.08749], [-122.14515, 38.08679], [-122.14529, 38.08695], [-122.14529, 38.08768], [-122.14516, 38.08792], [-122.14464, 38.08835], [-122.14509, 38.08862], [-122.1456, 38.08878], [-122.14562, 38.08877], [-122.14574, 38.08883], [-122.14629, 38.08901], [-122.14666, 38.08931], [-122.14685, 38.08957], [-122.14699, 38.08971], [-122.14727, 38.08994], [-122.14773, 38.09026], [-122.1482, 38.09007], [-122.14868, 38.08944], [-122.14865, 38.08919], [-122.14889, 38.08918], [-122.14924, 38.08915], [-122.14951, 38.0891], [-122.15025, 38.08877], [-122.15144, 38.08879], [-122.15215, 38.08861], [-122.15244, 38.08846], [-122.15336, 38.08773], [-122.15393, 38.08736], [-122.15397, 38.08736], [-122.15406, 38.0873], [-122.15428, 38.08721], [-122.15449, 38.0872], [-122.15492, 38.08737], [-122.1554, 38.0876], [-122.15617, 38.08794], [-122.15623, 38.08787], [-122.15636, 38.08795], [-122.15659, 38.0884], [-122.15708, 38.08888], [-122.15769, 38.08893], [-122.15817, 38.08892], [-122.15851, 38.08897], [-122.15902, 38.08918], [-122.15994, 38.08931], [-122.16075, 38.08914], [-122.16113, 38.08875], [-122.16142, 38.08812], [-122.16146, 38.08789], [-122.16126, 38.08762], [-122.1611, 38.0872], [-122.16132, 38.08696], [-122.1619, 38.08644], [-122.17084, 38.09032], [-122.17156, 38.09068]]]} | Open Access 1 | 17247 | Lake Herman Recreation Area | 29223 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | http://solanoopenspace.org/OtherOutdoor.asp | Solano 26 | 633.303 | Lake Herman Rec. Area | 0 | Local Recreation Area 3 | 4 |
7152 | 7152 | 7151 | {"type": "Polygon", "coordinates": [[[-118.28161, 33.82353], [-118.28159, 33.82354], [-118.28161, 33.82416], [-118.28159, 33.82417], [-118.28159, 33.82421], [-118.28154, 33.82427], [-118.27952, 33.82426], [-118.27951, 33.82305], [-118.27944, 33.82304], [-118.27944, 33.82278], [-118.27951, 33.82275], [-118.27951, 33.82195], [-118.2816, 33.82196], [-118.28161, 33.82353]]]} | Open Access 1 | 6249 | Veterans Park and Sports Complex | 27058 | 1048 | Carson, City of 304 | City 2 | City Agency 2 | http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp | City 2 | 1048 | Carson, City of 300 | City 2 | City Agency 2 | Los Angeles 6 | 12.319 | Veterans Park and Sports Complex | 0 | Local Recreation Area 3 | 4 | |
16221 | 16221 | 16220 | {"type": "Polygon", "coordinates": [[[-121.9305, 37.9469], [-121.92784, 37.9479], [-121.92463, 37.94919], [-121.92428, 37.94883], [-121.92252, 37.94895], [-121.92223, 37.94883], [-121.9219, 37.94872], [-121.92131, 37.94859], [-121.92078, 37.94851], [-121.92023, 37.94847], [-121.91938, 37.94838], [-121.91908, 37.94839], [-121.91797, 37.94851], [-121.91718, 37.94867], [-121.91666, 37.94852], [-121.91642, 37.94838], [-121.91616, 37.94832], [-121.91613, 37.94837], [-121.91608, 37.94823], [-121.9159, 37.94827], [-121.91598, 37.94853], [-121.9159, 37.94853], [-121.91583, 37.94828], [-121.9156, 37.94826], [-121.91549, 37.94855], [-121.9154, 37.9487], [-121.91517, 37.94892], [-121.91511, 37.94892], [-121.91504, 37.94893], [-121.91499, 37.94897], [-121.91496, 37.94901], [-121.91457, 37.94901], [-121.91445, 37.93618], [-121.91437, 37.92671], [-121.91905, 37.9267], [-121.92053, 37.9274], [-121.92054, 37.92744], [-121.92044, 37.92758], [-121.9201, 37.92829], [-121.91994, 37.92846], [-121.91971, 37.9286], [-121.91943, 37.92868], [-121.91867, 37.92876], [-121.91841, 37.92875], [-121.91815, 37.92859], [-121.91794, 37.92861], [-121.91742, 37.92859], [-121.9171, 37.92882], [-121.9169, 37.9289], [-121.91693, 37.92927], [-121.91714, 37.92944], [-121.91729, 37.92953], [-121.91715, 37.92967], [-121.91718, 37.92988], [-121.91698, 37.93003], [-121.91681, 37.93033], [-121.91612, 37.93063], [-121.91601, 37.93105], [-121.91631, 37.93118], [-121.91666, 37.93088], [-121.91683, 37.93086], [-121.9174, 37.93102], [-121.91734, 37.93066], [-121.9175, 37.93052], [-121.91788, 37.93052], [-121.91795, 37.93036], [-121.91862, 37.9301], [-121.91881, 37.92987], [-121.91926, 37.92992], [-121.91954, 37.92998], [-121.91983, 37.9301], [-121.92035, 37.93054], [-121.92072, 37.9308], [-121.9225, 37.93346], [-121.92125, 37.93347], [-121.92059, 37.93359], [-121.92059, 37.93384], [-121.92271, 37.93389], [-121.9228, 37.93419], [-121.9229, 37.9344], [-121.92321, 37.93494], [-121.92359, 37.93545], [-121.92479, 37.93674], [-121.92608, 37.93823], [-121.92572, 37.93842], [-121.92587, 37.9396], [-121.92587, 37.9398], [-121.92626, 37.93991], [-121.92616, 37.94011], [-121.92597, 37.9403], [-121.92581, 37.94039], [-121.92551, 37.94049], [-121.92529, 37.94059], [-121.9251, 37.94073], [-121.92502, 37.94081], [-121.92495, 37.94089], [-121.92485, 37.94107], [-121.92471, 37.94171], [-121.92463, 37.94186], [-121.92452, 37.94199], [-121.92436, 37.94212], [-121.92419, 37.9422], [-121.924, 37.94225], [-121.92386, 37.94227], [-121.92383, 37.942], [-121.92366, 37.94192], [-121.92351, 37.94192], [-121.92336, 37.9418], [-121.92326, 37.94178], [-121.92319, 37.94157], [-121.92314, 37.94155], [-121.92309, 37.94133], [-121.92303, 37.9413], [-121.92272, 37.94076], [-121.92249, 37.94049], [-121.92219, 37.94027], [-121.92182, 37.94008], [-121.92143, 37.93996], [-121.91974, 37.93974], [-121.91946, 37.93965], [-121.91916, 37.93951], [-121.91846, 37.93928], [-121.91788, 37.93905], [-121.91758, 37.93892], [-121.91649, 37.93839], [-121.9164, 37.93831], [-121.91627, 37.93816], [-121.91635, 37.93808], [-121.91638, 37.93776], [-121.91634, 37.93768], [-121.91627, 37.93761], [-121.91621, 37.93759], [-121.91594, 37.93758], [-121.91596, 37.93737], [-121.91624, 37.93753], [-121.91696, 37.93746], [-121.91694, 37.93726], [-121.91684, 37.93709], [-121.91611, 37.93663], [-121.91598, 37.93675], [-121.91592, 37.93673], [-121.91566, 37.93648], [-121.91541, 37.93631], [-121.91518, 37.93629], [-121.91512, 37.93636], [-121.91512, 37.93646], [-121.91533, 37.9368], [-121.9154, 37.93702], [-121.9154, 37.93705], [-121.91545, 37.9373], [-121.91542, 37.93733], [-121.91542, 37.93757], [-121.91536, 37.93763], [-121.91529, 37.93782], [-121.91525, 37.93785], [-121.91519, 37.93802], [-121.91512, 37.93807], [-121.91508, 37.93827], [-121.91512, 37.93838], [-121.91517, 37.93842], [-121.91513, 37.93849], [-121.91514, 37.93856], [-121.91508, 37.93859], [-121.91501, 37.93905], [-121.91478, 37.93922], [-121.91476, 37.93937], [-121.91459, 37.93959], [-121.91454, 37.93983], [-121.91468, 37.94024], [-121.91493, 37.94033], [-121.91496, 37.94037], [-121.91523, 37.94046], [-121.91526, 37.94051], [-121.91556, 37.94059], [-121.91559, 37.94064], [-121.91587, 37.94072], [-121.91591, 37.94076], [-121.91611, 37.94083], [-121.91632, 37.94079], [-121.91641, 37.94067], [-121.91669, 37.94078], [-121.91716, 37.94092], [-121.91735, 37.94099], [-121.91752, 37.94109], [-121.91737, 37.94124], [-121.91748, 37.94138], [-121.91766, 37.94152], [-121.91768, 37.94156], [-121.91793, 37.9417], [-121.91797, 37.94173], [-121.91818, 37.94182], [-121.91821, 37.94186], [-121.91844, 37.94193], [-121.91847, 37.94198], [-121.91869, 37.94204], [-121.91873, 37.94209], [-121.91896, 37.94216], [-121.919, 37.9422], [-121.91923, 37.94224], [-121.91937, 37.94218], [-121.91948, 37.94202], [-121.91988, 37.94205], [-121.92017, 37.94213], [-121.92057, 37.94233], [-121.92049, 37.94239], [-121.9205, 37.9425], [-121.92057, 37.94264], [-121.92072, 37.94271], [-121.92076, 37.94274], [-121.92105, 37.94284], [-121.92109, 37.94287], [-121.92115, 37.94288], [-121.92142, 37.94284], [-121.92145, 37.94285], [-121.9216, 37.9428], [-121.92172, 37.94271], [-121.92176, 37.94273], [-121.92197, 37.94269], [-121.92202, 37.94262], [-121.92196, 37.9424], [-121.92267, 37.94227], [-121.92296, 37.94216], [-121.92302, 37.94217], [-121.92313, 37.94224], [-121.92334, 37.94233], [-121.92367, 37.9424], [-121.92402, 37.94238], [-121.92425, 37.94232], [-121.92435, 37.94228], [-121.92453, 37.94217], [-121.92462, 37.94211], [-121.92476, 37.94196], [-121.92481, 37.94187], [-121.92489, 37.94165], [-121.925, 37.94115], [-121.92503, 37.94106], [-121.92513, 37.94091], [-121.92527, 37.94078], [-121.92544, 37.94067], [-121.92574, 37.94056], [-121.92582, 37.94101], [-121.92587, 37.94175], [-121.92555, 37.94245], [-121.92662, 37.94297], [-121.92639, 37.94295], [-121.92617, 37.94296], [-121.92595, 37.94301], [-121.92576, 37.9431], [-121.92559, 37.94321], [-121.92551, 37.94328], [-121.92545, 37.94335], [-121.92528, 37.94361], [-121.92523, 37.94366], [-121.92514, 37.94372], [-121.92494, 37.94375], [-121.92452, 37.94368], [-121.92421, 37.94371], [-121.92393, 37.94381], [-121.92376, 37.94392], [-121.92348, 37.94415], [-121.92336, 37.94421], [-121.9228, 37.94432], [-121.92258, 37.94538], [-121.92348, 37.94574], [-121.92504, 37.94618], [-121.92651, 37.94566], [-121.92758, 37.94516], [-121.9305, 37.9469]], [[-121.91577, 37.94768], [-121.9157, 37.94776], [-121.91566, 37.94785], [-121.91567, 37.94795], [-121.91571, 37.94805], [-121.91603, 37.94798], [-121.91616, 37.94776], [-121.91583, 37.94763], [-121.91577, 37.94768]], [[-121.91723, 37.94739], [-121.91723, 37.94737], [-121.91682, 37.94723], [-121.91663, 37.94761], [-121.91705, 37.94774], [-121.91723, 37.94739]]]} | Open Access 1 | 44716 | City of Clayton Open Space | 2402 | 1058 | Clayton, City of 621 | City 2 | City Agency 2 | http://ci.clayton.ca.us/?page_id=65 | City 2 | 1058 | Clayton, City of 610 | City 2 | City Agency 2 | Contra Costa 12 | 434.323 | City of Clayton OS | 0 | Local Recreation Area 3 | 4 | |
13897 | 13897 | 13896 | {"type": "Polygon", "coordinates": [[[-118.03556, 34.06661], [-118.0355, 34.06666], [-118.03549, 34.0667], [-118.03547, 34.0667], [-118.03547, 34.06675], [-118.03544, 34.06676], [-118.03544, 34.06686], [-118.03528, 34.06686], [-118.03527, 34.06691], [-118.03478, 34.06691], [-118.03478, 34.06651], [-118.03525, 34.06652], [-118.03527, 34.06653], [-118.03556, 34.06654], [-118.03556, 34.06661]]]} | Restricted Access 2 | 46374 | El Monte Aquatic Center | 29652 | 1095 | El Monte, City of 240 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | Los Angeles 6 | 0.667 | El Monte Aquatic Ctr. | 0 | Local Recreation Area 3 | 4 | |
15252 | 15252 | 15251 | {"type": "Polygon", "coordinates": [[[-118.03987, 34.07959], [-118.03911, 34.08069], [-118.03782, 34.08312], [-118.03785, 34.08315], [-118.03742, 34.08386], [-118.03733, 34.08382], [-118.03894, 34.0808], [-118.03944, 34.08002], [-118.03981, 34.07956], [-118.03987, 34.07959]]]} | Open Access 1 | 46368 | Rio Hondo River Trail | 29645 | 1095 | El Monte, City of 240 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | Los Angeles 6 | 1.227 | Rio Hondo River Trail | 0 | Local Recreation Area 3 | 4 | |
15278 | 15278 | 15277 | {"type": "Polygon", "coordinates": [[[-118.03583, 34.06522], [-118.03583, 34.06637], [-118.03578, 34.06639], [-118.03464, 34.06639], [-118.03464, 34.06484], [-118.03578, 34.06484], [-118.0358, 34.06507], [-118.03578, 34.06508], [-118.03579, 34.06521], [-118.03583, 34.06522]]]} | Restricted Access 2 | 46369 | Community Center Complex | 29686 | 1095 | El Monte, City of 240 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | Los Angeles 6 | 4.633 | Community Ctr. Complex | 0 | Local Recreation Area 3 | 4 | |
2998 | 2998 | 2997 | {"type": "Polygon", "coordinates": [[[-117.78863, 34.0562], [-117.78469, 34.05669], [-117.78406, 34.05571], [-117.78833, 34.05518], [-117.78863, 34.0562]]]} | Restricted Access 2 | 20562 | Veterans Park Soccer Complex | 29804 | 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/84-veterans-park | Los Angeles 6 | 10.986 | Veterans Park Soccer Complex | 0 | Local Recreation Area 3 | 4 |
15711 | 15711 | 15710 | {"type": "Polygon", "coordinates": [[[-117.77156, 34.04612], [-117.76587, 34.04476], [-117.76552, 34.04462], [-117.76521, 34.04446], [-117.76488, 34.04424], [-117.7645, 34.04391], [-117.76436, 34.04383], [-117.76422, 34.04378], [-117.76445, 34.0437], [-117.76472, 34.04357], [-117.76489, 34.04352], [-117.76514, 34.0435], [-117.76538, 34.04355], [-117.76558, 34.04364], [-117.7658, 34.0438], [-117.76599, 34.04392], [-117.76629, 34.04406], [-117.76668, 34.04416], [-117.76724, 34.04422], [-117.76742, 34.04426], [-117.76758, 34.04433], [-117.76781, 34.04447], [-117.76801, 34.04463], [-117.76823, 34.04472], [-117.76833, 34.04478], [-117.76841, 34.0449], [-117.76844, 34.04503], [-117.76865, 34.04508], [-117.76889, 34.04508], [-117.76912, 34.04501], [-117.76925, 34.04493], [-117.76936, 34.04478], [-117.76944, 34.04474], [-117.76951, 34.04474], [-117.76962, 34.04477], [-117.76971, 34.04478], [-117.76984, 34.04475], [-117.76993, 34.04469], [-117.77001, 34.04466], [-117.77071, 34.04468], [-117.7708, 34.04466], [-117.77091, 34.04461], [-117.771, 34.04453], [-117.77106, 34.04446], [-117.77107, 34.04492], [-117.77111, 34.04498], [-117.77134, 34.04494], [-117.77152, 34.04494], [-117.77156, 34.04612]]]} | Restricted Access 2 | 28355 | Palm Lake Golf Course | 33090 | 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 | Los Angeles 6 | 15.151 | Palm Lake GC | 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]);