units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 6,081
- State Agency 792
- Recreation/Parks District 784
- County Agency 689
- Non Profit - Land Trust 330
- Federal Agency 318
- Open Space District 248
- Water District 159
- Community Services District 157
- County Agency - Parks 155
- Home Owners Association 151
- Non Profit - Conservation 100
- Flood District 71
- Irrigation District 34
- School District 30
- Non Profit - Other 26
- Cemetery District 16
- Port/Harbor District 16
- County Agency - Other 15
- Special District - Other 13
- Commercial 9
- Joint Powers Authority 7
- Sanitation District 6
- Other 5
- Conservation District 5
- Transportation Agency 5
- Non Profit - Cemetery District 4
- Mitigation Bank 3
- Non Profit - Education 3
- Metropolitan Planning Organization 1
- …
MNG_AGENCY >30
- California Department of Fish and Wildlife 304
- California Department of Parks and Recreation 289
- Los Angeles, City of 265
- San Diego, City of 245
- Mountains Recreation and Conservation Authority 185
- San Jose, City of 148
- Sacramento, City of 145
- East Bay Regional Park District 132
- San Francisco, City and County of 115
- Ventura, City of 114
- Los Angeles, County of 111
- Long Beach, City of 111
- Roseville, City of 98
- Consumnes Community Services District 86
- Oakland, City of 81
- United States Bureau of Land Management 70
- United States Fish and Wildlife Service 67
- California State Lands Commission 67
- Orange, County of 62
- Irvine, City of 62
- United States Forest Service 61
- Hayward Area Recreation and Park District 60
- Napa, City of 59
- Davis, City of 57
- Stockton, City of 56
- United States National Park Service 54
- San Diego, County of 53
- Poway, City of 52
- Torrance, City of 52
- Santa Barbara, County of 51
- …
DES_TP >30
- Local Park 5,225
- Local Recreation Area 1,356
- Local Other or Unknown 763
- Private Conservation 380
- Local Conservation Area 329
- State Conservation Area 286
- Private Recreation or Education 185
- State Park 166
- State Recreation Area 106
- State Resource Management Area 104
- National Wildlife Refuge 61
- National Forest 56
- State Historic or Cultural Area 51
- National Public Lands 41
- Local Historic or Cultural Area 41
- Recreation Management Area 40
- National Monument or Landmark 27
- National Recreation Area 25
- State Other or Unknown 23
- National Park 15
- Local Resource Management Area 14
- Federal Other or Unknown 13
- Resource Management Area 11
- Conservation Area 10
- Private Agricultural 9
- Private Other or Unknown 9
- Area of Critical Environmental Concern 5
- Historic or Cultural Area 4
- Private Historic or Cultural 3
- Wilderness Area 2
- …
ACCESS_TYP 4
- Open Access 8,624
- Restricted Access 808
- No Public Access 609
- Unknown Access 194
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6834 | 6834 | 6833 | {"type": "MultiPolygon", "coordinates": [[[[-122.38909, 37.71702], [-122.38813, 37.71809], [-122.387, 37.71745], [-122.3879, 37.71646], [-122.38796, 37.71642], [-122.38806, 37.71643], [-122.38909, 37.71702]]], [[[-122.38859, 37.71548], [-122.38852, 37.71556], [-122.38854, 37.71568], [-122.38853, 37.71575], [-122.3884, 37.71602], [-122.38832, 37.71612], [-122.38849, 37.71638], [-122.38857, 37.71643], [-122.38856, 37.71644], [-122.38841, 37.71636], [-122.38834, 37.71628], [-122.38804, 37.71536], [-122.38827, 37.7151], [-122.3884, 37.71518], [-122.38859, 37.71548]]]]} | Open Access 1 | 5455 | Gilman Playground | 19297 | 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 Francisco 13 | 5.205 | Gilman Playground | 0 | Local Recreation Area 3 | 4 | |
6835 | 6835 | 6834 | {"type": "Polygon", "coordinates": [[[-122.39877, 37.7096], [-122.39849, 37.71035], [-122.39758, 37.71014], [-122.39769, 37.70985], [-122.39779, 37.70987], [-122.39786, 37.70975], [-122.39877, 37.7096]]]} | Open Access 1 | 5457 | Little Hollywood Park | 21339 | 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 Francisco 13 | 1.313 | Little Hollywood Park | 0 | Local Park 2 | 4 | |
6836 | 6836 | 6835 | {"type": "Polygon", "coordinates": [[[-117.72152, 34.07416], [-117.72151, 34.0754], [-117.72053, 34.07541], [-117.72052, 34.07529], [-117.72046, 34.075], [-117.72046, 34.07416], [-117.72152, 34.07416]]]} | Open Access 1 | 5458 | Montvue Park | 22444 | 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 | 3.286 | Montvue Park | 0 | Local Park 2 | 4 | |
6837 | 6837 | 6836 | {"type": "Polygon", "coordinates": [[[-122.49841, 37.74932], [-122.49761, 37.74935], [-122.4976, 37.74941], [-122.49561, 37.7495], [-122.4956, 37.74928], [-122.49643, 37.74925], [-122.49633, 37.74786], [-122.49834, 37.74777], [-122.49841, 37.74932]]]} | Open Access 1 | 5460 | Sunset West Playground | 26071 | 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 Francisco 13 | 8.05 | Sunset West Playground | 0 | Local Recreation Area 3 | 4 | |
6838 | 6838 | 6837 | {"type": "Polygon", "coordinates": [[[-118.57055, 34.2891], [-118.57056, 34.28958], [-118.57055, 34.28979], [-118.5705, 34.29004], [-118.57038, 34.29044], [-118.57008, 34.29111], [-118.57, 34.2913], [-118.56994, 34.29158], [-118.56991, 34.29187], [-118.56992, 34.29207], [-118.56995, 34.29227], [-118.57004, 34.29259], [-118.57015, 34.29284], [-118.57048, 34.29336], [-118.57049, 34.29339], [-118.57046, 34.29343], [-118.56939, 34.29391], [-118.56924, 34.29034], [-118.569, 34.2896], [-118.56832, 34.28908], [-118.56801, 34.28867], [-118.56651, 34.28756], [-118.56496, 34.28693], [-118.56496, 34.28526], [-118.56538, 34.28583], [-118.57055, 34.2891]]]} | Open Access 1 | 5467 | Moonshine Canton Park | 22453 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 25.888 | Moonshine Canton Park | 0 | Local Park 2 | 4 | |
6839 | 6839 | 6838 | {"type": "Polygon", "coordinates": [[[-117.7037, 34.08698], [-117.7037, 34.08838], [-117.70306, 34.08836], [-117.70305, 34.08872], [-117.70261, 34.08871], [-117.70309, 34.08696], [-117.7037, 34.08698]]]} | Open Access 1 | 5499 | Moreno Vista Park | 22479 | 1210 | Montclair, City of 55 | City 2 | City Agency 2 | http://www.ci.montclair.ca.us/ | City 2 | 1210 | Montclair, City of 53 | City 2 | City Agency 2 | San Bernardino 22 | 3.205 | Moreno Vista Park | 0 | Local Park 2 | 4 | |
6840 | 6840 | 6839 | {"type": "MultiPolygon", "coordinates": [[[[-122.30443, 37.92294], [-122.30401, 37.92313], [-122.30408, 37.92332], [-122.30401, 37.92354], [-122.30422, 37.92384], [-122.30247, 37.92464], [-122.30208, 37.92435], [-122.29973, 37.92584], [-122.30015, 37.92458], [-122.29997, 37.92377], [-122.30023, 37.92358], [-122.30107, 37.92361], [-122.30108, 37.92359], [-122.30011, 37.92288], [-122.29998, 37.92276], [-122.29934, 37.92321], [-122.29848, 37.92338], [-122.29801, 37.92345], [-122.29781, 37.92284], [-122.29933, 37.92216], [-122.29933, 37.92215], [-122.29867, 37.92156], [-122.298, 37.92088], [-122.29768, 37.92058], [-122.29676, 37.91987], [-122.29594, 37.91938], [-122.29536, 37.91863], [-122.29542, 37.91858], [-122.29552, 37.91835], [-122.29563, 37.91824], [-122.29574, 37.91818], [-122.29619, 37.91812], [-122.29638, 37.91811], [-122.29639, 37.9181], [-122.29634, 37.91803], [-122.29795, 37.91777], [-122.29863, 37.91746], [-122.29868, 37.91752], [-122.29902, 37.91746], [-122.29963, 37.91832], [-122.29917, 37.91854], [-122.29951, 37.91904], [-122.30079, 37.91847], [-122.30149, 37.91962], [-122.30235, 37.92081], [-122.30159, 37.92116], [-122.30263, 37.92258], [-122.30271, 37.92319], [-122.30339, 37.92374], [-122.30374, 37.92358], [-122.30372, 37.92316], [-122.3039, 37.92289], [-122.30419, 37.92257], [-122.30429, 37.92269], [-122.30428, 37.92273], [-122.30443, 37.92294]]], [[[-122.29972, 37.92585], [-122.3003, 37.92643], [-122.30156, 37.92608], [-122.30179, 37.9265], [-122.30186, 37.92649], [-122.30193, 37.92651], [-122.30197, 37.92655], [-122.30199, 37.92659], [-122.30194, 37.92675], [-122.30195, 37.92719], [-122.30192, 37.92725], [-122.30201, 37.92728], [-122.30199, 37.92735], [-122.30192, 37.92734], [-122.302, 37.92757], [-122.3016, 37.92767], [-122.30092, 37.9272], [-122.2999, 37.92708], [-122.29989, 37.92711], [-122.29946, 37.92729], [-122.2987, 37.9265], [-122.29972, 37.92585]]], [[[-122.30876, 37.92785], [-122.30587, 37.9279], [-122.30563, 37.92705], [-122.30492, 37.92648], [-122.30388, 37.92684], [-122.30325, 37.92733], [-122.30314, 37.92723], [-122.30278, 37.92747], [-122.30275, 37.92743], [-122.3031, 37.9272], [-122.30305, 37.92694], [-122.30313, 37.92679], [-122.30358, 37.92614], [-122.30399, 37.92576], [-122.30447, 37.9261], [-122.30716, 37.9249], [-122.30745, 37.92531], [-122.30777, 37.92516], [-122.30746, 37.92476], [-122.30747, 37.92476], [-122.30779, 37.92516], [-122.30781, 37.92572], [-122.30837, 37.92574], [-122.30839, 37.9258], [-122.3081, 37.92596], [-122.30809, 37.92597], [-122.30829, 37.92621], [-122.30868, 37.92621], [-122.30876, 37.92785]]]]} | Open Access 1 | 47537 | Hillside Natural Area | 31244 | 1094 | El Cerrito, City of 385 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/index.aspx?NID=812 | Contra Costa 12 | 98.951 | Hillside Natural Area | 0 | Local Conservation Area 4 | 2 |
6841 | 6841 | 6840 | {"type": "MultiPolygon", "coordinates": [[[[-117.23974, 32.85472], [-117.23925, 32.85483], [-117.23933, 32.85519], [-117.23937, 32.8556], [-117.23871, 32.85528], [-117.23828, 32.85503], [-117.23808, 32.85442], [-117.23954, 32.85411], [-117.23974, 32.85472]]], [[[-117.24498, 32.85374], [-117.24398, 32.85378], [-117.24242, 32.85398], [-117.24244, 32.85667], [-117.24223, 32.85667], [-117.24151, 32.85488], [-117.24143, 32.85473], [-117.24131, 32.85481], [-117.24108, 32.85498], [-117.24072, 32.85534], [-117.24022, 32.8554], [-117.24012, 32.85499], [-117.23979, 32.85406], [-117.24494, 32.85295], [-117.24498, 32.85374]]]]} | Open Access 1 | 330 | Pottery Canyon Natural Open Space Park | 23928 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 18.176 | Pottery Canyon Natural OS Park | 0 | Local Recreation Area 3 | 4 | |
6842 | 6842 | 6841 | {"type": "Polygon", "coordinates": [[[-118.62491, 34.03758], [-118.6246, 34.03769], [-118.62402, 34.03776], [-118.62328, 34.0378], [-118.62269, 34.0378], [-118.62242, 34.03779], [-118.62218, 34.0377], [-118.62193, 34.03765], [-118.62107, 34.03764], [-118.62025, 34.03753], [-118.61966, 34.0375], [-118.61937, 34.03744], [-118.61881, 34.03741], [-118.61666, 34.03722], [-118.61634, 34.03716], [-118.61595, 34.03704], [-118.61566, 34.03701], [-118.61535, 34.03694], [-118.61516, 34.03692], [-118.6148, 34.03692], [-118.61451, 34.03695], [-118.61391, 34.03695], [-118.61311, 34.03689], [-118.61289, 34.03691], [-118.61253, 34.03691], [-118.61234, 34.03688], [-118.61197, 34.03679], [-118.6119, 34.03683], [-118.61168, 34.03679], [-118.61022, 34.03651], [-118.60983, 34.03648], [-118.60949, 34.03654], [-118.60912, 34.03666], [-118.60906, 34.03649], [-118.60955, 34.03616], [-118.60993, 34.03612], [-118.61164, 34.03655], [-118.61233, 34.03669], [-118.61421, 34.03668], [-118.61548, 34.03682], [-118.61679, 34.03701], [-118.61735, 34.03698], [-118.61856, 34.03714], [-118.61901, 34.03728], [-118.61992, 34.03734], [-118.62085, 34.03746], [-118.62219, 34.03757], [-118.62289, 34.03761], [-118.62384, 34.0376], [-118.62484, 34.03749], [-118.62491, 34.03758]]]} | Open Access 1 | 5472 | Big Rock Beach | 16086 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 8.357 | Big Rock Beach | 0 | Local Park 2 | 4 | |
6843 | 6843 | 6842 | {"type": "Polygon", "coordinates": [[[-122.43359, 37.76495], [-122.43331, 37.76497], [-122.43331, 37.76488], [-122.43358, 37.76486], [-122.43359, 37.76495]]]} | Open Access 1 | 15927 | Noe & Beaver Mini Park | 22781 | 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 Francisco 13 | 0.059 | Noe & Beaver MP | 0 | Local Park 2 | 4 | |
6844 | 6844 | 6843 | {"type": "Polygon", "coordinates": [[[-118.65109, 34.03761], [-118.65102, 34.03789], [-118.65008, 34.03771], [-118.6496, 34.03764], [-118.64921, 34.03765], [-118.64889, 34.0377], [-118.64882, 34.03758], [-118.64861, 34.03759], [-118.64839, 34.0377], [-118.64783, 34.03813], [-118.64748, 34.03823], [-118.64702, 34.03832], [-118.64694, 34.0382], [-118.64591, 34.03819], [-118.64439, 34.03805], [-118.64366, 34.03796], [-118.64298, 34.03782], [-118.64224, 34.03772], [-118.63951, 34.03714], [-118.6382, 34.03681], [-118.63828, 34.0365], [-118.63964, 34.03684], [-118.64039, 34.03708], [-118.64171, 34.03736], [-118.64261, 34.03748], [-118.64325, 34.03763], [-118.64555, 34.03791], [-118.64655, 34.03796], [-118.64744, 34.03791], [-118.64803, 34.03772], [-118.64845, 34.03742], [-118.64907, 34.0373], [-118.64975, 34.03736], [-118.65109, 34.03761]]]} | Open Access 1 | 5473 | La Costa Beach | 29045 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Los Angeles 6 | 9.122 | La Costa Beach | None 555 | ||||
6845 | 6845 | 6844 | {"type": "Polygon", "coordinates": [[[-122.4606, 37.74202], [-122.46017, 37.74227], [-122.4602, 37.74231], [-122.4599, 37.74259], [-122.45924, 37.74241], [-122.45915, 37.74237], [-122.45931, 37.74182], [-122.45932, 37.74173], [-122.4593, 37.74167], [-122.45933, 37.7414], [-122.4596, 37.74141], [-122.45972, 37.74147], [-122.45971, 37.74151], [-122.45981, 37.74163], [-122.45974, 37.74167], [-122.45974, 37.74169], [-122.46008, 37.74186], [-122.46026, 37.74166], [-122.4606, 37.74202]]]} | Open Access 1 | 5470 | Edgehill Mountain | 18435 | 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 Francisco 13 | 2.345 | Edgehill Mtn. | None 556 | |||
6846 | 6846 | 6845 | {"type": "Polygon", "coordinates": [[[-118.67635, 34.03704], [-118.67555, 34.03741], [-118.67475, 34.03766], [-118.67481, 34.0378], [-118.67421, 34.03796], [-118.6731, 34.03833], [-118.67205, 34.03848], [-118.67185, 34.03853], [-118.67144, 34.03857], [-118.67137, 34.03871], [-118.67127, 34.03874], [-118.67122, 34.03872], [-118.67085, 34.03876], [-118.67075, 34.03884], [-118.67039, 34.03885], [-118.67036, 34.03875], [-118.67001, 34.03876], [-118.66988, 34.0388], [-118.66945, 34.03884], [-118.66921, 34.03881], [-118.6684, 34.03883], [-118.6682, 34.03886], [-118.66739, 34.03893], [-118.66734, 34.03909], [-118.66661, 34.03908], [-118.66655, 34.03896], [-118.66626, 34.03895], [-118.66409, 34.03909], [-118.66362, 34.03906], [-118.66324, 34.03906], [-118.66221, 34.03901], [-118.66136, 34.0389], [-118.66047, 34.03885], [-118.65996, 34.03878], [-118.65982, 34.03885], [-118.65873, 34.03879], [-118.65846, 34.03872], [-118.65774, 34.03872], [-118.6576, 34.03868], [-118.65617, 34.03852], [-118.65475, 34.03841], [-118.65425, 34.03831], [-118.65375, 34.03826], [-118.65313, 34.03815], [-118.65102, 34.03789], [-118.65109, 34.03761], [-118.65227, 34.03777], [-118.65334, 34.03795], [-118.65496, 34.03819], [-118.65582, 34.03828], [-118.65647, 34.03833], [-118.6568, 34.03837], [-118.65812, 34.03841], [-118.66, 34.03853], [-118.66038, 34.03854], [-118.66107, 34.0386], [-118.66209, 34.03864], [-118.66379, 34.03879], [-118.66522, 34.03882], [-118.66588, 34.0388], [-118.66629, 34.03876], [-118.6677, 34.03876], [-118.66784, 34.03874], [-118.66832, 34.03874], [-118.66862, 34.03868], [-118.66976, 34.03857], [-118.67077, 34.03849], [-118.671, 34.03853], [-118.67124, 34.0385], [-118.67166, 34.03846], [-118.67249, 34.03825], [-118.67327, 34.03808], [-118.67344, 34.03795], [-118.6741, 34.03774], [-118.67483, 34.03754], [-118.67571, 34.03725], [-118.67629, 34.03695], [-118.67635, 34.03704]]]} | Open Access 1 | 5474 | Carbon Beach | 16843 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.coastal.ca.gov/access/Carbon_Beach_Access.pdf | Los Angeles 6 | 15.407 | Carbon Beach | 0 | Local Park 2 | 4 |
6847 | 6847 | 6846 | {"type": "Polygon", "coordinates": [[[-118.70661, 34.02967], [-118.70628, 34.02966], [-118.70561, 34.02975], [-118.70525, 34.02983], [-118.70503, 34.03003], [-118.70481, 34.03012], [-118.70419, 34.03031], [-118.70382, 34.03037], [-118.70373, 34.03036], [-118.70346, 34.03042], [-118.70316, 34.03054], [-118.70299, 34.0305], [-118.70275, 34.03058], [-118.70225, 34.03072], [-118.70199, 34.03075], [-118.70161, 34.03085], [-118.70144, 34.03079], [-118.70127, 34.03077], [-118.70101, 34.0309], [-118.7003, 34.03111], [-118.70019, 34.03118], [-118.69989, 34.03128], [-118.69943, 34.03147], [-118.69944, 34.03155], [-118.69921, 34.0316], [-118.69917, 34.03149], [-118.69885, 34.03153], [-118.69884, 34.03154], [-118.69891, 34.03167], [-118.69846, 34.03179], [-118.69838, 34.03173], [-118.69825, 34.03179], [-118.69825, 34.03188], [-118.69792, 34.03201], [-118.69769, 34.03212], [-118.69763, 34.03207], [-118.69732, 34.03223], [-118.69721, 34.03217], [-118.69697, 34.03227], [-118.69681, 34.03228], [-118.69627, 34.0325], [-118.69582, 34.03263], [-118.69571, 34.03238], [-118.69614, 34.03228], [-118.69686, 34.03216], [-118.69835, 34.0316], [-118.69939, 34.03133], [-118.69992, 34.0311], [-118.70058, 34.03087], [-118.70138, 34.03063], [-118.70161, 34.0306], [-118.70178, 34.03062], [-118.70228, 34.03055], [-118.70288, 34.03032], [-118.70426, 34.03001], [-118.70525, 34.02965], [-118.70588, 34.0295], [-118.70651, 34.02923], [-118.70661, 34.02967]]]} | Open Access 1 | 5475 | Amarillo Beach | 15438 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.778 | Amarillo Beach | 0 | Local Park 2 | 4 | |
6848 | 6848 | 6847 | {"type": "Polygon", "coordinates": [[[-118.69582, 34.03263], [-118.69528, 34.03266], [-118.69505, 34.03271], [-118.6947, 34.03275], [-118.69402, 34.03276], [-118.69361, 34.03274], [-118.69304, 34.03271], [-118.69302, 34.03265], [-118.69217, 34.03259], [-118.69139, 34.03251], [-118.69089, 34.03241], [-118.69007, 34.0323], [-118.68928, 34.03212], [-118.68611, 34.03148], [-118.68533, 34.03129], [-118.68403, 34.03101], [-118.68372, 34.03091], [-118.68287, 34.03084], [-118.68266, 34.03086], [-118.68266, 34.03076], [-118.68257, 34.03045], [-118.68313, 34.03031], [-118.68348, 34.03033], [-118.68369, 34.0304], [-118.6849, 34.03055], [-118.68539, 34.03067], [-118.68642, 34.03102], [-118.68665, 34.03113], [-118.68749, 34.03137], [-118.68918, 34.03178], [-118.69, 34.03201], [-118.6913, 34.03228], [-118.69179, 34.03235], [-118.6925, 34.03243], [-118.69339, 34.03249], [-118.69571, 34.03238], [-118.69582, 34.03263]]]} | Open Access 1 | 5476 | Malibu Beach | 21699 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://file.lacounty.gov/dbh/cms1_151453.jpg | Los Angeles 6 | 12.353 | Malibu Beach | 0 | Local Park 2 | 4 |
6849 | 6849 | 6848 | {"type": "MultiPolygon", "coordinates": [[[[-118.75347, 34.03026], [-118.75273, 34.03045], [-118.7523, 34.02969], [-118.75136, 34.03005], [-118.75093, 34.03031], [-118.75043, 34.03051], [-118.7501, 34.03072], [-118.75021, 34.03095], [-118.74969, 34.03114], [-118.74905, 34.03133], [-118.74902, 34.03128], [-118.74828, 34.03146], [-118.74786, 34.0316], [-118.74748, 34.03179], [-118.7454, 34.03237], [-118.74528, 34.03208], [-118.74621, 34.03183], [-118.74743, 34.0316], [-118.74838, 34.03126], [-118.74871, 34.03119], [-118.74894, 34.03111], [-118.74962, 34.03078], [-118.75005, 34.03061], [-118.75042, 34.03034], [-118.75081, 34.03016], [-118.75116, 34.02994], [-118.75137, 34.02984], [-118.75224, 34.02955], [-118.75259, 34.02936], [-118.75276, 34.02925], [-118.75347, 34.03026]]], [[[-118.74516, 34.03243], [-118.74451, 34.03256], [-118.7437, 34.03276], [-118.74364, 34.03247], [-118.74326, 34.03252], [-118.74258, 34.03265], [-118.74255, 34.03267], [-118.74252, 34.03255], [-118.74363, 34.03237], [-118.74383, 34.03239], [-118.74398, 34.03236], [-118.74411, 34.03236], [-118.74439, 34.03233], [-118.74456, 34.03227], [-118.74478, 34.03225], [-118.74489, 34.03221], [-118.74505, 34.03211], [-118.74516, 34.03243]]]]} | Open Access 1 | 5477 | Dan Blocker Beach | 29044 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://beaches.lacounty.gov/wps/portal/dbh/home/detail/?current=true&urile=wcm:path:/dbh+content/dbh+site/home/home+detail/dan+blocker+beach+detail | Los Angeles 6 | 7.498 | Dan Blocker Beach | 0 | Local Park 2 | 4 |
6850 | 6850 | 6849 | {"type": "Polygon", "coordinates": [[[-121.6295, 36.67854], [-121.62937, 36.67851], [-121.62925, 36.6784], [-121.62832, 36.67814], [-121.62813, 36.67793], [-121.6274, 36.67797], [-121.62741, 36.67795], [-121.6281, 36.6779], [-121.628, 36.67779], [-121.62827, 36.67726], [-121.62832, 36.67693], [-121.62815, 36.67652], [-121.62822, 36.67652], [-121.62839, 36.67693], [-121.62834, 36.67727], [-121.62868, 36.67723], [-121.62893, 36.67724], [-121.62893, 36.67726], [-121.62872, 36.67727], [-121.62881, 36.67758], [-121.62878, 36.67759], [-121.62867, 36.67726], [-121.62833, 36.6773], [-121.62809, 36.67778], [-121.62837, 36.67809], [-121.62932, 36.67836], [-121.6295, 36.67854]]]} | Open Access 1 | 5501 | Cesar Chavez Park Access | 17101 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.594 | Cesar Chavez Park Access | 0 | Local Recreation Area 3 | 4 | |
6851 | 6851 | 6850 | {"type": "Polygon", "coordinates": [[[-122.40576, 37.63377], [-122.40541, 37.63374], [-122.40526, 37.63285], [-122.40564, 37.63282], [-122.40576, 37.63377]]]} | Open Access 1 | 14392 | 7th Avenue and Walnut Park | 15213 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.806 | 7th Avenue and Walnut Park | 1940 | Local Park 2 | 4 | |
6852 | 6852 | 6851 | {"type": "Polygon", "coordinates": [[[-118.78814, 34.01865], [-118.7881, 34.01912], [-118.78785, 34.01951], [-118.78753, 34.01984], [-118.78591, 34.02079], [-118.78483, 34.02128], [-118.78461, 34.02141], [-118.78379, 34.02177], [-118.78296, 34.02206], [-118.78252, 34.02224], [-118.7821, 34.02236], [-118.78206, 34.02231], [-118.78188, 34.02237], [-118.78182, 34.02243], [-118.78146, 34.02251], [-118.78102, 34.02265], [-118.7807, 34.02267], [-118.77956, 34.02287], [-118.77921, 34.02296], [-118.77874, 34.02305], [-118.77808, 34.0231], [-118.77791, 34.02314], [-118.77752, 34.02319], [-118.77673, 34.02342], [-118.77616, 34.02353], [-118.77593, 34.02364], [-118.77481, 34.02384], [-118.77368, 34.02413], [-118.77248, 34.02437], [-118.77115, 34.02452], [-118.77058, 34.02462], [-118.77031, 34.02457], [-118.76986, 34.02458], [-118.76947, 34.02469], [-118.76932, 34.02479], [-118.76842, 34.02498], [-118.76834, 34.02478], [-118.76859, 34.02479], [-118.76883, 34.02473], [-118.76915, 34.02468], [-118.76961, 34.02456], [-118.76982, 34.02448], [-118.77072, 34.02438], [-118.77175, 34.02418], [-118.77267, 34.02409], [-118.77303, 34.02395], [-118.77336, 34.02393], [-118.77428, 34.02373], [-118.77462, 34.02364], [-118.77484, 34.02355], [-118.77549, 34.02337], [-118.776, 34.02327], [-118.77624, 34.02315], [-118.77663, 34.0231], [-118.77688, 34.02312], [-118.77714, 34.02309], [-118.77772, 34.02293], [-118.77799, 34.02289], [-118.77833, 34.02289], [-118.77869, 34.02284], [-118.77917, 34.02274], [-118.77965, 34.02263], [-118.7799, 34.02255], [-118.78021, 34.02252], [-118.78076, 34.02239], [-118.78149, 34.0223], [-118.78173, 34.02224], [-118.78193, 34.02214], [-118.78204, 34.02211], [-118.78238, 34.02198], [-118.78266, 34.0219], [-118.78271, 34.02185], [-118.78317, 34.02177], [-118.78364, 34.02162], [-118.78375, 34.02155], [-118.78394, 34.02146], [-118.78403, 34.02145], [-118.78425, 34.02134], [-118.78432, 34.02128], [-118.78456, 34.0212], [-118.78487, 34.02104], [-118.7859, 34.02061], [-118.78626, 34.02029], [-118.78585, 34.01991], [-118.78593, 34.01982], [-118.78616, 34.02004], [-118.78614, 34.02008], [-118.78631, 34.02023], [-118.78671, 34.01992], [-118.78709, 34.01966], [-118.78719, 34.01957], [-118.78733, 34.01936], [-118.78756, 34.01913], [-118.78775, 34.01869], [-118.7878, 34.01825], [-118.78814, 34.01865]]]} | Open Access 1 | 5479 | Escondido Beach | 18702 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 13.657 | Escondido Beach | 0 | Local Park 2 | 4 | |
6853 | 6853 | 6852 | {"type": "Polygon", "coordinates": [[[-122.44843, 37.73378], [-122.44838, 37.73378], [-122.44838, 37.73391], [-122.44828, 37.73392], [-122.44828, 37.73401], [-122.44811, 37.73401], [-122.44809, 37.73391], [-122.44667, 37.73395], [-122.44652, 37.73385], [-122.44657, 37.73374], [-122.44656, 37.73317], [-122.4467, 37.73317], [-122.44671, 37.73345], [-122.44696, 37.73345], [-122.44833, 37.73344], [-122.44834, 37.73317], [-122.44842, 37.73317], [-122.44843, 37.73378]]]} | Open Access 1 | 5480 | Sunnyside Playground | 26011 | 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 Francisco 13 | 2.372 | Sunnyside Playground | 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]);