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 7,433
- Recreation/Parks District 930
- State Agency 921
- County Agency 896
- Non Profit - Land Trust 441
- Federal Agency 385
- Open Space District 351
- County Agency - Parks 190
- Water District 176
- Home Owners Association 163
- Community Services District 162
- Non Profit - Conservation 123
- Flood District 87
- Irrigation District 35
- Non Profit - Other 33
- School District 33
- Cemetery District 31
- Port/Harbor District 24
- County Agency - Other 23
- Special District - Other 14
- Commercial 11
- Joint Powers Authority 7
- Sanitation District 6
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 364
- California Department of Fish and Wildlife 356
- Los Angeles, City of 346
- California Department of Parks and Recreation 319
- Mountains Recreation and Conservation Authority 282
- Sacramento, City of 181
- San Jose, City of 169
- San Francisco, City and County of 152
- East Bay Regional Park District 145
- Los Angeles, County of 124
- Ventura, City of 123
- Long Beach, City of 113
- Roseville, City of 105
- San Diego, County of 94
- Santa Barbara, County of 90
- Oakland, City of 90
- Consumnes Community Services District 86
- United States Bureau of Land Management 84
- United States Forest Service 81
- Napa, City of 77
- United States Fish and Wildlife Service 72
- California State Lands Commission 72
- Orange, County of 72
- United States National Park Service 69
- Hayward Area Recreation and Park District 67
- Irvine, City of 66
- Tracy, City of 59
- Davis, City of 58
- Poway, City of 56
- Valley-Wide Recreation and Park District 56
- …
DES_TP >30
- Local Park 6,406
- Local Recreation Area 1,621
- Local Other or Unknown 1,026
- Private Conservation 469
- Local Conservation Area 391
- State Conservation Area 331
- Private Recreation or Education 206
- State Park 179
- State Resource Management Area 119
- State Recreation Area 114
- National Forest 71
- National Wildlife Refuge 66
- Local Historic or Cultural Area 61
- State Historic or Cultural Area 57
- State Other or Unknown 50
- Recreation Management Area 49
- Private Other or Unknown 45
- National Public Lands 43
- National Monument or Landmark 34
- National Recreation Area 32
- National Park 22
- Local Resource Management Area 16
- Federal Other or Unknown 16
- Resource Management Area 15
- Conservation Area 12
- Private Agricultural 10
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 4
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 10,499
- Restricted Access 952
- No Public Access 759
- Unknown Access 298
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4561 | 4561 | 4560 | {"type": "Polygon", "coordinates": [[[-121.68777, 36.44521], [-121.68564, 36.44803], [-121.68544, 36.44783], [-121.68401, 36.44774], [-121.68569, 36.44484], [-121.68595, 36.44475], [-121.68612, 36.44467], [-121.68628, 36.44455], [-121.68641, 36.44439], [-121.68648, 36.44425], [-121.68652, 36.44411], [-121.68653, 36.44396], [-121.68651, 36.44383], [-121.68652, 36.44381], [-121.68655, 36.4438], [-121.68658, 36.44382], [-121.68665, 36.44396], [-121.68679, 36.44411], [-121.68691, 36.4442], [-121.68711, 36.44428], [-121.68715, 36.44432], [-121.68717, 36.44437], [-121.68713, 36.44456], [-121.68714, 36.4447], [-121.68719, 36.44484], [-121.68728, 36.44497], [-121.6874, 36.44507], [-121.68751, 36.44513], [-121.68777, 36.44521]]]} | Open Access 1 | 35187 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 16.412 | 0 | State Other or Unknown 104 | 4 | |||
4562 | 4562 | 4561 | {"type": "Polygon", "coordinates": [[[-121.79416, 36.26266], [-121.79365, 36.26267], [-121.79215, 36.26261], [-121.79215, 36.2623], [-121.79397, 36.26233], [-121.79416, 36.26266]]]} | Unknown Access 4 | 35188 | Unnamed site - Save the Redwoods League | 28667 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/ | Monterey 14 | 1.537 | 0 | Private Other or Unknown 399 | 4 | |
4563 | 4563 | 4562 | {"type": "Polygon", "coordinates": [[[-120.41098, 34.87234], [-120.41098, 34.87337], [-120.41065, 34.87339], [-120.4103, 34.87346], [-120.41027, 34.87345], [-120.41017, 34.87328], [-120.41001, 34.87306], [-120.40976, 34.87284], [-120.40967, 34.87273], [-120.40957, 34.87255], [-120.40952, 34.87236], [-120.41098, 34.87234]]]} | No Public Access 3 | 35192 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28664 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 3.02 | 0 | Local Other or Unknown 14 | 4 | ||
4564 | 4564 | 4563 | {"type": "MultiPolygon", "coordinates": [[[[-116.11039, 33.44247], [-116.10826, 33.44247], [-116.10825, 33.44073], [-116.11038, 33.44072], [-116.11039, 33.44247]]], [[[-116.10935, 33.44611], [-116.10828, 33.44612], [-116.10827, 33.44431], [-116.10934, 33.4443], [-116.10935, 33.44611]]], [[[-115.74733, 33.43453], [-115.73867, 33.43457], [-115.73865, 33.42729], [-115.74731, 33.42724], [-115.74733, 33.43453]]], [[[-115.78294, 33.4371], [-115.77836, 33.43734], [-115.77816, 33.43392], [-115.78267, 33.43375], [-115.78294, 33.4371]]], [[[-116.13863, 33.45518], [-116.1343, 33.45522], [-116.13423, 33.45164], [-116.13531, 33.45163], [-116.13524, 33.44803], [-116.13848, 33.44804], [-116.13863, 33.45518]]], [[[-116.13321, 33.45523], [-116.12992, 33.45525], [-116.12992, 33.45165], [-116.13316, 33.45165], [-116.13321, 33.45523]]], [[[-116.11248, 33.44793], [-116.11247, 33.45514], [-116.11155, 33.45514], [-116.11151, 33.44793], [-116.11248, 33.44793]]], [[[-115.75601, 33.45632], [-115.74304, 33.4564], [-115.74303, 33.45276], [-115.73437, 33.4528], [-115.73436, 33.44916], [-115.73003, 33.44918], [-115.73002, 33.4419], [-115.73868, 33.44186], [-115.7387, 33.44914], [-115.756, 33.44904], [-115.75601, 33.45632]]], [[[-115.78263, 33.48481], [-115.7826, 33.48581], [-115.77976, 33.48731], [-115.77978, 33.4849], [-115.78263, 33.48481]]], [[[-115.77365, 33.4851], [-115.77357, 33.49049], [-115.76899, 33.49285], [-115.7687, 33.49299], [-115.76839, 33.49312], [-115.76778, 33.49334], [-115.7661, 33.49382], [-115.76467, 33.48945], [-115.76466, 33.48539], [-115.76242, 33.4854], [-115.7588, 33.48059], [-115.75845, 33.48014], [-115.75772, 33.47925], [-115.75695, 33.47839], [-115.75614, 33.47755], [-115.75531, 33.47673], [-115.74902, 33.47093], [-115.76465, 33.47082], [-115.76467, 33.48538], [-115.77365, 33.4851]]], [[[-115.77791, 33.49623], [-115.77784, 33.49998], [-115.76744, 33.49995], [-115.76742, 33.49922], [-115.76738, 33.4987], [-115.76732, 33.49818], [-115.76719, 33.4974], [-115.76707, 33.49689], [-115.76687, 33.49616], [-115.76628, 33.49435], [-115.76801, 33.49385], [-115.76867, 33.49362], [-115.76932, 33.49333], [-115.77079, 33.49257], [-115.77355, 33.49253], [-115.7735, 33.49625], [-115.77791, 33.49623]]], [[[-115.79094, 33.49983], [-115.79085, 33.51014], [-115.78868, 33.51019], [-115.78868, 33.50984], [-115.78759, 33.50984], [-115.7876, 33.50805], [-115.78869, 33.50803], [-115.78876, 33.49988], [-115.79094, 33.49983]]], [[[-115.7844, 33.49996], [-115.78431, 33.51029], [-115.78211, 33.51035], [-115.78223, 33.5], [-115.7844, 33.49996]]], [[[-116.20263, 33.53223], [-116.1984, 33.53224], [-116.1984, 33.53133], [-116.20262, 33.53132], [-116.20263, 33.53223]]], [[[-116.20483, 33.53673], [-116.20483, 33.53763], [-116.20267, 33.53763], [-116.20266, 33.53852], [-116.1983, 33.53852], [-116.1983, 33.53764], [-116.20158, 33.53763], [-116.20158, 33.53674], [-116.20483, 33.53673]]], [[[-115.75192, 33.531], [-115.74761, 33.53102], [-115.7476, 33.52921], [-115.75191, 33.52919], [-115.75192, 33.531]]], [[[-115.87997, 33.55444], [-115.87898, 33.55447], [-115.87892, 33.55083], [-115.87992, 33.5508], [-115.87997, 33.55444]]], [[[-115.93063, 33.56179], [-115.92202, 33.56176], [-115.92175, 33.55441], [-115.93043, 33.55447], [-115.93052, 33.55812], [-115.93063, 33.56179]]], [[[-116.22972, 33.57756], [-116.2248, 33.57751], [-116.22482, 33.57648], [-116.22436, 33.57648], [-116.22435, 33.57461], [-116.22436, 33.5746], [-116.22435, 33.5737], [-116.22718, 33.57368], [-116.22816, 33.57512], [-116.22904, 33.57647], [-116.22945, 33.57706], [-116.2296, 33.57731], [-116.2297, 33.57749], [-116.22972, 33.57756]]], [[[-116.2709, 33.59277], [-116.26982, 33.59276], [-116.26981, 33.59095], [-116.2709, 33.59095], [-116.2709, 33.59277]]], [[[-116.06075, 33.67141], [-116.05857, 33.67141], [-116.05857, 33.66959], [-116.06075, 33.6696], [-116.06075, 33.67141]]], [[[-116.05639, 33.6714], [-116.05422, 33.6714], [-116.05421, 33.66868], [-116.05639, 33.66868], [-116.05639, 33.6714]]], [[[-116.05203, 33.66777], [-116.04768, 33.66776], [-116.04768, 33.67139], [-116.04332, 33.67138], [-116.04332, 33.66411], [-116.05203, 33.66413], [-116.05203, 33.66777]]], [[[-116.05642, 33.68943], [-116.05641, 33.69305], [-116.05343, 33.69305], [-116.05175, 33.69222], [-116.05112, 33.69193], [-116.05062, 33.69172], [-116.0501, 33.69153], [-116.04957, 33.69136], [-116.04904, 33.69121], [-116.04633, 33.69], [-116.04367, 33.68981], [-116.04332, 33.68974], [-116.04332, 33.68581], [-116.05202, 33.68582], [-116.05202, 33.68942], [-116.05642, 33.68943]]], [[[-116.03034, 33.70947], [-116.03034, 33.71127], [-116.02818, 33.71128], [-116.02819, 33.70946], [-116.03034, 33.70947]]], [[[-116.06078, 33.7248], [-116.06078, 33.72571], [-116.05205, 33.72574], [-116.05206, 33.72936], [-116.06078, 33.72934], [-116.06077, 33.74387], [-116.04407, 33.7439], [-116.04333, 33.74303], [-116.04333, 33.72212], [-116.04551, 33.72211], [-116.04552, 33.72393], [-116.04769, 33.72392], [-116.04769, 33.72211], [-116.05205, 33.7221], [-116.05206, 33.72482], [-116.06078, 33.7248]]], [[[-116.07824, 33.75837], [-116.07824, 33.76202], [-116.07387, 33.76202], [-116.07387, 33.75838], [-116.07824, 33.75837]]], [[[-116.10752, 33.76574], [-116.10752, 33.76938], [-116.10316, 33.76936], [-116.10317, 33.76571], [-116.10752, 33.76574]]], [[[-116.09195, 33.77659], [-116.09194, 33.78748], [-116.08792, 33.78748], [-116.07458, 33.77618], [-116.07458, 33.77336], [-116.07503, 33.77296], [-116.07894, 33.77296], [-116.07893, 33.77659], [-116.08543, 33.77659], [-116.08545, 33.77296], [-116.08761, 33.77296], [-116.08761, 33.77659], [-116.09195, 33.77659]]], [[[-116.24856, 33.79477], [-116.24856, 33.80022], [-116.23116, 33.80026], [-116.23115, 33.78759], [-116.23986, 33.78758], [-116.23987, 33.79477], [-116.24856, 33.79477]]], [[[-116.18621, 33.80619], [-116.1862, 33.8077], [-116.1823, 33.80769], [-116.1823, 33.80617], [-116.18621, 33.80619]]], [[[-116.14848, 33.80578], [-116.1463, 33.80577], [-116.14629, 33.80667], [-116.14411, 33.80666], [-116.1441, 33.80214], [-116.14848, 33.80216], [-116.14848, 33.80578]]], [[[-116.26601, 33.81656], [-116.24855, 33.8166], [-116.24856, 33.80209], [-116.26578, 33.80204], [-116.26601, 33.81656]]], [[[-116.16594, 33.81671], [-116.16594, 33.82032], [-116.1616, 33.82031], [-116.1616, 33.8167], [-116.16594, 33.81671]]], [[[-116.17027, 33.82216], [-116.17027, 33.82216], [-116.16661, 33.82215], [-116.16896, 33.82033], [-116.17026, 33.82033], [-116.17027, 33.82216]]], [[[-116.15365, 33.82717], [-116.15315, 33.82706], [-116.15301, 33.82705], [-116.15285, 33.82707], [-116.15272, 33.82711], [-116.1526, 33.82717], [-116.1525, 33.82724], [-116.15237, 33.82739], [-116.15216, 33.82754], [-116.14412, 33.82749], [-116.14412, 33.81663], [-116.15363, 33.81667], [-116.15365, 33.82717]]], [[[-116.19631, 33.83847], [-116.17904, 33.83844], [-116.17903, 33.8312], [-116.19631, 33.83122], [-116.19631, 33.83847]], [[-116.19039, 33.83719], [-116.19039, 33.83737], [-116.19093, 33.83737], [-116.19092, 33.83719], [-116.19039, 33.83719]]], [[[-116.20933, 33.8666], [-116.20505, 33.86442], [-116.20505, 33.86408], [-116.20438, 33.86408], [-116.19733, 33.86046], [-116.20511, 33.86045], [-116.20932, 33.86046], [-116.20933, 33.8666]]], [[[-116.3014, 33.88038], [-116.30139, 33.88401], [-116.29646, 33.884], [-116.29645, 33.88219], [-116.29537, 33.88218], [-116.29537, 33.884], [-116.29428, 33.884], [-116.29429, 33.88581], [-116.2932, 33.88581], [-116.29319, 33.88399], [-116.29211, 33.884], [-116.29211, 33.88762], [-116.28776, 33.88761], [-116.28776, 33.8858], [-116.28668, 33.88579], [-116.28668, 33.88761], [-116.28342, 33.8876], [-116.28341, 33.87854], [-116.2834, 33.87853], [-116.28339, 33.8749], [-116.29016, 33.87493], [-116.29101, 33.87491], [-116.29535, 33.87494], [-116.29537, 33.87856], [-116.29645, 33.87855], [-116.29644, 33.87494], [-116.29753, 33.87494], [-116.29753, 33.87675], [-116.29971, 33.87676], [-116.29971, 33.88037], [-116.3014, 33.88038]], [[-116.28666, 33.88579], [-116.28667, 33.88398], [-116.2845, 33.88398], [-116.2845, 33.88578], [-116.28666, 33.88579]], [[-116.28557, 33.88216], [-116.28558, 33.88035], [-116.28449, 33.88035], [-116.2845, 33.88216], [-116.28557, 33.88216]], [[-116.29427, 33.88218], [-116.29428, 33.88217], [-116.29427, 33.87856], [-116.29319, 33.87855], [-116.29319, 33.88036], [-116.2921, 33.88037], [-116.2921, 33.88217], [-116.29427, 33.88218]], [[-116.28667, 33.8775], [-116.28665, 33.87673], [-116.28557, 33.87673], [-116.28558, 33.87853], [-116.28666, 33.87853], [-116.28667, 33.8775]], [[-116.2921, 33.87675], [-116.29101, 33.87673], [-116.29102, 33.87855], [-116.2921, 33.87854], [-116.2921, 33.87675]], [[-116.29209, 33.88036], [-116.2921, 33.87901], [-116.29102, 33.879], [-116.29102, 33.88036], [-116.29209, 33.88036]]], [[[-116.41468, 33.89668], [-116.41462, 33.8994], [-116.41247, 33.89939], [-116.41248, 33.89668], [-116.41468, 33.89668]]], [[[-116.41457, 33.90121], [-116.41455, 33.90212], [-116.41036, 33.90211], [-116.41035, 33.90029], [-116.41247, 33.9003], [-116.41247, 33.9012], [-116.41457, 33.90121]]], [[[-116.6389, 33.91082], [-116.63675, 33.91082], [-116.63672, 33.90839], [-116.63888, 33.90828], [-116.6389, 33.91082]]], [[[-116.64988, 33.91441], [-116.64662, 33.91442], [-116.64663, 33.91533], [-116.64555, 33.91534], [-116.64546, 33.91082], [-116.64983, 33.91082], [-116.64988, 33.91441]]], [[[-116.64447, 33.91579], [-116.64338, 33.9158], [-116.64337, 33.91534], [-116.64446, 33.91534], [-116.64447, 33.91579]]], [[[-116.64777, 33.91807], [-116.64342, 33.91808], [-116.64341, 33.91744], [-116.64558, 33.91731], [-116.64666, 33.91731], [-116.64667, 33.91726], [-116.64776, 33.91726], [-116.64777, 33.91807]]], [[[-116.32979, 33.90377], [-116.32899, 33.90569], [-116.32678, 33.90997], [-116.32616, 33.91101], [-116.31879, 33.91097], [-116.31875, 33.91098], [-116.31875, 33.91269], [-116.31002, 33.90844], [-116.30136, 33.90426], [-116.30136, 33.90383], [-116.30047, 33.90383], [-116.28342, 33.89562], [-116.28342, 33.88941], [-116.30138, 33.88945], [-116.30137, 33.90357], [-116.31877, 33.90373], [-116.31879, 33.90013], [-116.32317, 33.90015], [-116.32316, 33.90375], [-116.32979, 33.90377]], [[-116.31877, 33.90612], [-116.31879, 33.90612], [-116.31881, 33.904], [-116.31879, 33.90391], [-116.31878, 33.90392], [-116.31877, 33.90612]]], [[[-116.37098, 33.9096], [-116.37097, 33.91099], [-116.3623, 33.91101], [-116.36227, 33.91826], [-116.35574, 33.91828], [-116.35577, 33.91104], [-116.35359, 33.91104], [-116.35362, 33.90379], [-116.36012, 33.90378], [-116.37098, 33.9096]]], [[[-116.71097, 33.9382], [-116.70987, 33.93821], [-116.70986, 33.9345], [-116.71095, 33.93449], [-116.71097, 33.9382]]], [[[-116.64172, 33.9475], [-116.64148, 33.9475], [-116.64137, 33.94735], [-116.64162, 33.94735], [-116.64172, 33.9475]]], [[[-116.44054, 33.96104], [-116.42877, 33.96124], [-116.42304, 33.95752], [-116.42302, 33.94686], [-116.44043, 33.94685], [-116.44054, 33.96104]]], [[[-116.58264, 34.00542], [-116.58046, 34.00555], [-116.58041, 34.00236], [-116.58256, 34.00224], [-116.58264, 34.00542]]]]} | Open Access 1 | 35203 | Unnamed site - Friends of the Desert Mountains | 33250 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 7591.856 | 0 | Private Other or Unknown 399 | 4 | ||
4565 | 4565 | 4564 | {"type": "Polygon", "coordinates": [[[-115.25908, 33.44142], [-115.25691, 33.44141], [-115.25692, 33.44321], [-115.24776, 33.44322], [-115.24775, 33.43597], [-115.2538, 33.43597], [-115.25908, 33.44142]]]} | Restricted Access 2 | 35204 | Unnamed site - Riverside Land Conservancy | 28657 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 162.476 | 0 | Private Other or Unknown 399 | 4 | ||
4566 | 4566 | 4565 | {"type": "Polygon", "coordinates": [[[-115.25053, 35.12434], [-115.25052, 35.12796], [-115.24942, 35.12797], [-115.24942, 35.12434], [-115.25053, 35.12434]]]} | No Public Access 3 | 35206 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 10.052 | 0 | Private Other or Unknown 399 | 4 | ||
4567 | 4567 | 4566 | {"type": "Polygon", "coordinates": [[[-119.71084, 34.46312], [-119.71071, 34.46336], [-119.70994, 34.46337], [-119.70995, 34.46314], [-119.71084, 34.46312]]]} | Open Access 1 | 35211 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.489 | 0 | Local Other or Unknown 14 | 4 | ||
4568 | 4568 | 4567 | {"type": "Polygon", "coordinates": [[[-119.62321, 34.44984], [-119.62318, 34.45014], [-119.62286, 34.45046], [-119.62231, 34.45075], [-119.62214, 34.45112], [-119.62197, 34.45112], [-119.62196, 34.45078], [-119.6221, 34.45066], [-119.62217, 34.45053], [-119.62231, 34.44987], [-119.62232, 34.44975], [-119.6223, 34.44957], [-119.62216, 34.44918], [-119.62211, 34.44896], [-119.6221, 34.44883], [-119.62209, 34.44827], [-119.62239, 34.44829], [-119.62238, 34.44846], [-119.62223, 34.44862], [-119.62265, 34.44905], [-119.62283, 34.44907], [-119.62296, 34.44939], [-119.62321, 34.44984]]]} | Open Access 1 | 35212 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 4.011 | 0 | Local Other or Unknown 14 | 4 | ||
4569 | 4569 | 4568 | {"type": "Polygon", "coordinates": [[[-121.90092, 36.38111], [-121.90068, 36.38151], [-121.89991, 36.38153], [-121.90026, 36.38083], [-121.90092, 36.38111]]]} | Open Access 1 | 35213 | Unnamed site - Monterey, County of | 28641 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 1.072 | 0 | Local Other or Unknown 14 | 4 | ||
4570 | 4570 | 4569 | {"type": "Polygon", "coordinates": [[[-121.79587, 36.24479], [-121.79216, 36.24477], [-121.79223, 36.24187], [-121.79275, 36.24205], [-121.79412, 36.24162], [-121.79434, 36.24172], [-121.79457, 36.24166], [-121.79584, 36.24162], [-121.79587, 36.24479]]]} | Open Access 1 | 35214 | Unnamed site - Monterey, County of | 28641 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 27.202 | 0 | Local Other or Unknown 14 | 4 | ||
4571 | 4571 | 4570 | {"type": "Polygon", "coordinates": [[[-121.75824, 36.76732], [-121.75755, 36.76792], [-121.75679, 36.76735], [-121.75748, 36.76675], [-121.75824, 36.76732]]]} | Open Access 1 | 35215 | Unknown park - Monterey, County of | 28642 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 2.087 | 0 | Local Other or Unknown 14 | 4 | ||
4572 | 4572 | 4571 | {"type": "Polygon", "coordinates": [[[-121.68837, 36.61717], [-121.68833, 36.6172], [-121.68814, 36.61791], [-121.68767, 36.61774], [-121.68798, 36.6174], [-121.68817, 36.6171], [-121.68837, 36.61717]]]} | Open Access 1 | 35222 | Unnamed site - Monterey, County of | 28641 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 0.614 | 0 | Local Other or Unknown 14 | 4 | ||
4573 | 4573 | 4572 | {"type": "Polygon", "coordinates": [[[-121.68761, 36.61869], [-121.68717, 36.61899], [-121.68712, 36.61905], [-121.687, 36.61903], [-121.68706, 36.61882], [-121.68721, 36.61854], [-121.68761, 36.61869]]]} | Open Access 1 | 35223 | Unnamed site - Monterey, County of | 28641 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 0.347 | 0 | Local Other or Unknown 14 | 4 | ||
4574 | 4574 | 4573 | {"type": "Polygon", "coordinates": [[[-120.41847, 34.87892], [-120.41847, 34.87914], [-120.41845, 34.87917], [-120.41794, 34.87923], [-120.41794, 34.87885], [-120.418, 34.87884], [-120.41807, 34.8788], [-120.41847, 34.87892]]]} | No Public Access 3 | 35227 | Unnamed site - Santa Barbara, County of | 28691 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.465 | 0 | Local Other or Unknown 14 | 4 | ||
4575 | 4575 | 4574 | {"type": "Polygon", "coordinates": [[[-120.41196, 34.87233], [-120.40988, 34.87235], [-120.40988, 34.87167], [-120.41063, 34.87167], [-120.41063, 34.87165], [-120.41048, 34.87139], [-120.41055, 34.87137], [-120.41071, 34.87164], [-120.41102, 34.87133], [-120.4118, 34.87166], [-120.41179, 34.87207], [-120.41196, 34.87233]]]} | Open Access 1 | 35235 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.807 | 0 | Local Other or Unknown 14 | 4 | ||
4576 | 4576 | 4575 | {"type": "Polygon", "coordinates": [[[-121.90098, 36.38732], [-121.9, 36.38737], [-121.8999, 36.38682], [-121.89994, 36.38646], [-121.90076, 36.38641], [-121.90098, 36.38732]]]} | Open Access 1 | 35237 | Unnamed site - Monterey, County of | 28641 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 2.104 | 0 | Local Other or Unknown 14 | 4 | ||
4577 | 4577 | 4576 | {"type": "Polygon", "coordinates": [[[-121.85444, 36.9225], [-121.85412, 36.92319], [-121.85376, 36.92307], [-121.85374, 36.9231], [-121.85269, 36.92275], [-121.85271, 36.92271], [-121.85333, 36.92292], [-121.85334, 36.92288], [-121.85364, 36.92288], [-121.85392, 36.92281], [-121.85385, 36.92265], [-121.85379, 36.92263], [-121.85393, 36.92259], [-121.8539, 36.92263], [-121.85399, 36.92279], [-121.85421, 36.92268], [-121.85444, 36.9225]]]} | Open Access 1 | 35238 | Unknown park - Santa Cruz, County of | 28665 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.741 | 0 | Local Other or Unknown 14 | 4 | ||
4578 | 4578 | 4577 | {"type": "MultiPolygon", "coordinates": [[[[-120.44975, 34.81145], [-120.44876, 34.81144], [-120.44421, 34.8026], [-120.44368, 34.79916], [-120.44429, 34.80052], [-120.44421, 34.80147], [-120.44538, 34.80388], [-120.44649, 34.80641], [-120.44778, 34.80894], [-120.449, 34.81041], [-120.44975, 34.81145]]], [[[-120.44694, 34.81143], [-120.44555, 34.81141], [-120.44464, 34.80544], [-120.44694, 34.81143], [-120.44694, 34.81143]]]]} | Open Access 1 | 35242 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 23.418 | 0 | Local Other or Unknown 14 | 4 | ||
4579 | 4579 | 4578 | {"type": "Polygon", "coordinates": [[[-120.14651, 34.6035], [-120.14643, 34.60387], [-120.14512, 34.60449], [-120.14492, 34.60438], [-120.14466, 34.6043], [-120.14438, 34.6043], [-120.14381, 34.60437], [-120.14377, 34.60436], [-120.14373, 34.60432], [-120.14374, 34.6041], [-120.14379, 34.60395], [-120.14434, 34.60404], [-120.14512, 34.60379], [-120.14578, 34.60373], [-120.14651, 34.6035]]]} | Open Access 1 | 35310 | Unnamed site - Solvang, City of | 28670 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 3.005 | 0 | Local Other or Unknown 14 | 4 | ||
4580 | 4580 | 4579 | {"type": "Polygon", "coordinates": [[[-120.65368, 35.25981], [-120.65355, 35.25973], [-120.65336, 35.25938], [-120.65327, 35.25852], [-120.65304, 35.25837], [-120.65297, 35.25826], [-120.65294, 35.25809], [-120.653, 35.2577], [-120.65339, 35.25769], [-120.65368, 35.25981]]]} | Open Access 1 | 35313 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.637 | 0 | Local Other or Unknown 14 | 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]);