units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
363 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 2 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, YR_EST, GAP_STS
MNG_AGENCY >30
- Los Angeles, City of 20
- Whittier, City of 20
- San Ramon, City of 15
- San Diego, City of 10
- Long Beach, City of 9
- Arcadia, City of 8
- Manhattan Beach, City of 8
- Santa Cruz, City of 7
- Modesto, City of 7
- San Jose, City of 6
- Carlsbad, City of 6
- Hollister, City of 6
- Pasadena, City of 6
- Santa Ana, City of 5
- Fullerton, City of 5
- Vacaville, City of 5
- San Bernardino, City of 5
- Beverly Hills, City of 5
- Lawndale, City of 5
- San Gabriel, City of 5
- Glendora, City of 4
- El Segundo, City of 4
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- South El Monte, City of 4
- Watsonville, City of 3
- San Luis Obispo, City of 3
- Oceanside, City of 3
- Pomona, City of 3
- …
DES_TP >30
- Local Recreation Area 168
- Local Park 151
- Local Conservation Area 10
- Local Other or Unknown 6
- Local Historic or Cultural Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 1
- City Agency · 363 ✖
ACCESS_TYP 1
- Restricted Access · 363 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4166 | 4166 | 4165 | {"type": "Polygon", "coordinates": [[[-121.07771, 39.22081], [-121.07676, 39.22153], [-121.07673, 39.22149], [-121.07655, 39.22152], [-121.07648, 39.22148], [-121.07549, 39.22233], [-121.07527, 39.22221], [-121.07499, 39.22212], [-121.07443, 39.22199], [-121.07444, 39.22102], [-121.07552, 39.22103], [-121.07557, 39.22092], [-121.07556, 39.22075], [-121.07569, 39.22072], [-121.07668, 39.22003], [-121.07771, 39.22081]]]} | Restricted Access 2 | 48291 | Margaret G Scotten School Ballfields | 32866 | 2429 | Grass Valley School District 728 | Special District 4 | School District 14 | www.gvsd.us | Special District 4 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 8.566 | Margaret G Scotten School Ballfields | 2018 | None 361 | ||
15294 | 15294 | 15293 | {"type": "Polygon", "coordinates": [[[-118.23026, 34.16966], [-118.23015, 34.16981], [-118.2301, 34.16985], [-118.23004, 34.16995], [-118.22998, 34.16996], [-118.2299, 34.16992], [-118.22991, 34.16982], [-118.22989, 34.16978], [-118.22982, 34.16973], [-118.22962, 34.1697], [-118.22975, 34.16956], [-118.2298, 34.16948], [-118.23026, 34.16966]]]} | Restricted Access 2 | 46426 | Verdugo Skate Park | 29697 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/verdugo-skate-park | Los Angeles 6 | 0.355 | Verdugo Skate Park | 2004 | Local Recreation Area 3 | 4 |
15679 | 15679 | 15678 | {"type": "Polygon", "coordinates": [[[-121.85663, 37.3456], [-121.85604, 37.34604], [-121.85601, 37.3461], [-121.85601, 37.34615], [-121.85607, 37.34627], [-121.85226, 37.34926], [-121.85206, 37.34901], [-121.85125, 37.34807], [-121.85017, 37.34696], [-121.85017, 37.34693], [-121.85019, 37.3469], [-121.85087, 37.34649], [-121.85104, 37.34645], [-121.85138, 37.34648], [-121.85155, 37.34647], [-121.85172, 37.34642], [-121.8519, 37.34631], [-121.85203, 37.34645], [-121.85208, 37.34643], [-121.85223, 37.34658], [-121.85228, 37.34656], [-121.8524, 37.34668], [-121.85248, 37.34669], [-121.85249, 37.34675], [-121.85254, 37.34679], [-121.8526, 37.34681], [-121.85264, 37.3468], [-121.85274, 37.34691], [-121.85282, 37.34687], [-121.85296, 37.34701], [-121.85302, 37.34702], [-121.85302, 37.34707], [-121.85305, 37.34711], [-121.85313, 37.34714], [-121.85312, 37.34721], [-121.85326, 37.34734], [-121.85346, 37.34721], [-121.85348, 37.34722], [-121.8538, 37.34703], [-121.85374, 37.34695], [-121.85377, 37.34692], [-121.85364, 37.34678], [-121.85372, 37.34673], [-121.85387, 37.34688], [-121.85508, 37.34613], [-121.8551, 37.34614], [-121.85528, 37.34603], [-121.85528, 37.34602], [-121.85468, 37.3454], [-121.85448, 37.34551], [-121.85444, 37.34546], [-121.85461, 37.34534], [-121.85417, 37.34488], [-121.85398, 37.34499], [-121.85399, 37.34488], [-121.85421, 37.34474], [-121.85383, 37.34435], [-121.85364, 37.34446], [-121.85358, 37.3444], [-121.85376, 37.34429], [-121.85373, 37.34425], [-121.85381, 37.34419], [-121.85356, 37.34394], [-121.85362, 37.3439], [-121.85362, 37.34389], [-121.85337, 37.34364], [-121.85335, 37.34364], [-121.85321, 37.3435], [-121.85323, 37.34348], [-121.85313, 37.34338], [-121.85427, 37.34267], [-121.85501, 37.3434], [-121.85521, 37.34357], [-121.85486, 37.34379], [-121.85486, 37.34381], [-121.85663, 37.3456]]]} | Restricted Access 2 | 13737 | Rancho del Pueblo Golf Course | 33035 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 30.551 | Rancho del Pueblo GC | 2001 | Local Recreation Area 3 | 4 | |
3237 | 3237 | 3236 | {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} | Restricted Access 2 | 48110 | Sunflower Park | 32835 | 2422 | El Centro Elementary School District 602 | Special District 4 | School District 14 | www.ecesd.org | Special District 4 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 18.451 | Sunflower Park | 2000 | Local Park 2 | 4 |
9733 | 9733 | 9732 | {"type": "Polygon", "coordinates": [[[-122.20028, 37.35643], [-122.20024, 37.35647], [-122.19706, 37.35796], [-122.1956, 37.35913], [-122.19551, 37.35915], [-122.19283, 37.36128], [-122.19343, 37.364], [-122.19163, 37.36491], [-122.19121, 37.36486], [-122.18979, 37.36548], [-122.18785, 37.36605], [-122.18758, 37.36631], [-122.18746, 37.3668], [-122.18581, 37.36661], [-122.18362, 37.36568], [-122.1833, 37.36619], [-122.18307, 37.36647], [-122.18209, 37.36668], [-122.18172, 37.36693], [-122.18155, 37.3674], [-122.18133, 37.36761], [-122.18086, 37.36775], [-122.18039, 37.36775], [-122.17994, 37.36759], [-122.17931, 37.36763], [-122.17847, 37.36744], [-122.17787, 37.36834], [-122.17612, 37.3684], [-122.17396, 37.37054], [-122.17031, 37.37008], [-122.17135, 37.36699], [-122.17198, 37.36518], [-122.17335, 37.36092], [-122.17368, 37.36063], [-122.1744, 37.36062], [-122.17451, 37.36045], [-122.17473, 37.36023], [-122.17521, 37.35985], [-122.17572, 37.35871], [-122.17541, 37.35837], [-122.17478, 37.35829], [-122.1746, 37.35829], [-122.17433, 37.35832], [-122.17417, 37.35828], [-122.17865, 37.34535], [-122.18261, 37.33356], [-122.18261, 37.33335], [-122.18272, 37.333], [-122.18278, 37.33298], [-122.18293, 37.33313], [-122.18307, 37.33336], [-122.18316, 37.3336], [-122.18354, 37.33423], [-122.18396, 37.33471], [-122.18422, 37.33493], [-122.18425, 37.33503], [-122.18425, 37.33511], [-122.18433, 37.33527], [-122.18455, 37.33559], [-122.18472, 37.33589], [-122.18511, 37.33643], [-122.18569, 37.33745], [-122.18575, 37.33774], [-122.18573, 37.33808], [-122.18575, 37.33829], [-122.1858, 37.33847], [-122.18587, 37.33862], [-122.18598, 37.33872], [-122.18642, 37.33897], [-122.18674, 37.33917], [-122.18701, 37.33938], [-122.18755, 37.33983], [-122.18816, 37.34023], [-122.18896, 37.34079], [-122.18981, 37.34152], [-122.19022, 37.34193], [-122.19054, 37.34227], [-122.19063, 37.34234], [-122.19078, 37.34256], [-122.19104, 37.34304], [-122.19123, 37.34331], [-122.19132, 37.3434], [-122.19172, 37.34369], [-122.19225, 37.34397], [-122.19245, 37.34411], [-122.19334, 37.34485], [-122.19415, 37.34572], [-122.19477, 37.34656], [-122.19495, 37.34674], [-122.19507, 37.3469], [-122.19527, 37.34727], [-122.19537, 37.34737], [-122.19573, 37.34791], [-122.19587, 37.34819], [-122.19587, 37.34861], [-122.19583, 37.3488], [-122.19585, 37.34915], [-122.19597, 37.3496], [-122.19595, 37.34979], [-122.19585, 37.34997], [-122.19578, 37.35027], [-122.19576, 37.35063], [-122.19589, 37.35103], [-122.19597, 37.35123], [-122.19616, 37.35138], [-122.19628, 37.35152], [-122.19681, 37.35201], [-122.19698, 37.35212], [-122.19724, 37.35244], [-122.19734, 37.35259], [-122.19748, 37.35297], [-122.19769, 37.35325], [-122.19788, 37.35361], [-122.19802, 37.35406], [-122.19823, 37.35432], [-122.19849, 37.35445], [-122.19866, 37.35465], [-122.19887, 37.35483], [-122.1992, 37.35517], [-122.19939, 37.35529], [-122.19955, 37.35533], [-122.19972, 37.35545], [-122.19997, 37.35579], [-122.20002, 37.35596], [-122.20014, 37.35615], [-122.20028, 37.35643]]]} | Restricted Access 2 | 16498 | Foothills Park | 18984 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1303.372 | Foothills Park | 2000 | Local Park 2 | 4 | |
15673 | 15673 | 15672 | {"type": "MultiPolygon", "coordinates": [[[[-121.89541, 37.37943], [-121.89427, 37.37942], [-121.89269, 37.38197], [-121.8899, 37.37991], [-121.88744, 37.38246], [-121.88659, 37.38185], [-121.88541, 37.38076], [-121.88537, 37.38074], [-121.88537, 37.38072], [-121.88526, 37.38062], [-121.88521, 37.38053], [-121.88522, 37.38051], [-121.88453, 37.37987], [-121.88737, 37.37696], [-121.88571, 37.37551], [-121.88156, 37.37982], [-121.88142, 37.37967], [-121.88134, 37.37955], [-121.88131, 37.37944], [-121.88131, 37.37918], [-121.88142, 37.3789], [-121.88145, 37.37874], [-121.88145, 37.37859], [-121.88141, 37.37841], [-121.88133, 37.37826], [-121.88121, 37.37811], [-121.8811, 37.37802], [-121.88083, 37.37784], [-121.88082, 37.37781], [-121.88084, 37.37775], [-121.88072, 37.37768], [-121.8857, 37.3726], [-121.88699, 37.37171], [-121.88727, 37.37166], [-121.88755, 37.37144], [-121.8885, 37.37244], [-121.88866, 37.37235], [-121.88949, 37.37327], [-121.8897, 37.37398], [-121.88948, 37.37413], [-121.88976, 37.37467], [-121.89069, 37.37628], [-121.89054, 37.3768], [-121.89386, 37.37757], [-121.89432, 37.37694], [-121.8944, 37.37697], [-121.89454, 37.37694], [-121.89449, 37.37698], [-121.89447, 37.37703], [-121.89448, 37.37707], [-121.89453, 37.37712], [-121.8946, 37.37714], [-121.89468, 37.37713], [-121.89481, 37.37704], [-121.89517, 37.37697], [-121.89523, 37.37698], [-121.89525, 37.37701], [-121.89534, 37.37741], [-121.8954, 37.37782], [-121.89544, 37.3783], [-121.89545, 37.37859], [-121.89545, 37.37896], [-121.89541, 37.37943]]], [[[-121.89521, 37.37684], [-121.89516, 37.37689], [-121.89478, 37.37696], [-121.89463, 37.37692], [-121.8952, 37.37682], [-121.89521, 37.37684]]]]} | Restricted Access 2 | 9687 | San Jose Municipal Golf Course | 33028 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 169.542 | San Jose Municipal GC | 2000 | Local Recreation Area 3 | 4 | |
15638 | 15638 | 15637 | {"type": "Polygon", "coordinates": [[[-117.02536, 33.01762], [-117.0241, 33.01851], [-117.02409, 33.01859], [-117.02226, 33.01869], [-117.02223, 33.01607], [-117.02353, 33.01605], [-117.02405, 33.01608], [-117.02415, 33.01631], [-117.02426, 33.01652], [-117.02438, 33.01672], [-117.02457, 33.01696], [-117.0249, 33.01729], [-117.02514, 33.01748], [-117.02536, 33.01762]]]} | Restricted Access 2 | 45140 | Blue Sky Ecological Reserve | 29221 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 15.494 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
9458 | 9458 | 9457 | {"type": "Polygon", "coordinates": [[[-121.91787, 37.70301], [-121.91749, 37.7032], [-121.91745, 37.7035], [-121.91675, 37.70379], [-121.91628, 37.70412], [-121.91617, 37.70434], [-121.9134, 37.70372], [-121.91278, 37.70359], [-121.91207, 37.70363], [-121.91182, 37.70216], [-121.91671, 37.7022], [-121.91696, 37.70262], [-121.91755, 37.70242], [-121.91787, 37.70301]]]} | Restricted Access 2 | 15814 | Dublin Sports Grounds | 18293 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 22.454 | Dublin Sports Grounds | 1989 | None 781 | ||
16120 | 16120 | 16119 | {"type": "Polygon", "coordinates": [[[-121.92213, 37.72774], [-121.91472, 37.72954], [-121.91488, 37.72937], [-121.91489, 37.72922], [-121.91462, 37.72896], [-121.91451, 37.72879], [-121.91451, 37.72865], [-121.9149, 37.72797], [-121.91497, 37.72771], [-121.91501, 37.72711], [-121.91481, 37.72653], [-121.915, 37.72565], [-121.91513, 37.72526], [-121.91498, 37.72457], [-121.91456, 37.72423], [-121.91415, 37.7233], [-121.91374, 37.72189], [-121.91326, 37.72198], [-121.9128, 37.72245], [-121.91233, 37.72278], [-121.91233, 37.72332], [-121.91214, 37.72362], [-121.91188, 37.72395], [-121.91156, 37.72358], [-121.91177, 37.72344], [-121.91179, 37.72307], [-121.91174, 37.72271], [-121.91185, 37.72236], [-121.91216, 37.72214], [-121.91265, 37.72189], [-121.91302, 37.72152], [-121.91319, 37.72097], [-121.91346, 37.7208], [-121.91356, 37.72071], [-121.91361, 37.72053], [-121.91358, 37.72035], [-121.91349, 37.72024], [-121.91343, 37.72013], [-121.91345, 37.71951], [-121.9134, 37.71937], [-121.91329, 37.71923], [-121.91287, 37.71888], [-121.91262, 37.71854], [-121.9137, 37.71795], [-121.9139, 37.71816], [-121.91466, 37.71777], [-121.91504, 37.71766], [-121.91517, 37.71767], [-121.91618, 37.71882], [-121.91644, 37.71908], [-121.917, 37.71972], [-121.91727, 37.71981], [-121.91753, 37.71983], [-121.91812, 37.71962], [-121.91828, 37.71985], [-121.91834, 37.72002], [-121.91838, 37.72017], [-121.9184, 37.72037], [-121.91834, 37.7204], [-121.91767, 37.7204], [-121.91749, 37.72045], [-121.91729, 37.72056], [-121.91716, 37.72077], [-121.9171, 37.72119], [-121.91704, 37.72176], [-121.91669, 37.72177], [-121.91673, 37.72213], [-121.917, 37.72295], [-121.91741, 37.72286], [-121.91751, 37.72289], [-121.91824, 37.72275], [-121.91853, 37.72271], [-121.91862, 37.72271], [-121.91867, 37.72277], [-121.91888, 37.72346], [-121.91892, 37.72364], [-121.91838, 37.72378], [-121.91789, 37.72403], [-121.91756, 37.72435], [-121.9175, 37.72472], [-121.91779, 37.7252], [-121.91837, 37.7258], [-121.91866, 37.72598], [-121.91901, 37.72603], [-121.92001, 37.72582], [-121.92029, 37.72562], [-121.921, 37.72617], [-121.92148, 37.72667], [-121.92199, 37.72731], [-121.92213, 37.72774]]]} | Restricted Access 2 | 15770 | Dougherty Hills Open Space | 18241 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 116.934 | Dougherty Hills OS | 1989 | Local Recreation Area 3 | 4 | |
7202 | 7202 | 7201 | {"type": "MultiPolygon", "coordinates": [[[[-122.08675, 37.42707], [-122.08665, 37.42777], [-122.0866, 37.42777], [-122.08652, 37.42829], [-122.08642, 37.42853], [-122.08634, 37.42879], [-122.08634, 37.4303], [-122.08631, 37.4319], [-122.08627, 37.43212], [-122.08618, 37.43232], [-122.07998, 37.43227], [-122.07998, 37.43132], [-122.07863, 37.43129], [-122.07818, 37.43017], [-122.07811, 37.42836], [-122.0782, 37.42835], [-122.07825, 37.42808], [-122.07871, 37.42822], [-122.07869, 37.42827], [-122.0787, 37.42828], [-122.07905, 37.42837], [-122.07918, 37.42839], [-122.07931, 37.42835], [-122.07941, 37.42831], [-122.07951, 37.42824], [-122.0796, 37.42813], [-122.0797, 37.42809], [-122.08017, 37.42808], [-122.08018, 37.42802], [-122.08101, 37.42802], [-122.08132, 37.42798], [-122.08163, 37.4279], [-122.08192, 37.42776], [-122.08196, 37.4278], [-122.08199, 37.42778], [-122.08212, 37.42768], [-122.08222, 37.42756], [-122.0823, 37.42743], [-122.08236, 37.42729], [-122.08235, 37.42727], [-122.0823, 37.42726], [-122.08232, 37.42705], [-122.08231, 37.42687], [-122.08227, 37.42669], [-122.08222, 37.42655], [-122.08214, 37.42641], [-122.08206, 37.4263], [-122.08198, 37.42634], [-122.0819, 37.4262], [-122.08171, 37.42594], [-122.0814, 37.42575], [-122.08137, 37.42576], [-122.08116, 37.42567], [-122.08118, 37.42556], [-122.08056, 37.42392], [-122.08052, 37.42331], [-122.08252, 37.42314], [-122.08323, 37.42312], [-122.08368, 37.42312], [-122.08438, 37.42316], [-122.08484, 37.42321], [-122.08644, 37.42349], [-122.08643, 37.4251], [-122.08648, 37.42532], [-122.08658, 37.42552], [-122.08658, 37.42554], [-122.08664, 37.42566], [-122.08667, 37.42578], [-122.08672, 37.42643], [-122.08671, 37.42644], [-122.08675, 37.42707]], [[-122.08565, 37.42951], [-122.08582, 37.42933], [-122.08576, 37.42914], [-122.0844, 37.4291], [-122.08442, 37.4296], [-122.08422, 37.42967], [-122.08298, 37.42981], [-122.08175, 37.43038], [-122.08106, 37.43059], [-122.08118, 37.43081], [-122.08189, 37.43067], [-122.08301, 37.43019], [-122.08385, 37.43006], [-122.08567, 37.42997], [-122.08565, 37.42951]]], [[[-122.09679, 37.43194], [-122.09677, 37.43202], [-122.09523, 37.43188], [-122.09523, 37.4321], [-122.09529, 37.43234], [-122.09543, 37.43261], [-122.0956, 37.43281], [-122.09581, 37.43298], [-122.09607, 37.43312], [-122.09633, 37.4332], [-122.09662, 37.43324], [-122.09647, 37.43436], [-122.09557, 37.43461], [-122.09481, 37.43405], [-122.09451, 37.43353], [-122.09493, 37.43321], [-122.09492, 37.43296], [-122.09465, 37.43263], [-122.09358, 37.43242], [-122.09288, 37.43266], [-122.09258, 37.43252], [-122.08673, 37.43233], [-122.08677, 37.43221], [-122.0868, 37.43188], [-122.08683, 37.42881], [-122.08695, 37.42803], [-122.08691, 37.428], [-122.087, 37.42744], [-122.08702, 37.42715], [-122.08701, 37.42662], [-122.08698, 37.42661], [-122.08698, 37.42595], [-122.08709, 37.42469], [-122.09056, 37.42473], [-122.09126, 37.42477], [-122.09197, 37.42493], [-122.09235, 37.42504], [-122.09272, 37.42518], [-122.09314, 37.42536], [-122.09353, 37.42559], [-122.09379, 37.42577], [-122.09422, 37.42612], [-122.09449, 37.4264], [-122.0947, 37.42666], [-122.09497, 37.42707], [-122.09512, 37.42725], [-122.09526, 37.42758], [-122.09537, 37.42794], [-122.09543, 37.4283], [-122.09545, 37.42873], [-122.09524, 37.43178], [-122.09679, 37.43194]], [[-122.09321, 37.42862], [-122.09353, 37.4287], [-122.09364, 37.42845], [-122.09299, 37.42828], [-122.09295, 37.4287], [-122.09319, 37.42876], [-122.09324, 37.42867], [-122.09321, 37.42862]], [[-122.09427, 37.42776], [-122.09428, 37.42775], [-122.09427, 37.42758], [-122.09406, 37.42767], [-122.09427, 37.42776]]]]} | Restricted Access 2 | 48420 | Shoreline Golf Links | 33080 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | https://www.shorelinelinks.com/ | Santa Clara 19 | 289.243 | Shoreline Golf Links | 1986 | None 590 | |
672 | 672 | 671 | {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} | Restricted Access 2 | 5104 | 711 St. Mary's Road Park | 15210 | 1163 | Lafayette, City of 236 | City 2 | City Agency 2 | http://www.ci.lafayette.ca.us/index.aspx?page=87 | City 2 | 1163 | Lafayette, City of 232 | City 2 | City Agency 2 | Contra Costa 12 | 11.502 | 711 St. Mary's Road Park | 1983 | Local Park 2 | 4 | |
15686 | 15686 | 15685 | {"type": "Polygon", "coordinates": [[[-122.01399, 37.35581], [-122.0114, 37.35583], [-122.0114, 37.35718], [-122.01079, 37.35719], [-122.0108, 37.35809], [-122.0096, 37.3581], [-122.00959, 37.35657], [-122.0089, 37.35657], [-122.00884, 37.35401], [-122.01249, 37.354], [-122.01244, 37.35412], [-122.01253, 37.35423], [-122.01255, 37.35431], [-122.0126, 37.35437], [-122.01276, 37.35444], [-122.01297, 37.35465], [-122.01317, 37.35482], [-122.01336, 37.35488], [-122.01355, 37.35483], [-122.01367, 37.35484], [-122.01373, 37.35488], [-122.01396, 37.35487], [-122.01399, 37.35475], [-122.01399, 37.35581]]]} | Restricted Access 2 | 15064 | Sunken Gardens Golf Course | 33046 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 29.974 | Sunken Gardens GC | 1973 | Local Recreation Area 3 | 4 | |
8946 | 8946 | 8945 | {"type": "Polygon", "coordinates": [[[-121.80491, 37.3407], [-121.80352, 37.34138], [-121.80049, 37.34294], [-121.79836, 37.34402], [-121.79822, 37.34393], [-121.798, 37.34404], [-121.79769, 37.34375], [-121.79714, 37.34404], [-121.79506, 37.34263], [-121.79851, 37.34136], [-121.79448, 37.33693], [-121.80043, 37.33576], [-121.80489, 37.34064], [-121.80487, 37.34066], [-121.80491, 37.3407]]]} | Restricted Access 2 | 9698 | Pleasant Hills Golf Course | 33029 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 113.282 | Pleasant Hills GC | 1972 | Local Recreation Area 3 | 4 | |
15688 | 15688 | 15687 | {"type": "MultiPolygon", "coordinates": [[[[-122.48702, 37.6263], [-122.48655, 37.62658], [-122.48643, 37.62662], [-122.48629, 37.62664], [-122.48616, 37.62664], [-122.48603, 37.62661], [-122.48592, 37.62657], [-122.48575, 37.62645], [-122.48565, 37.62631], [-122.48562, 37.6262], [-122.48558, 37.62569], [-122.48554, 37.6255], [-122.48541, 37.62524], [-122.48523, 37.62504], [-122.48501, 37.6249], [-122.48476, 37.62481], [-122.48384, 37.62463], [-122.48351, 37.62461], [-122.48332, 37.62463], [-122.48314, 37.62466], [-122.48161, 37.62511], [-122.48145, 37.62518], [-122.4813, 37.62526], [-122.4811, 37.62542], [-122.48093, 37.62562], [-122.48076, 37.62597], [-122.48052, 37.62649], [-122.48042, 37.62664], [-122.4803, 37.62675], [-122.48014, 37.62685], [-122.47997, 37.62693], [-122.47977, 37.62698], [-122.47875, 37.62705], [-122.47843, 37.6271], [-122.4688, 37.62708], [-122.46426, 37.62116], [-122.48041, 37.62146], [-122.48416, 37.62155], [-122.4842, 37.62157], [-122.48433, 37.62181], [-122.48449, 37.62195], [-122.48455, 37.62202], [-122.48465, 37.62231], [-122.48478, 37.62296], [-122.48492, 37.62338], [-122.48502, 37.6247], [-122.48516, 37.62476], [-122.48526, 37.62484], [-122.48533, 37.62493], [-122.48539, 37.62505], [-122.48659, 37.62582], [-122.48702, 37.6263]]], [[[-122.48741, 37.62712], [-122.48228, 37.62711], [-122.48228, 37.62601], [-122.48126, 37.62601], [-122.48125, 37.62656], [-122.48099, 37.62656], [-122.48098, 37.6271], [-122.48003, 37.6271], [-122.48021, 37.62703], [-122.48036, 37.62694], [-122.4805, 37.62682], [-122.48061, 37.6267], [-122.48073, 37.62653], [-122.48111, 37.6257], [-122.48124, 37.62553], [-122.48141, 37.6254], [-122.48169, 37.62527], [-122.48319, 37.62482], [-122.48338, 37.62478], [-122.48358, 37.62477], [-122.48382, 37.62479], [-122.48471, 37.62497], [-122.48493, 37.62506], [-122.4851, 37.62517], [-122.48523, 37.62533], [-122.4853, 37.62544], [-122.48535, 37.62557], [-122.48537, 37.6257], [-122.48542, 37.62622], [-122.48545, 37.62635], [-122.48556, 37.62653], [-122.48573, 37.62667], [-122.4859, 37.62675], [-122.48606, 37.62679], [-122.48625, 37.62681], [-122.48642, 37.62679], [-122.48666, 37.62672], [-122.48715, 37.62643], [-122.48726, 37.62655], [-122.48727, 37.62691], [-122.48741, 37.62712]]], [[[-122.49707, 37.62106], [-122.49634, 37.62137], [-122.49632, 37.62144], [-122.49668, 37.62221], [-122.49506, 37.62934], [-122.49503, 37.62979], [-122.49502, 37.62963], [-122.49501, 37.62962], [-122.49458, 37.62988], [-122.49433, 37.63], [-122.49411, 37.63001], [-122.49409, 37.62982], [-122.49222, 37.62982], [-122.49189, 37.62978], [-122.49148, 37.62965], [-122.49127, 37.62955], [-122.49115, 37.62947], [-122.49101, 37.62934], [-122.49083, 37.62911], [-122.49076, 37.62898], [-122.49068, 37.62876], [-122.49065, 37.62864], [-122.49057, 37.6272], [-122.48958, 37.62723], [-122.48938, 37.62671], [-122.48924, 37.62643], [-122.48908, 37.6262], [-122.48887, 37.62595], [-122.4887, 37.62578], [-122.48815, 37.62535], [-122.48786, 37.62507], [-122.48618, 37.62321], [-122.48574, 37.62275], [-122.48556, 37.62251], [-122.48553, 37.62225], [-122.48562, 37.62203], [-122.48591, 37.62164], [-122.49152, 37.62174], [-122.49152, 37.62169], [-122.49159, 37.62173], [-122.49344, 37.62181], [-122.4931, 37.62054], [-122.49707, 37.62106]]]]} | Restricted Access 2 | 15359 | Sharp Park Golf Course | 33048 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Mateo 15 | 407.344 | Sharp Park GC | 1972 | Local Recreation Area 3 | 4 | |
15684 | 15684 | 15683 | {"type": "MultiPolygon", "coordinates": [[[[-121.88339, 37.45608], [-121.88337, 37.4563], [-121.88338, 37.45676], [-121.88435, 37.4581], [-121.88439, 37.45824], [-121.88437, 37.45839], [-121.88411, 37.45894], [-121.88403, 37.45929], [-121.88405, 37.45946], [-121.8842, 37.45998], [-121.88427, 37.46011], [-121.88428, 37.46025], [-121.88426, 37.46033], [-121.88418, 37.46043], [-121.88411, 37.46048], [-121.88396, 37.46054], [-121.88309, 37.46065], [-121.88177, 37.46067], [-121.88137, 37.46076], [-121.88108, 37.46086], [-121.88083, 37.46088], [-121.88066, 37.46086], [-121.8805, 37.46082], [-121.88035, 37.46074], [-121.88025, 37.46066], [-121.88017, 37.46062], [-121.87999, 37.46055], [-121.87981, 37.46051], [-121.87961, 37.4605], [-121.87917, 37.46053], [-121.87856, 37.46052], [-121.8784, 37.46049], [-121.87804, 37.46039], [-121.87785, 37.46038], [-121.87772, 37.46041], [-121.8776, 37.46046], [-121.87747, 37.46057], [-121.87741, 37.46066], [-121.87729, 37.46096], [-121.87717, 37.46109], [-121.87706, 37.46115], [-121.87694, 37.46119], [-121.87674, 37.46119], [-121.87661, 37.46116], [-121.8765, 37.4611], [-121.8762, 37.46082], [-121.87607, 37.46075], [-121.87593, 37.4607], [-121.87578, 37.46068], [-121.87563, 37.46068], [-121.87548, 37.46071], [-121.87525, 37.46079], [-121.87514, 37.4608], [-121.87503, 37.46079], [-121.87488, 37.46072], [-121.8748, 37.46066], [-121.8747, 37.46049], [-121.87461, 37.46041], [-121.87362, 37.45984], [-121.87344, 37.45971], [-121.87206, 37.45854], [-121.87198, 37.45846], [-121.87193, 37.45832], [-121.87195, 37.45818], [-121.87204, 37.45805], [-121.87213, 37.45799], [-121.87224, 37.45795], [-121.87242, 37.45794], [-121.87485, 37.45908], [-121.87732, 37.45937], [-121.87878, 37.45978], [-121.88001, 37.45977], [-121.88283, 37.45912], [-121.88265, 37.45858], [-121.8803, 37.4566], [-121.88033, 37.45653], [-121.8803, 37.45623], [-121.88032, 37.45611], [-121.8804, 37.45588], [-121.88047, 37.45578], [-121.88057, 37.4557], [-121.88069, 37.45564], [-121.88087, 37.4556], [-121.88106, 37.45562], [-121.88145, 37.45576], [-121.88161, 37.4558], [-121.88178, 37.45582], [-121.88179, 37.45583], [-121.88203, 37.45582], [-121.88204, 37.4558], [-121.8826, 37.4557], [-121.88283, 37.45601], [-121.88339, 37.45608]]], [[[-121.88252, 37.45558], [-121.88232, 37.45562], [-121.88213, 37.45555], [-121.88191, 37.45557], [-121.88187, 37.45561], [-121.88188, 37.45567], [-121.88178, 37.4557], [-121.88177, 37.45572], [-121.8815, 37.45567], [-121.88104, 37.45551], [-121.88083, 37.4555], [-121.88063, 37.45555], [-121.88045, 37.45565], [-121.88036, 37.45574], [-121.88031, 37.45583], [-121.88022, 37.45609], [-121.88019, 37.45622], [-121.88012, 37.45628], [-121.88009, 37.45632], [-121.88009, 37.45636], [-121.88015, 37.45643], [-121.88016, 37.45649], [-121.87827, 37.45541], [-121.87696, 37.45533], [-121.87678, 37.4554], [-121.87665, 37.45537], [-121.87645, 37.45535], [-121.87636, 37.45547], [-121.87557, 37.45586], [-121.8754, 37.4557], [-121.87528, 37.45562], [-121.87505, 37.45557], [-121.87468, 37.45575], [-121.87388, 37.45513], [-121.87366, 37.45498], [-121.8734, 37.45488], [-121.87276, 37.45472], [-121.87252, 37.4546], [-121.87234, 37.45443], [-121.87225, 37.4543], [-121.87217, 37.45409], [-121.87216, 37.45388], [-121.87222, 37.45367], [-121.87231, 37.45354], [-121.87249, 37.45339], [-121.87264, 37.45331], [-121.87283, 37.45325], [-121.87345, 37.45312], [-121.87612, 37.45241], [-121.87637, 37.45237], [-121.87663, 37.45234], [-121.87755, 37.45237], [-121.8777, 37.4524], [-121.87796, 37.45256], [-121.8781, 37.4526], [-121.87824, 37.4526], [-121.87839, 37.45256], [-121.87853, 37.45251], [-121.87865, 37.45243], [-121.87898, 37.45216], [-121.8791, 37.4521], [-121.8793, 37.45205], [-121.8795, 37.45206], [-121.87963, 37.4521], [-121.87976, 37.45216], [-121.88012, 37.45239], [-121.88033, 37.45256], [-121.88061, 37.45284], [-121.8821, 37.45502], [-121.88252, 37.45558]]]]} | Restricted Access 2 | 14968 | Summit Pointe Golf Course | 33044 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 121.004 | Summit Pointe GC | 1968 | Local Recreation Area 3 | 4 | |
15685 | 15685 | 15684 | {"type": "Polygon", "coordinates": [[[-122.04736, 37.40153], [-122.04691, 37.40278], [-122.03717, 37.40067], [-122.03605, 37.39921], [-122.03747, 37.39524], [-122.03902, 37.39562], [-122.03883, 37.3962], [-122.04096, 37.3967], [-122.04173, 37.39628], [-122.04241, 37.3958], [-122.04306, 37.394], [-122.04542, 37.39474], [-122.04643, 37.39543], [-122.04496, 37.39972], [-122.04631, 37.40012], [-122.04597, 37.40123], [-122.04736, 37.40153]]]} | Restricted Access 2 | 15039 | Sunnyvale Municipal Golf Course | 33045 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 139.241 | Sunnyvale Municipal GC | 1965 | Local Recreation Area 3 | 4 | |
4114 | 4114 | 4113 | {"type": "Polygon", "coordinates": [[[-121.95833, 37.55749], [-121.95738, 37.55758], [-121.95719, 37.55717], [-121.95711, 37.55712], [-121.95703, 37.55709], [-121.95693, 37.55709], [-121.95685, 37.55712], [-121.95677, 37.55717], [-121.95673, 37.55724], [-121.95672, 37.55731], [-121.95674, 37.55737], [-121.9568, 37.55744], [-121.95688, 37.55748], [-121.95697, 37.5575], [-121.95708, 37.55749], [-121.95713, 37.55751], [-121.95743, 37.55814], [-121.95587, 37.55859], [-121.95559, 37.55471], [-121.95566, 37.55461], [-121.95552, 37.55247], [-121.95541, 37.55221], [-121.95531, 37.55064], [-121.95513, 37.55065], [-121.95499, 37.54848], [-121.95581, 37.54785], [-121.95674, 37.54713], [-121.95833, 37.55749]]]} | Restricted Access 2 | 47146 | Fremont Park Golf Club | 33120 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 53.791 | Fremont Park Golf Club | 1960 | Local Recreation Area 3 | 4 | |
15395 | 15395 | 15394 | {"type": "Polygon", "coordinates": [[[-118.39514, 33.8615], [-118.39468, 33.86158], [-118.39458, 33.86123], [-118.39504, 33.86114], [-118.39514, 33.8615]]]} | Restricted Access 2 | 46635 | Lawn Bowling Green | 29962 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=262 | Los Angeles 6 | 0.443 | Lawn Bowling Green | 1958 | Local Park 2 | 4 |
15662 | 15662 | 15661 | {"type": "Polygon", "coordinates": [[[-122.28084, 38.26895], [-122.2782, 38.26902], [-122.27678, 38.2671], [-122.2763, 38.26736], [-122.27697, 38.26817], [-122.27675, 38.26949], [-122.27213, 38.27026], [-122.2719, 38.2693], [-122.27173, 38.26867], [-122.27151, 38.26765], [-122.27138, 38.26693], [-122.27119, 38.26559], [-122.27113, 38.26497], [-122.27106, 38.26416], [-122.27105, 38.26351], [-122.27168, 38.26331], [-122.27332, 38.2629], [-122.27458, 38.26299], [-122.2765, 38.26337], [-122.27675, 38.2632], [-122.27694, 38.26317], [-122.27776, 38.26348], [-122.27804, 38.26325], [-122.27815, 38.26282], [-122.27845, 38.26244], [-122.27855, 38.26202], [-122.2785, 38.26124], [-122.2787, 38.26096], [-122.27943, 38.26047], [-122.28056, 38.25989], [-122.28082, 38.2597], [-122.28084, 38.26895]]]} | Restricted Access 2 | 48419 | Napa Golf Course | 33054 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | https://www.playnapa.com/ | Napa 11 | 155.995 | Napa GC | 1958 | Local Recreation Area 3 | 4 |
15680 | 15680 | 15679 | {"type": "Polygon", "coordinates": [[[-122.3278, 37.584], [-122.32787, 37.58495], [-122.32785, 37.58503], [-122.3278, 37.58512], [-122.32454, 37.58738], [-122.32439, 37.58746], [-122.32426, 37.58749], [-122.32339, 37.58752], [-122.32316, 37.58757], [-122.32295, 37.58766], [-122.32265, 37.58791], [-122.32253, 37.58797], [-122.32238, 37.58802], [-122.32142, 37.58816], [-122.32145, 37.58826], [-122.32097, 37.58825], [-122.32072, 37.58807], [-122.3202, 37.58694], [-122.31931, 37.58631], [-122.31857, 37.58615], [-122.31794, 37.58639], [-122.31797, 37.58625], [-122.31788, 37.58596], [-122.31775, 37.58567], [-122.31758, 37.5851], [-122.3241, 37.5806], [-122.3278, 37.584]]]} | Restricted Access 2 | 14014 | San Mateo Municipal Golf Course | 33037 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 105.785 | San Mateo Municipal GC | 1933 | 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]);