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 SUID_NMA 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11463 | 11463 | 11462 | {"type": "Polygon", "coordinates": [[[-117.67517, 34.0201], [-117.67477, 34.0201], [-117.67476, 34.0193], [-117.67517, 34.0193], [-117.67517, 34.0201]]]} | Open Access 1 | 48698 | Community Garden Pocket Park | 33797 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | https://www.cityofchino.org/residents/connection/programs/garden_workshops | San Bernardino 22 | 0.828 | Community Garden PP | 0 | Local Park 2 | 4 |
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 | |
16342 | 16342 | 16341 | {"type": "Polygon", "coordinates": [[[-122.52762, 38.20438], [-122.52325, 38.20854], [-122.52325, 38.20856], [-122.52512, 38.2094], [-122.51982, 38.21673], [-122.51958, 38.21647], [-122.51926, 38.21618], [-122.51815, 38.21741], [-122.51667, 38.21364], [-122.51098, 38.21317], [-122.50883, 38.2148], [-122.50824, 38.21367], [-122.50585, 38.21091], [-122.50337, 38.21308], [-122.50291, 38.21352], [-122.50207, 38.2126], [-122.50144, 38.21335], [-122.50422, 38.21553], [-122.50528, 38.21642], [-122.50179, 38.21996], [-122.50108, 38.21932], [-122.4997, 38.21796], [-122.49899, 38.21761], [-122.49727, 38.21635], [-122.49355, 38.21056], [-122.49168, 38.20981], [-122.49141, 38.20911], [-122.49104, 38.20866], [-122.49079, 38.20864], [-122.49065, 38.20851], [-122.48982, 38.20798], [-122.48954, 38.20759], [-122.48867, 38.20715], [-122.48661, 38.20644], [-122.48646, 38.20407], [-122.48661, 38.20199], [-122.48829, 38.20128], [-122.49001, 38.20127], [-122.49121, 38.20014], [-122.49131, 38.20017], [-122.49296, 38.20041], [-122.49345, 38.20052], [-122.49471, 38.20059], [-122.49535, 38.20044], [-122.49584, 38.19983], [-122.49615, 38.19923], [-122.49699, 38.19896], [-122.49788, 38.19934], [-122.50009, 38.19971], [-122.50075, 38.19966], [-122.50117, 38.19909], [-122.50102, 38.19718], [-122.49859, 38.19435], [-122.49774, 38.19403], [-122.49642, 38.19371], [-122.49675, 38.19327], [-122.49749, 38.19298], [-122.49792, 38.19256], [-122.4978, 38.1924], [-122.49726, 38.19196], [-122.49721, 38.19188], [-122.4972, 38.19182], [-122.49723, 38.19179], [-122.49721, 38.19176], [-122.49722, 38.19166], [-122.4979, 38.1917], [-122.49852, 38.19165], [-122.49856, 38.19169], [-122.49855, 38.19173], [-122.49868, 38.1918], [-122.49954, 38.19151], [-122.50035, 38.19151], [-122.50035, 38.19147], [-122.50063, 38.19144], [-122.50129, 38.1908], [-122.50154, 38.19038], [-122.50157, 38.1901], [-122.50168, 38.18995], [-122.50186, 38.18985], [-122.50224, 38.18976], [-122.50272, 38.18956], [-122.50343, 38.18921], [-122.50568, 38.18696], [-122.50996, 38.18359], [-122.51644, 38.18887], [-122.51587, 38.18959], [-122.51482, 38.19013], [-122.51436, 38.19038], [-122.51165, 38.19146], [-122.51164, 38.19148], [-122.51377, 38.19288], [-122.51577, 38.19418], [-122.51921, 38.19581], [-122.52091, 38.19654], [-122.5191, 38.19805], [-122.5242, 38.20139], [-122.52424, 38.20149], [-122.52762, 38.20438]]]} | Open Access 1 | 9819 | Tolay Lake Regional Park | 33777 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 1760.959 | Tolay Lake RP | 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 |
10886 | 10886 | 10885 | {"type": "Polygon", "coordinates": [[[-121.24285, 38.7747], [-121.24256, 38.77498], [-121.24217, 38.77545], [-121.242, 38.77559], [-121.24188, 38.77564], [-121.24183, 38.77573], [-121.24146, 38.77569], [-121.24119, 38.77586], [-121.24113, 38.77582], [-121.24105, 38.77582], [-121.24102, 38.77557], [-121.24076, 38.77531], [-121.24238, 38.77431], [-121.24285, 38.7747]]]} | Open Access 1 | 20835 | Woodside Park | 33744 | 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 | 3.563 | Woodside Park | 0 | 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 | |
10909 | 10909 | 10908 | {"type": "Polygon", "coordinates": [[[-121.25393, 38.78071], [-121.25378, 38.78075], [-121.25354, 38.7812], [-121.25332, 38.78152], [-121.25253, 38.78125], [-121.25248, 38.78099], [-121.2523, 38.78062], [-121.25194, 38.78034], [-121.25182, 38.77988], [-121.25143, 38.77943], [-121.25156, 38.77935], [-121.25167, 38.77925], [-121.2519, 38.77938], [-121.2524, 38.77939], [-121.25269, 38.77907], [-121.25253, 38.77872], [-121.25246, 38.77866], [-121.25303, 38.77856], [-121.25315, 38.77891], [-121.25284, 38.77967], [-121.25335, 38.78053], [-121.25363, 38.78053], [-121.25393, 38.78071]]]} | Open Access 1 | 20897 | Sunset East Park | 33740 | 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 | 6.944 | Sunset East Park | 0 | Local Park 2 | 4 | |
5031 | 5031 | 5030 | {"type": "Polygon", "coordinates": [[[-121.22404, 38.79398], [-121.2241, 38.79461], [-121.22386, 38.79562], [-121.22379, 38.79568], [-121.22352, 38.79566], [-121.22328, 38.79577], [-121.22288, 38.79523], [-121.22277, 38.79498], [-121.22272, 38.79473], [-121.22273, 38.79397], [-121.22404, 38.79398]]]} | Open Access 1 | 20831 | Sierra Meadows Park | 33739 | 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.822 | Sierra Meadows Park | 0 | Local Park 2 | 4 | |
12677 | 12677 | 12676 | {"type": "Polygon", "coordinates": [[[-121.24701, 38.83755], [-121.24602, 38.83754], [-121.24544, 38.83782], [-121.24435, 38.83815], [-121.24373, 38.83828], [-121.2426, 38.83894], [-121.24222, 38.83885], [-121.24232, 38.83861], [-121.24243, 38.83863], [-121.24249, 38.83862], [-121.24255, 38.83859], [-121.24259, 38.83853], [-121.2426, 38.83846], [-121.24262, 38.83843], [-121.24315, 38.83801], [-121.24327, 38.83787], [-121.24347, 38.8376], [-121.24359, 38.83749], [-121.24373, 38.83739], [-121.24405, 38.83723], [-121.24435, 38.83714], [-121.24466, 38.83712], [-121.24517, 38.83714], [-121.24541, 38.83711], [-121.24556, 38.83705], [-121.24569, 38.83698], [-121.24585, 38.83685], [-121.24613, 38.8364], [-121.24621, 38.8363], [-121.24638, 38.83618], [-121.24651, 38.83613], [-121.24667, 38.83611], [-121.24671, 38.83615], [-121.24684, 38.83617], [-121.24692, 38.83625], [-121.24701, 38.8368], [-121.24701, 38.83755]]]} | Open Access 1 | 29575 | Pleasant Valley Creek Park | 33738 | 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 | 9.791 | Pleasant Valley Creek Park | 0 | Local Park 2 | 4 | |
5032 | 5032 | 5031 | {"type": "Polygon", "coordinates": [[[-121.22313, 38.77883], [-121.22314, 38.77916], [-121.22309, 38.77938], [-121.22302, 38.77959], [-121.22281, 38.77996], [-121.22272, 38.78016], [-121.22267, 38.78018], [-121.22244, 38.78016], [-121.22213, 38.78017], [-121.22192, 38.78021], [-121.22151, 38.78033], [-121.22134, 38.78035], [-121.22129, 38.78033], [-121.22128, 38.78029], [-121.2213, 38.78013], [-121.22146, 38.77976], [-121.22149, 38.77953], [-121.22147, 38.77931], [-121.22144, 38.77917], [-121.22133, 38.77897], [-121.22122, 38.77883], [-121.22313, 38.77883]]]} | Open Access 1 | 20834 | Corral-Alva Park | 33737 | 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 | 5.279 | Corral-Alva Park | 0 | 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 | |
10895 | 10895 | 10894 | {"type": "Polygon", "coordinates": [[[-121.26504, 38.81124], [-121.26473, 38.81127], [-121.2645, 38.81149], [-121.2637, 38.81155], [-121.26227, 38.81134], [-121.26097, 38.81209], [-121.25895, 38.81171], [-121.25897, 38.81164], [-121.25894, 38.81164], [-121.25889, 38.81157], [-121.25903, 38.81127], [-121.25922, 38.81099], [-121.25945, 38.81072], [-121.25976, 38.81045], [-121.26223, 38.80884], [-121.26232, 38.80884], [-121.26234, 38.80886], [-121.26247, 38.80878], [-121.26245, 38.80873], [-121.26298, 38.80838], [-121.26312, 38.80825], [-121.26387, 38.80779], [-121.26418, 38.8081], [-121.26422, 38.80819], [-121.26434, 38.80826], [-121.2648, 38.80873], [-121.26339, 38.80968], [-121.26504, 38.81124]]]} | Open Access 1 | 20849 | Twin Oaks Park | 33733 | 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 | 30.273 | Twin Oaks Park | 0 | Local Park 2 | 4 | |
12655 | 12655 | 12654 | {"type": "Polygon", "coordinates": [[[-121.29272, 38.80693], [-121.29258, 38.8075], [-121.29252, 38.80788], [-121.2925, 38.80826], [-121.29249, 38.80896], [-121.29163, 38.80896], [-121.29108, 38.80939], [-121.29107, 38.81002], [-121.28931, 38.81005], [-121.28718, 38.81006], [-121.28717, 38.80949], [-121.28658, 38.80949], [-121.287, 38.80895], [-121.28937, 38.80728], [-121.29038, 38.80701], [-121.29272, 38.80693]]]} | Open Access 1 | 29505 | Kathy Lund Community Park | 33732 | 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 | 30.262 | Kathy Lund Community Park | 0 | 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 |
2689 | 2689 | 2688 | {"type": "Polygon", "coordinates": [[[-121.96932, 38.8863], [-121.9688, 38.88631], [-121.9688, 38.88594], [-121.96932, 38.88593], [-121.96932, 38.8863]]]} | Open Access 1 | 28059 | Dunnigan Park | 33723 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 0.458 | Dunnigan Park | 0 | Local Park 2 | 4 | |
6071 | 6071 | 6070 | {"type": "Polygon", "coordinates": [[[-117.17247, 32.69894], [-117.17197, 32.69981], [-117.17153, 32.69964], [-117.17205, 32.69877], [-117.17247, 32.69894]]]} | Open Access 1 | 809 | Centennial Park | 33718 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814369 | San Diego 4 | 1.186 | Centennial Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);