units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 314
- San Diego, City of 281
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 118
- Long Beach, City of 101
- Oakland, City of 99
- Los Angeles, County of 95
- Consumnes Community Services District 92
- Fresno, City of 83
- East Bay Regional Park District 76
- Modesto, City of 76
- Huntington Beach, City of 74
- Hayward Area Recreation and Park District 74
- Tracy, City of 69
- Santa Rosa, City of 68
- San Diego, County of 68
- Mountains Recreation and Conservation Authority 67
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- …
MNG_AG_TYP 16
- City Agency 7,486
- Recreation/Parks District 704
- County Agency 651
- Community Services District 173
- County Agency - Parks 154
- Open Space District 75
- Water District 38
- School District 32
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 9,084
- Restricted Access 210
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,376 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5409 | 5409 | 5408 | {"type": "Polygon", "coordinates": [[[-122.70929, 38.32421], [-122.70932, 38.32439], [-122.70925, 38.32488], [-122.70801, 38.32535], [-122.70789, 38.32522], [-122.70819, 38.32474], [-122.70777, 38.32462], [-122.70797, 38.32381], [-122.70929, 38.32421]]]} | Open Access 1 | 49080 | Falleti Ranch | 33781 | 1072 | Cotati, City of 356 | City 2 | City Agency 2 | http://www.ci.cotati.ca.us/ | City 2 | 1072 | Cotati, City of 353 | City 2 | City Agency 2 | Sonoma 16 | 3.618 | Falleti Ranch | 0 | Local Park 2 | 4 | |
16432 | 16432 | 16431 | {"type": "MultiPolygon", "coordinates": [[[[-121.96819, 37.97315], [-121.96792, 37.97337], [-121.96771, 37.97352], [-121.96741, 37.97369], [-121.96718, 37.9738], [-121.96144, 37.97591], [-121.96093, 37.97613], [-121.96063, 37.97632], [-121.95394, 37.98082], [-121.95365, 37.98098], [-121.95276, 37.98141], [-121.95259, 37.98152], [-121.95245, 37.98166], [-121.95234, 37.98181], [-121.95228, 37.98197], [-121.95225, 37.98215], [-121.95226, 37.98228], [-121.95229, 37.9824], [-121.95235, 37.98253], [-121.95251, 37.98279], [-121.95259, 37.98316], [-121.95254, 37.98366], [-121.95238, 37.98411], [-121.95187, 37.98476], [-121.95185, 37.98489], [-121.95179, 37.98503], [-121.95175, 37.98523], [-121.95169, 37.98588], [-121.95165, 37.98601], [-121.95162, 37.98632], [-121.95151, 37.98667], [-121.95124, 37.98704], [-121.93914, 37.97988], [-121.93914, 37.9716], [-121.94048, 37.96768], [-121.94552, 37.96345], [-121.94855, 37.96307], [-121.95269, 37.96447], [-121.95349, 37.96501], [-121.95518, 37.96584], [-121.95556, 37.96638], [-121.95649, 37.96675], [-121.95687, 37.96703], [-121.95717, 37.96715], [-121.95749, 37.96718], [-121.95808, 37.96705], [-121.95893, 37.96768], [-121.95921, 37.96766], [-121.95901, 37.96816], [-121.95853, 37.96857], [-121.95853, 37.96858], [-121.96076, 37.97003], [-121.96122, 37.97051], [-121.9639, 37.97284], [-121.96754, 37.973], [-121.96819, 37.97315]]], [[[-121.99781, 38.00868], [-121.9971, 38.01085], [-121.99703, 38.01085], [-121.99695, 38.01109], [-121.99692, 38.0111], [-121.99652, 38.01104], [-121.99628, 38.01104], [-121.99603, 38.01105], [-121.99572, 38.0111], [-121.99549, 38.01116], [-121.99519, 38.01126], [-121.99492, 38.0114], [-121.99474, 38.01152], [-121.99451, 38.01171], [-121.99432, 38.01191], [-121.99303, 38.01354], [-121.99295, 38.01375], [-121.99216, 38.01458], [-121.9904, 38.01478], [-121.98772, 38.01583], [-121.96871, 37.99738], [-121.9514, 37.98714], [-121.95163, 37.98689], [-121.95172, 37.98674], [-121.95179, 37.98658], [-121.95186, 37.98631], [-121.95191, 37.9858], [-121.95193, 37.98573], [-121.95198, 37.98528], [-121.95213, 37.9849], [-121.95238, 37.98472], [-121.95261, 37.98437], [-121.95262, 37.98417], [-121.95272, 37.9839], [-121.95283, 37.98343], [-121.95285, 37.98319], [-121.9528, 37.98294], [-121.95272, 37.98276], [-121.95252, 37.98242], [-121.95247, 37.98227], [-121.95246, 37.98215], [-121.95247, 37.98203], [-121.95255, 37.98185], [-121.95265, 37.98171], [-121.95283, 37.98157], [-121.95376, 37.98112], [-121.95414, 37.9809], [-121.96076, 37.97644], [-121.96103, 37.97628], [-121.96226, 37.97633], [-121.96351, 37.9763], [-121.96527, 37.97638], [-121.96611, 37.97652], [-121.96659, 37.97666], [-121.96688, 37.9768], [-121.96709, 37.97692], [-121.9674, 37.97715], [-121.96801, 37.97774], [-121.96869, 37.97735], [-121.96963, 37.97587], [-121.97008, 37.97606], [-121.97034, 37.97639], [-121.97058, 37.9766], [-121.97089, 37.97697], [-121.97086, 37.97711], [-121.9709, 37.97729], [-121.97111, 37.97754], [-121.97113, 37.9778], [-121.97108, 37.97796], [-121.97081, 37.97796], [-121.97079, 37.97851], [-121.97069, 37.9791], [-121.9717, 37.97942], [-121.97243, 37.97979], [-121.97247, 37.97986], [-121.97214, 37.98039], [-121.97152, 37.98099], [-121.97133, 37.98124], [-121.97113, 37.98165], [-121.97099, 37.98175], [-121.9706, 37.98254], [-121.97055, 37.98271], [-121.97056, 37.98285], [-121.9706, 37.98295], [-121.97068, 37.98308], [-121.97077, 37.98316], [-121.97087, 37.98323], [-121.97099, 37.98328], [-121.97133, 37.98335], [-121.97133, 37.98344], [-121.97136, 37.98351], [-121.97211, 37.98492], [-121.97218, 37.98509], [-121.97235, 37.98519], [-121.97252, 37.98496], [-121.97222, 37.9847], [-121.97157, 37.98348], [-121.97159, 37.98345], [-121.9719, 37.98363], [-121.97219, 37.9837], [-121.97235, 37.98403], [-121.9725, 37.98423], [-121.97266, 37.98437], [-121.97298, 37.98457], [-121.97335, 37.98489], [-121.97365, 37.98547], [-121.97371, 37.98574], [-121.97374, 37.98583], [-121.97395, 37.98608], [-121.97422, 37.98616], [-121.97445, 37.98617], [-121.97457, 37.98615], [-121.97477, 37.98608], [-121.97492, 37.98597], [-121.97496, 37.98602], [-121.97498, 37.98615], [-121.97484, 37.98668], [-121.97495, 37.98683], [-121.97504, 37.98691], [-121.97515, 37.98696], [-121.97563, 37.98712], [-121.97576, 37.98714], [-121.97597, 37.98713], [-121.97618, 37.98705], [-121.97651, 37.98704], [-121.9766, 37.98721], [-121.97703, 37.98766], [-121.97746, 37.98795], [-121.97798, 37.98808], [-121.9786, 37.98814], [-121.97919, 37.98842], [-121.97926, 37.98855], [-121.97969, 37.98883], [-121.97984, 37.98889], [-121.98007, 37.98877], [-121.98013, 37.9887], [-121.98051, 37.98881], [-121.98045, 37.98917], [-121.98047, 37.98928], [-121.9805, 37.98939], [-121.98056, 37.98949], [-121.98064, 37.98958], [-121.98077, 37.98968], [-121.98089, 37.98974], [-121.98111, 37.98981], [-121.98139, 37.98981], [-121.98182, 37.98963], [-121.98222, 37.98972], [-121.98264, 37.99022], [-121.98319, 37.99064], [-121.98302, 37.99113], [-121.98314, 37.99139], [-121.98316, 37.99177], [-121.98324, 37.99202], [-121.98339, 37.9924], [-121.98354, 37.99258], [-121.9837, 37.9927], [-121.98444, 37.99317], [-121.98473, 37.99345], [-121.98495, 37.99387], [-121.9852, 37.99424], [-121.98533, 37.99438], [-121.98554, 37.99452], [-121.98596, 37.99466], [-121.98643, 37.99476], [-121.98666, 37.99477], [-121.98683, 37.99482], [-121.98685, 37.99488], [-121.98695, 37.99481], [-121.98764, 37.99504], [-121.98781, 37.99505], [-121.98809, 37.99502], [-121.98853, 37.99505], [-121.98883, 37.99501], [-121.9878, 37.99775], [-121.98801, 37.99832], [-121.98857, 37.99946], [-121.98924, 38.00038], [-121.98988, 38.00106], [-121.99044, 38.00195], [-121.99085, 38.0025], [-121.99136, 38.00283], [-121.99268, 38.00346], [-121.99264, 38.00375], [-121.99288, 38.00377], [-121.99291, 38.00358], [-121.99364, 38.00396], [-121.99425, 38.00623], [-121.99277, 38.00685], [-121.99226, 38.00758], [-121.9918, 38.00787], [-121.99061, 38.00794], [-121.99012, 38.00769], [-121.98971, 38.00741], [-121.98936, 38.00697], [-121.98873, 38.0065], [-121.98802, 38.00488], [-121.98733, 38.00583], [-121.98926, 38.00726], [-121.98955, 38.00766], [-121.99041, 38.00811], [-121.99115, 38.00821], [-121.99144, 38.00835], [-121.99241, 38.00773], [-121.99342, 38.00749], [-121.99448, 38.00649], [-121.99659, 38.00754], [-121.99756, 38.00863], [-121.99781, 38.00868]], [[-121.98279, 37.99643], [-121.98236, 37.99557], [-121.98228, 37.99546], [-121.98156, 37.99483], [-121.98144, 37.99478], [-121.98052, 37.99451], [-121.98047, 37.99447], [-121.98004, 37.99393], [-121.97969, 37.9925], [-121.97964, 37.99241], [-121.97907, 37.9917], [-121.97873, 37.99046], [-121.97869, 37.99038], [-121.97758, 37.98903], [-121.97562, 37.98747], [-121.97463, 37.98685], [-121.97483, 37.98669], [-121.97483, 37.98667], [-121.97264, 37.98559], [-121.97205, 37.98526], [-121.97197, 37.98536], [-121.97197, 37.98538], [-121.9745, 37.98696], [-121.9745, 37.98698], [-121.97545, 37.98757], [-121.97743, 37.98915], [-121.97853, 37.99051], [-121.97887, 37.99176], [-121.9795, 37.99255], [-121.97982, 37.99391], [-121.97988, 37.99403], [-121.9803, 37.99456], [-121.98038, 37.99463], [-121.98052, 37.99469], [-121.98144, 37.99496], [-121.98212, 37.99557], [-121.98217, 37.99563], [-121.98272, 37.99673], [-121.9852, 37.99886], [-121.98615, 38.00003], [-121.98621, 38.00011], [-121.98684, 38.00138], [-121.98703, 38.00264], [-121.98701, 38.00285], [-121.98716, 38.00363], [-121.9878, 38.00501], [-121.98782, 38.00501], [-121.98795, 38.00483], [-121.98739, 38.00364], [-121.98705, 38.00135], [-121.98639, 38.00002], [-121.98536, 37.99876], [-121.98292, 37.99666], [-121.98288, 37.99662], [-121.98279, 37.99643]]]]} | No Public Access 3 | 49041 | Concord Hills Regional Park | 33747 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | https://www.ebparks.org/parks/concord_hills/ | Contra Costa 12 | 2544.276 | Concord Hills RP | 2019 | Local Park 2 | 4 |
10074 | 10074 | 10073 | {"type": "Polygon", "coordinates": [[[-121.26493, 38.83074], [-121.26429, 38.83085], [-121.26318, 38.83041], [-121.26364, 38.82968], [-121.26371, 38.82953], [-121.26376, 38.8292], [-121.26378, 38.82917], [-121.26384, 38.82915], [-121.26484, 38.82927], [-121.2648, 38.82959], [-121.2648, 38.83], [-121.26485, 38.8304], [-121.26493, 38.83074]]]} | Open Access 1 | 49036 | Willard Park | 33743 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 4.813 | Willard Park | 2019 | Local Park 2 | 4 | |
10073 | 10073 | 10072 | {"type": "Polygon", "coordinates": [[[-121.28222, 38.81572], [-121.28171, 38.81595], [-121.28168, 38.81588], [-121.28158, 38.8158], [-121.28132, 38.81542], [-121.28105, 38.81507], [-121.28097, 38.81499], [-121.28084, 38.81488], [-121.2808, 38.81481], [-121.28072, 38.81477], [-121.28065, 38.81477], [-121.28057, 38.81481], [-121.28053, 38.81488], [-121.28047, 38.81488], [-121.28041, 38.8148], [-121.28124, 38.81442], [-121.28222, 38.81572]]]} | Open Access 1 | 49035 | Wickman Park | 33742 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.226 | Wickman Park | 2017 | Local Park 2 | 4 | |
5476 | 5476 | 5475 | {"type": "MultiPolygon", "coordinates": [[[[-121.20025, 38.80451], [-121.20011, 38.80463], [-121.19978, 38.80457], [-121.19988, 38.80436], [-121.19994, 38.80433], [-121.19999, 38.80435], [-121.20025, 38.80451]]], [[[-121.20098, 38.80218], [-121.20095, 38.80387], [-121.20031, 38.80445], [-121.20003, 38.80428], [-121.20002, 38.80423], [-121.2001, 38.80415], [-121.20041, 38.80395], [-121.20055, 38.80383], [-121.20068, 38.80368], [-121.20079, 38.80349], [-121.20086, 38.8033], [-121.2009, 38.8031], [-121.20093, 38.80218], [-121.20098, 38.80218]]]]} | Open Access 1 | 49032 | Christine Anderson Park | 33734 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.247 | Christine Anderson Park | 2018 | Local Park 2 | 4 | |
10053 | 10053 | 10052 | {"type": "Polygon", "coordinates": [[[-121.23986, 38.78689], [-121.23937, 38.78755], [-121.23887, 38.78744], [-121.23925, 38.78697], [-121.23913, 38.7869], [-121.23934, 38.78663], [-121.23986, 38.78689]]]} | Open Access 1 | 49028 | Deer Creek Park | 33729 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.051 | Deer Creek Park | 0 | Local Park 2 | 4 | |
10048 | 10048 | 10047 | {"type": "Polygon", "coordinates": [[[-121.2703, 38.83454], [-121.26942, 38.8347], [-121.26937, 38.83469], [-121.26934, 38.83466], [-121.26929, 38.83449], [-121.26927, 38.83431], [-121.26928, 38.83413], [-121.26933, 38.83395], [-121.26946, 38.83369], [-121.26958, 38.83354], [-121.26973, 38.8334], [-121.26991, 38.83353], [-121.27003, 38.83373], [-121.26979, 38.8341], [-121.26993, 38.83424], [-121.26995, 38.83444], [-121.27029, 38.8345], [-121.2703, 38.83454]]]} | Open Access 1 | 49026 | Pernu Park | 33727 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.676 | Pernu Park | 0 | Local Park 2 | 4 | |
10047 | 10047 | 10046 | {"type": "Polygon", "coordinates": [[[-120.81909, 39.02277], [-120.81495, 39.02381], [-120.81432, 39.02209], [-120.81557, 39.02184], [-120.81585, 39.02263], [-120.81674, 39.02246], [-120.81675, 39.02244], [-120.81647, 39.02165], [-120.81844, 39.02125], [-120.81899, 39.02269], [-120.81909, 39.02277]]]} | Open Access 1 | 49024 | Foresthill Leroy E. Botts Memorial Park | 33725 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | https://www.placer.ca.gov/6000/Foresthill-Leroy-E-Botts-Memorial-Park | Placer 35 | 15.352 | Foresthill Leroy E. Botts Memorial Park | 0 | Local Park 2 | 4 |
10043 | 10043 | 10042 | {"type": "Polygon", "coordinates": [[[-121.09452, 38.93839], [-121.09416, 38.93839], [-121.09416, 38.93785], [-121.09452, 38.93839], [-121.09452, 38.93839]]]} | Open Access 1 | 49023 | Auburn Plaza Park | 33724 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | https://www.placer.ca.gov/6005/Plaza-Park | Placer 35 | 0.231 | Auburn Plaza Park | 0 | Local Park 2 | 4 |
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 |
15380 | 15380 | 15379 | {"type": "Polygon", "coordinates": [[[-123.4074, 39.00408], [-123.40742, 39.00624], [-123.40739, 39.00777], [-123.40276, 39.00769], [-123.40285, 39.004], [-123.4074, 39.00408]]]} | Open Access 1 | 49011 | Faulkner Park | 33709 | 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/faulkner-park | Mendocino 24 | 40.36 | Faulkner Park | 1930 | Local Park 2 | 4 |
9247 | 9247 | 9246 | {"type": "Polygon", "coordinates": [[[-121.11612, 38.79796], [-121.116, 38.79929], [-121.11489, 38.79929], [-121.11488, 38.79914], [-121.11491, 38.79901], [-121.11497, 38.79887], [-121.11506, 38.79875], [-121.11524, 38.7986], [-121.11568, 38.79837], [-121.11582, 38.79828], [-121.11599, 38.79813], [-121.11612, 38.79796]]]} | Open Access 1 | 49009 | Sterling Pointe Park | 33705 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 2.222 | Sterling Pointe Park | 0 | Local Park 2 | 4 | |
4905 | 4905 | 4904 | {"type": "Polygon", "coordinates": [[[-118.93429, 34.23097], [-118.93156, 34.2316], [-118.93117, 34.23166], [-118.93075, 34.23168], [-118.93077, 34.2258], [-118.93428, 34.22579], [-118.93429, 34.23097]]]} | Open Access 1 | 49004 | Santa Rosa Valley Park | 33703 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 49.627 | Santa Rosa Valley Park | 0 | Local Park 2 | 4 | |
1725 | 1725 | 1724 | {"type": "Polygon", "coordinates": [[[-121.19542, 38.82059], [-121.19429, 38.82183], [-121.19403, 38.82168], [-121.19516, 38.82045], [-121.19542, 38.82059]]]} | Open Access 1 | 49001 | Blue Anchor Park | 33700 | 1354 | Loomis, Town of 415 | City 2 | City Agency 2 | http://www.loomis.ca.gov/ | City 2 | 1354 | Loomis, Town of 409 | City 2 | City Agency 2 | https://loomis.ca.gov/how-do-i/find-2/parks-recreation/ | Placer 35 | 1.147 | Blue Anchor Park | 0 | Local Park 2 | 4 |
4449 | 4449 | 4448 | {"type": "Polygon", "coordinates": [[[-121.17178, 38.78981], [-121.1705, 38.79009], [-121.17044, 38.79009], [-121.17038, 38.79007], [-121.17033, 38.79002], [-121.1699, 38.7888], [-121.17148, 38.78877], [-121.17178, 38.78981]]]} | Open Access 1 | 49000 | Franklin Community School Park | 33699 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | https://www.placer.ca.gov/6045/Franklin-Community-School-Park | Placer 35 | 4.349 | Franklin Community School Park | 0 | Local Park 2 | 4 |
9097 | 9097 | 9096 | {"type": "Polygon", "coordinates": [[[-121.03287, 38.97744], [-121.03214, 38.97744], [-121.03101, 38.97718], [-121.03108, 38.97711], [-121.03122, 38.97706], [-121.03127, 38.977], [-121.03128, 38.97694], [-121.03126, 38.97689], [-121.03121, 38.97685], [-121.03115, 38.97682], [-121.03105, 38.97682], [-121.03096, 38.97687], [-121.03093, 38.97693], [-121.03092, 38.97703], [-121.03083, 38.97715], [-121.03012, 38.97682], [-121.03039, 38.9766], [-121.03059, 38.97629], [-121.03071, 38.97617], [-121.03115, 38.97583], [-121.03148, 38.97573], [-121.03189, 38.97565], [-121.03249, 38.97552], [-121.03272, 38.97551], [-121.03268, 38.97718], [-121.03287, 38.97718], [-121.03287, 38.97744]]]} | Open Access 1 | 48994 | Sugarpine Ridge Park | 33690 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_sugarpine.php | Placer 35 | 8.053 | Sugarpine Ridge Park | 0 | Local Park 2 | 4 |
1432 | 1432 | 1431 | {"type": "Polygon", "coordinates": [[[-121.88594, 37.31445], [-121.88536, 37.31483], [-121.88518, 37.31455], [-121.88449, 37.31485], [-121.88433, 37.31463], [-121.88552, 37.31397], [-121.88594, 37.31445]]]} | Open Access 1 | 48980 | Tamien Park | 33676 | 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 | https://www.mercurynews.com/2017/06/21/tamien-park-opens-after-22-years-of-planning/ | Santa Clara 19 | 1.588 | Tamien Park | 2017 | Local Park 2 | 4 |
16331 | 16331 | 16330 | {"type": "MultiPolygon", "coordinates": [[[[-119.24297, 36.33127], [-119.24195, 36.33139], [-119.23951, 36.33153], [-119.23811, 36.33164], [-119.2372, 36.33193], [-119.23691, 36.33215], [-119.2366, 36.33228], [-119.23591, 36.33246], [-119.23541, 36.33252], [-119.23479, 36.3325], [-119.23421, 36.33281], [-119.23394, 36.33292], [-119.23392, 36.33213], [-119.23394, 36.33086], [-119.23399, 36.33085], [-119.23391, 36.32725], [-119.23517, 36.32722], [-119.23546, 36.32724], [-119.23575, 36.32727], [-119.23603, 36.32734], [-119.2363, 36.32742], [-119.23655, 36.32753], [-119.2369, 36.32772], [-119.23721, 36.32796], [-119.23841, 36.32919], [-119.23856, 36.32932], [-119.23893, 36.3293], [-119.23936, 36.32919], [-119.23997, 36.32911], [-119.24016, 36.32898], [-119.24006, 36.3285], [-119.24069, 36.32807], [-119.24185, 36.32775], [-119.24203, 36.3275], [-119.24227, 36.32731], [-119.24259, 36.32726], [-119.24262, 36.32724], [-119.24291, 36.32724], [-119.24297, 36.33127]]], [[[-119.24313, 36.34277], [-119.24142, 36.3433], [-119.24141, 36.34287], [-119.24097, 36.34288], [-119.24096, 36.34188], [-119.23752, 36.34188], [-119.23746, 36.33925], [-119.23575, 36.33923], [-119.23565, 36.33449], [-119.23398, 36.33447], [-119.23394, 36.33295], [-119.23423, 36.33284], [-119.2348, 36.33253], [-119.23541, 36.33254], [-119.23591, 36.33249], [-119.23661, 36.33231], [-119.23693, 36.33217], [-119.23723, 36.33195], [-119.23812, 36.33167], [-119.23952, 36.33156], [-119.24297, 36.33135], [-119.24313, 36.34277]]]]} | Open Access 1 | 48973 | East Side Regional Park | 33670 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | https://docs.google.com/document/d/1oNuJp2ZETkV9htPzVHlYhz1D7kD7tlzxGEYdJEtsDPg/edit | Tulare 29 | 271.524 | East Side RP | 0 | Local Park 2 | 4 |
15329 | 15329 | 15328 | {"type": "Polygon", "coordinates": [[[-117.03611, 33.78835], [-117.03606, 33.78836], [-117.03603, 33.78814], [-117.03599, 33.78803], [-117.0359, 33.78786], [-117.03583, 33.78777], [-117.03574, 33.78768], [-117.03558, 33.78755], [-117.03537, 33.78743], [-117.03604, 33.78743], [-117.03599, 33.78773], [-117.03606, 33.7878], [-117.03603, 33.78785], [-117.03602, 33.78791], [-117.03605, 33.78798], [-117.03604, 33.788], [-117.03611, 33.78835]]]} | Open Access 1 | 48972 | Pocket Park at the Cove #2 | 33669 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.446 | PP at the Cove #2 | 0 | Local Park 2 | 4 |
15540 | 15540 | 15539 | {"type": "Polygon", "coordinates": [[[-117.03786, 33.79012], [-117.03745, 33.79026], [-117.03733, 33.79002], [-117.03774, 33.78988], [-117.03786, 33.79012]]]} | Open Access 1 | 48971 | Pocket Park at the Cove #1 | 33668 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.295 | PP at the Cove #1 | 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]);