units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14,510 rows where ACCESS_TYP = 1 sorted by YR_EST
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_LEV
MNG_AG_TYP 30
- City Agency 9,925
- County Agency 1,098
- Recreation/Parks District 991
- State Agency 827
- Federal Agency 397
- Open Space District 248
- County Agency - Parks 206
- Non Profit - Land Trust 205
- Community Services District 194
- Water District 113
- Cemetery District 62
- Non Profit - Conservation 55
- Flood District 40
- Non Profit - Other 35
- Port/Harbor District 33
- County Agency - Other 20
- Irrigation District 17
- Special District - Other 15
- Sanitation District 6
- Commercial 5
- Non Profit - Cemetery District 5
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Fire District 1
- Transportation Agency 1
DES_TP >30
- Local Park 9,084
- Local Recreation Area 1,640
- Local Other or Unknown 859
- Local Conservation Area 350
- State Conservation Area 250
- Private Conservation 212
- State Park 199
- State Recreation Area 140
- Local Historic or Cultural Area 113
- National Forest 99
- State Resource Management Area 81
- National Public Lands 64
- State Historic or Cultural Area 59
- Recreation Management Area 50
- Private Recreation or Education 48
- National Recreation Area 38
- National Monument or Landmark 33
- State Other or Unknown 32
- National Wildlife Refuge 25
- National Park 22
- Resource Management Area 20
- Federal Other or Unknown 14
- Local Resource Management Area 11
- Private Other or Unknown 9
- Conservation Area 6
- Wilderness Area 6
- Area of Critical Environmental Concern 6
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- Private Agricultural 3
- …
ACCESS_TYP 1
- Open Access · 14,510 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | 11 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73762], [-120.70033, 35.73765], [-120.69995, 35.73853], [-120.69975, 35.73891], [-120.69913, 35.73992], [-120.6988, 35.73992], [-120.70087, 35.73565]]]} | Open Access 1 | 48 | Rios Caledonia Adobe | 24392 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.26 | Rios Caledonia Adobe | None 5 | |||
40 | 40 | 39 | {"type": "Polygon", "coordinates": [[[-120.6535, 35.26278], [-120.65337, 35.26287], [-120.65316, 35.26262], [-120.6533, 35.26255], [-120.6535, 35.26278]]]} | Open Access 1 | 127 | Rockview Right-of-Way | 24536 | 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 | 0.123 | Rockview Right-of-Way | None 7 | |||
72 | 72 | 71 | {"type": "Polygon", "coordinates": [[[-120.63097, 35.24673], [-120.63073, 35.24675], [-120.63063, 35.24673], [-120.63043, 35.24674], [-120.6303, 35.24677], [-120.63025, 35.24681], [-120.63016, 35.24683], [-120.63008, 35.24682], [-120.62998, 35.24677], [-120.62994, 35.2467], [-120.62993, 35.24662], [-120.63, 35.24651], [-120.63004, 35.24648], [-120.63007, 35.24644], [-120.63012, 35.24628], [-120.6301, 35.24623], [-120.63011, 35.24615], [-120.63017, 35.2461], [-120.63019, 35.24606], [-120.63018, 35.24601], [-120.63013, 35.24596], [-120.63051, 35.24609], [-120.63065, 35.24616], [-120.63074, 35.24623], [-120.63083, 35.24633], [-120.63089, 35.24643], [-120.63095, 35.2466], [-120.63097, 35.24673]]]} | Open Access 1 | 167 | Rodriguez Adobe | 24553 | 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.39 | Rodriguez Adobe | None 10 | |||
104 | 104 | 103 | {"type": "MultiPolygon", "coordinates": [[[[-117.28007, 33.05439], [-117.27998, 33.05619], [-117.27973, 33.05623], [-117.27961, 33.05627], [-117.27947, 33.05637], [-117.27933, 33.05643], [-117.27924, 33.05645], [-117.27918, 33.05644], [-117.27916, 33.05641], [-117.27907, 33.05602], [-117.279, 33.05546], [-117.279, 33.05499], [-117.27903, 33.05437], [-117.28007, 33.05439]]], [[[-117.28063, 33.05635], [-117.28056, 33.05752], [-117.28062, 33.05796], [-117.27972, 33.05795], [-117.27929, 33.05682], [-117.27923, 33.05664], [-117.27929, 33.0566], [-117.27948, 33.05654], [-117.27971, 33.0564], [-117.27986, 33.05635], [-117.28063, 33.05635]]]]} | Open Access 1 | 288 | Encinitas Ranch Community Use Site | 18665 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 9.497 | Encinitas Ranch Community Use Site | None 12 | |||
190 | 190 | 189 | {"type": "Polygon", "coordinates": [[[-119.54817, 34.40521], [-119.54802, 34.4054], [-119.54792, 34.40532], [-119.54714, 34.40436], [-119.54706, 34.40429], [-119.54684, 34.40419], [-119.54661, 34.40416], [-119.54636, 34.40425], [-119.54631, 34.40432], [-119.54628, 34.40444], [-119.5462, 34.40436], [-119.54604, 34.40426], [-119.54606, 34.40336], [-119.54817, 34.40521]]]} | Open Access 1 | 524 | Santa Claus Lane Beach | 25061 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Santa Barbara 7 | 1.665 | Santa Claus Lane Beach | None 20 | |||
192 | 192 | 191 | {"type": "Polygon", "coordinates": [[[-117.25358, 33.2577], [-117.25022, 33.25616], [-117.25015, 33.25611], [-117.25356, 33.2561], [-117.25358, 33.2577]]]} | Open Access 1 | 527 | San Luis Rey River | 24941 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 7.039 | San Luis Rey River | None 21 | |||
199 | 199 | 198 | {"type": "Polygon", "coordinates": [[[-120.16151, 34.59253], [-120.16137, 34.59261], [-120.16006, 34.59216], [-120.15908, 34.5915], [-120.15736, 34.59022], [-120.15748, 34.58949], [-120.15913, 34.59074], [-120.15995, 34.59087], [-120.16151, 34.59253]]]} | Open Access 1 | 629 | Santa Ynez River | 25146 | 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 | 8.216 | Santa Ynez River | None 22 | |||
219 | 219 | 218 | {"type": "Polygon", "coordinates": [[[-117.29114, 33.03378], [-117.29094, 33.03383], [-117.29088, 33.0337], [-117.29105, 33.03363], [-117.29114, 33.03378]]]} | Open Access 1 | 708 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.079 | Swami's Bluff Parcels | None 23 | ||
255 | 255 | 254 | {"type": "Polygon", "coordinates": [[[-117.29084, 33.0333], [-117.2907, 33.03336], [-117.29031, 33.03261], [-117.29033, 33.03255], [-117.29053, 33.03288], [-117.29071, 33.03315], [-117.29084, 33.0333]]]} | Open Access 1 | 709 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.184 | Swami's Bluff Parcels | None 27 | ||
260 | 260 | 259 | {"type": "MultiPolygon", "coordinates": [[[[-122.03147, 37.05364], [-122.03119, 37.05372], [-122.03074, 37.05397], [-122.03059, 37.05423], [-122.0306, 37.05358], [-122.03147, 37.05364]]], [[[-122.03519, 37.05382], [-122.03465, 37.05395], [-122.03443, 37.05404], [-122.03426, 37.05419], [-122.03406, 37.05445], [-122.03093, 37.05448], [-122.03136, 37.05427], [-122.0318, 37.05403], [-122.03213, 37.05418], [-122.03226, 37.05404], [-122.03245, 37.05415], [-122.03292, 37.05367], [-122.03343, 37.05332], [-122.03375, 37.05305], [-122.03394, 37.05284], [-122.03411, 37.05261], [-122.03426, 37.05236], [-122.03449, 37.05243], [-122.03454, 37.05232], [-122.03473, 37.05251], [-122.03519, 37.05382]]]]} | Open Access 1 | 876 | Skypark | 25545 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 9.029 | Skypark | None 28 | |||
272 | 272 | 271 | {"type": "Polygon", "coordinates": [[[-119.30083, 34.27437], [-119.30048, 34.27445], [-119.29837, 34.27477], [-119.29821, 34.27482], [-119.29805, 34.27491], [-119.2979, 34.27501], [-119.29779, 34.27512], [-119.29779, 34.27435], [-119.29933, 34.27392], [-119.30016, 34.27382], [-119.30083, 34.27383], [-119.30083, 34.27437]]]} | Open Access 1 | 742 | Surfer's Point | 30395 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 4.99 | Surfer's Point | None 29 | |||
284 | 284 | 283 | {"type": "Polygon", "coordinates": [[[-116.4753, 32.60867], [-116.47487, 32.60888], [-116.47435, 32.60914], [-116.47431, 32.60887], [-116.47465, 32.60861], [-116.47505, 32.60838], [-116.4753, 32.60867]]]} | Open Access 1 | 766 | Campo Stone Store | 29229 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://ohp.parks.ca.gov/ListedResources/Detail/411 | San Diego 4 | 0.82 | Campo Stone Store | None 31 | ||
309 | 309 | 308 | {"type": "MultiPolygon", "coordinates": [[[[-118.61084, 34.27479], [-118.61063, 34.27477], [-118.6103, 34.2747], [-118.61002, 34.27455], [-118.60985, 34.27432], [-118.60969, 34.27388], [-118.60882, 34.27411], [-118.60768, 34.27363], [-118.60854, 34.27246], [-118.61002, 34.27238], [-118.61055, 34.2723], [-118.61121, 34.27215], [-118.61124, 34.27217], [-118.6114, 34.27269], [-118.61141, 34.27284], [-118.6114, 34.27299], [-118.61132, 34.2732], [-118.61092, 34.27389], [-118.61081, 34.27412], [-118.61077, 34.27429], [-118.61077, 34.27446], [-118.61079, 34.27463], [-118.61084, 34.27479]]], [[[-118.61416, 34.27267], [-118.61344, 34.27333], [-118.61346, 34.27364], [-118.61289, 34.27408], [-118.61233, 34.27387], [-118.61196, 34.27395], [-118.61208, 34.27432], [-118.61183, 34.27461], [-118.61168, 34.27461], [-118.61157, 34.2747], [-118.61155, 34.27488], [-118.61138, 34.27494], [-118.61124, 34.27489], [-118.61114, 34.27493], [-118.61105, 34.27475], [-118.611, 34.27459], [-118.61098, 34.27435], [-118.61101, 34.27419], [-118.61111, 34.27396], [-118.61152, 34.27327], [-118.61158, 34.2731], [-118.61162, 34.27293], [-118.61161, 34.27269], [-118.61144, 34.27212], [-118.61146, 34.27209], [-118.61246, 34.27186], [-118.61282, 34.27184], [-118.61306, 34.27186], [-118.61321, 34.27194], [-118.61333, 34.27204], [-118.61343, 34.27216], [-118.61358, 34.27242], [-118.61368, 34.27252], [-118.61379, 34.27259], [-118.61393, 34.27264], [-118.61416, 34.27267]]]]} | Open Access 1 | 826 | Garden of the Gods | 29624 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 27.234 | Garden of the Gods | None 32 | |||
325 | 325 | 324 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.04949, 36.94929], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.04979, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | Open Access 1 | 1106 | Stockton Avenue Beach | 25857 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 0.139 | Stockton Avenue Beach | None 33 | ||||
343 | 343 | 342 | {"type": "Polygon", "coordinates": [[[-119.06923, 36.07235], [-119.06918, 36.07236], [-119.06918, 36.07248], [-119.06778, 36.07246], [-119.06781, 36.07093], [-119.06922, 36.07094], [-119.06923, 36.07235]]]} | Open Access 1 | 1167 | Burton Ballfields | 16529 | 1260 | Porterville, City of 139 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | Tulare 29 | 5.41 | Burton Ballfields | None 34 | |||
346 | 346 | 345 | {"type": "Polygon", "coordinates": [[[-117.83498, 33.59186], [-117.83357, 33.592], [-117.83332, 33.59203], [-117.83324, 33.59168], [-117.83368, 33.59129], [-117.8341, 33.59125], [-117.83427, 33.59117], [-117.83438, 33.59126], [-117.83475, 33.59141], [-117.83496, 33.59132], [-117.83498, 33.59186]]]} | Open Access 1 | 47415 | Los Trancos Canyon View Park (Upper) | 31132 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.623 | Los Trancos Canyon View Park (Upper) | None 35 | |||
369 | 369 | 368 | {"type": "Polygon", "coordinates": [[[-119.68907, 34.41202], [-119.68898, 34.41211], [-119.68591, 34.4101], [-119.68566, 34.4102], [-119.68603, 34.41089], [-119.68588, 34.41095], [-119.68479, 34.4089], [-119.68484, 34.40798], [-119.68506, 34.40798], [-119.68505, 34.40854], [-119.68573, 34.40979], [-119.68586, 34.40987], [-119.68596, 34.40982], [-119.68651, 34.41019], [-119.68643, 34.41029], [-119.68643, 34.4103], [-119.68907, 34.41202]]]} | Open Access 1 | 1083 | Stearns Wharf | 25815 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 3.868 | Stearns Wharf | None 37 | |||
374 | 374 | 373 | {"type": "Polygon", "coordinates": [[[-122.51401, 38.08952], [-122.50961, 38.09217], [-122.5071, 38.09337], [-122.50547, 38.08821], [-122.50462, 38.08689], [-122.50476, 38.08671], [-122.50434, 38.08636], [-122.50461, 38.086], [-122.50537, 38.08538], [-122.50578, 38.08514], [-122.50622, 38.08495], [-122.50736, 38.08466], [-122.50838, 38.08465], [-122.50977, 38.08483], [-122.5107, 38.08507], [-122.51158, 38.08542], [-122.51221, 38.08579], [-122.51271, 38.0862], [-122.51324, 38.08682], [-122.51374, 38.08778], [-122.51391, 38.08855], [-122.51402, 38.08937], [-122.51401, 38.08952]]]} | Open Access 1 | 1105 | North Antenna Field | 22804 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Marin 23 | 128.205 | North Antenna Field | None 38 | |||
395 | 395 | 394 | {"type": "Polygon", "coordinates": [[[-117.87117, 33.60242], [-117.87116, 33.60245], [-117.8711, 33.60256], [-117.87077, 33.60296], [-117.86932, 33.60201], [-117.86916, 33.60225], [-117.86863, 33.60202], [-117.86867, 33.60194], [-117.86798, 33.60161], [-117.86806, 33.60149], [-117.86816, 33.60138], [-117.86847, 33.60115], [-117.86847, 33.60114], [-117.86778, 33.60071], [-117.86707, 33.60032], [-117.86748, 33.5999], [-117.86751, 33.59989], [-117.86759, 33.59991], [-117.86785, 33.60009], [-117.86788, 33.60012], [-117.86788, 33.60016], [-117.86794, 33.6002], [-117.86799, 33.60018], [-117.86804, 33.6002], [-117.86887, 33.60078], [-117.869, 33.60082], [-117.86968, 33.60129], [-117.86963, 33.60134], [-117.86963, 33.60135], [-117.87103, 33.60229], [-117.87117, 33.60242]]]} | Open Access 1 | 1168 | Grant Howald Park & CYC | 19435 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 9.005 | Grant Howald Park & CYC | None 40 | |||
398 | 398 | 397 | {"type": "Polygon", "coordinates": [[[-119.01425, 36.0474], [-119.01298, 36.04739], [-119.01299, 36.04636], [-119.01422, 36.04637], [-119.01425, 36.0474]]]} | Open Access 1 | 1198 | Pioneer Ballfields | 23710 | 1260 | Porterville, City of 139 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | Tulare 29 | 3.165 | Pioneer Ballfields | None 41 |
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]);