units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
328 rows where ACCESS_TYP = 1 and COUNTY = 7
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
DES_TP >30
- Local Park 150
- Local Other or Unknown 73
- Local Recreation Area 33
- Local Historic or Cultural Area 11
- Local Conservation Area 9
- State Park 7
- Private Conservation 5
- State Historic or Cultural Area 3
- State Conservation Area 2
- National Forest 2
- Federal Other or Unknown 2
- National Public Lands 1
- None 1
- None 1
- None 1
- Recreation Management Area 1
- None 1
- State Resource Management Area 1
- Private Recreation or Education 1
- National Monument or Landmark 1
- Resource Management Area 1
- State Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- Private Other or Unknown 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 1
- Open Access · 328 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9 | 9 | 8 | {"type": "Polygon", "coordinates": [[[-119.48323, 34.37952], [-119.48284, 34.37978], [-119.48215, 34.37935], [-119.48075, 34.37775], [-119.4785, 34.37584], [-119.47796, 34.37557], [-119.47746, 34.37548], [-119.47737, 34.37524], [-119.47812, 34.37527], [-119.47861, 34.37543], [-119.47887, 34.37564], [-119.47904, 34.37573], [-119.47969, 34.37544], [-119.48031, 34.37629], [-119.48123, 34.37728], [-119.48177, 34.37797], [-119.48233, 34.37854], [-119.48323, 34.37952]]]} | Open Access 1 | 36 | Rincon Beach Park | 24367 | 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 | 11.623 | Rincon Beach Park | 0 | Local Park 2 | 4 | |
31 | 31 | 30 | {"type": "Polygon", "coordinates": [[[-120.44007, 34.65751], [-120.44003, 34.66064], [-120.4377, 34.66062], [-120.43735, 34.65839], [-120.43399, 34.65557], [-120.43409, 34.64948], [-120.43349, 34.64835], [-120.43323, 34.648], [-120.4329, 34.64769], [-120.43272, 34.64755], [-120.43252, 34.64742], [-120.43202, 34.64716], [-120.43205, 34.64698], [-120.43156, 34.64672], [-120.4313, 34.64654], [-120.43107, 34.64633], [-120.43086, 34.64611], [-120.43007, 34.64516], [-120.42988, 34.64496], [-120.42986, 34.6449], [-120.42988, 34.64483], [-120.43012, 34.64467], [-120.43121, 34.64405], [-120.43128, 34.64412], [-120.43217, 34.6436], [-120.43226, 34.6436], [-120.43589, 34.64992], [-120.4396, 34.65676], [-120.44007, 34.65751]]]} | Open Access 1 | 80 | River Park | 24416 | 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 | 123.418 | River Park | 0 | Local Park 2 | 4 | |
47 | 47 | 46 | {"type": "MultiPolygon", "coordinates": [[[[-119.70909, 34.44366], [-119.70909, 34.44415], [-119.70862, 34.44493], [-119.70858, 34.44547], [-119.70828, 34.44567], [-119.70821, 34.44594], [-119.70847, 34.44627], [-119.70848, 34.44649], [-119.70851, 34.44659], [-119.70826, 34.44655], [-119.70805, 34.44586], [-119.70711, 34.44467], [-119.70752, 34.44456], [-119.70909, 34.44366]]], [[[-119.71066, 34.44319], [-119.71065, 34.4436], [-119.71, 34.4436], [-119.70999, 34.44352], [-119.71046, 34.44304], [-119.71066, 34.44319]]]]} | Open Access 1 | 134 | Rocky Nook Park | 24543 | 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 | 6.0 | Rocky Nook Park | 0 | Local Park 2 | 4 | |
83 | 83 | 82 | {"type": "Polygon", "coordinates": [[[-120.451, 34.95142], [-120.45136, 34.95142], [-120.4514, 34.95145], [-120.45139, 34.95211], [-120.45135, 34.95213], [-120.45059, 34.95212], [-120.4506, 34.95142], [-120.451, 34.95142]]]} | Open Access 1 | 215 | Russell Park | 24739 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 1.403 | Russell Park | 0 | Local Park 2 | 4 | |
92 | 92 | 91 | {"type": "MultiPolygon", "coordinates": [[[[-120.46865, 34.63751], [-120.46863, 34.63892], [-120.46689, 34.6389], [-120.46691, 34.63749], [-120.46865, 34.63751]]], [[[-120.47057, 34.63592], [-120.47056, 34.63741], [-120.46885, 34.6374], [-120.46884, 34.63734], [-120.46691, 34.63732], [-120.46693, 34.63589], [-120.47057, 34.63592]]]]} | Open Access 1 | 238 | Ryon Park | 24763 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 19.613 | Ryon Park | 0 | Local Park 2 | 4 | |
136 | 136 | 135 | {"type": "Polygon", "coordinates": [[[-119.73666, 34.44335], [-119.73708, 34.44353], [-119.73734, 34.4436], [-119.73737, 34.44363], [-119.73737, 34.44367], [-119.73696, 34.44389], [-119.73671, 34.44407], [-119.73664, 34.44407], [-119.7366, 34.44401], [-119.73662, 34.44372], [-119.73659, 34.4434], [-119.73661, 34.44336], [-119.73666, 34.44335]]]} | Open Access 1 | 422 | San Roque Park | 24991 | 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 | 0.767 | San Roque Park | 0 | Local Park 2 | 4 | |
172 | 172 | 171 | {"type": "Polygon", "coordinates": [[[-119.7122, 34.45864], [-119.71219, 34.45865], [-119.71206, 34.45871], [-119.71176, 34.45871], [-119.71175, 34.45848], [-119.71185, 34.45854], [-119.7122, 34.45864]]]} | Open Access 1 | 462 | Santa Barbara Botanic Gardens | 25037 | 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 | 0.145 | Santa Barbara Botanic Gardens | 0 | Local Park 2 | 4 | |
175 | 175 | 174 | {"type": "Polygon", "coordinates": [[[-119.65914, 34.41998], [-119.65807, 34.4201], [-119.65671, 34.42044], [-119.65662, 34.42048], [-119.65651, 34.42056], [-119.65592, 34.42119], [-119.65575, 34.42131], [-119.65555, 34.42137], [-119.65541, 34.42139], [-119.65297, 34.42138], [-119.65294, 34.42134], [-119.65294, 34.41914], [-119.65261, 34.41913], [-119.65261, 34.41724], [-119.65352, 34.41719], [-119.65403, 34.41712], [-119.65457, 34.41717], [-119.65502, 34.41711], [-119.65526, 34.41712], [-119.65548, 34.41708], [-119.65595, 34.41711], [-119.65614, 34.41706], [-119.65649, 34.41705], [-119.65687, 34.41702], [-119.65729, 34.41703], [-119.65751, 34.41701], [-119.65793, 34.41701], [-119.65827, 34.41698], [-119.6587, 34.41702], [-119.65912, 34.41699], [-119.65914, 34.41998]]]} | Open Access 1 | 481 | Santa Barbara Cemetery | 25039 | 2140 | Santa Barbara Cemetery Association 67 | Special District 4 | Cemetery District 11 | Special District 4 | 2140 | Santa Barbara Cemetery Association 65 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 59.983 | Santa Barbara Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
180 | 180 | 179 | {"type": "Polygon", "coordinates": [[[-120.42711, 34.93148], [-120.42706, 34.93392], [-120.42702, 34.93833], [-120.42498, 34.93831], [-120.42501, 34.93448], [-120.42505, 34.93211], [-120.42507, 34.93195], [-120.42508, 34.93153], [-120.42511, 34.93149], [-120.42515, 34.93147], [-120.42711, 34.93148]]]} | Open Access 1 | 568 | Santa Maria Cemetery | 25103 | 2145 | Santa Maria Cemetery District 68 | Special District 4 | Cemetery District 11 | http://www.countyofsb.org/pwd/pwsurveyor.aspx | Special District 4 | 2145 | Santa Maria Cemetery District 66 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 35.019 | Santa Maria Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
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 | |||
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 | |||
217 | 217 | 216 | {"type": "MultiPolygon", "coordinates": [[[[-120.18693, 34.6078], [-120.18673, 34.60817], [-120.18627, 34.608], [-120.18648, 34.60763], [-120.18693, 34.6078]]], [[[-120.1886, 34.60795], [-120.18844, 34.60825], [-120.18779, 34.608], [-120.18796, 34.6077], [-120.1886, 34.60795]]]]} | Open Access 1 | 634 | Santa Ynez River Open Space | 25147 | 1036 | Buellton, City of 88 | City 2 | City Agency 2 | http://www.cityofbuellton.com/Parks&Rec/parks.asp | City 2 | 1036 | Buellton, City of 86 | City 2 | City Agency 2 | Santa Barbara 7 | 1.105 | Santa Ynez River OS | 0 | Local Recreation Area 3 | 4 | |
223 | 223 | 222 | {"type": "Polygon", "coordinates": [[[-120.30735, 34.60822], [-120.30677, 34.60853], [-120.30678, 34.60893], [-120.3056, 34.60813], [-120.30557, 34.6074], [-120.30189, 34.60527], [-120.30097, 34.60541], [-120.30098, 34.60492], [-120.30091, 34.60466], [-120.30062, 34.60438], [-120.30092, 34.60412], [-120.29991, 34.60337], [-120.29883, 34.60341], [-120.29874, 34.60326], [-120.29916, 34.60305], [-120.30017, 34.60306], [-120.301, 34.60348], [-120.30152, 34.60338], [-120.30129, 34.60386], [-120.30172, 34.60416], [-120.30208, 34.60463], [-120.30257, 34.60484], [-120.30301, 34.60488], [-120.30316, 34.60512], [-120.30339, 34.60529], [-120.30363, 34.60552], [-120.30404, 34.60552], [-120.30465, 34.60545], [-120.30514, 34.60554], [-120.30564, 34.6055], [-120.30565, 34.60574], [-120.306, 34.60603], [-120.30666, 34.60682], [-120.30735, 34.60822]]]} | Open Access 1 | 610 | Santa Rosa Park | 25134 | 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 | 24.322 | Santa Rosa Park | 0 | Local Park 2 | 4 | |
241 | 241 | 240 | {"type": "Polygon", "coordinates": [[[-120.19548, 34.61923], [-120.19532, 34.62017], [-120.19414, 34.61966], [-120.19453, 34.61897], [-120.19477, 34.61907], [-120.19504, 34.61915], [-120.19548, 34.61923]]]} | Open Access 1 | 785 | Buellton Park | 16483 | 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 | 2.399 | Buellton Park | 0 | Local Park 2 | 4 | |
248 | 248 | 247 | {"type": "Polygon", "coordinates": [[[-120.43425, 34.94713], [-120.43423, 34.94857], [-120.43412, 34.94857], [-120.43412, 34.94888], [-120.43362, 34.94888], [-120.43362, 34.94858], [-120.4336, 34.94857], [-120.4336, 34.94842], [-120.43368, 34.94841], [-120.43368, 34.94824], [-120.43331, 34.94824], [-120.4333, 34.94838], [-120.43282, 34.94838], [-120.43281, 34.94836], [-120.43157, 34.94835], [-120.43157, 34.94625], [-120.43274, 34.94627], [-120.43274, 34.94713], [-120.43425, 34.94713]]]} | Open Access 1 | 811 | Simas Basin Park | 25503 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 11.392 | Simas Basin Park | 0 | Local Park 2 | 4 | |
264 | 264 | 263 | {"type": "Polygon", "coordinates": [[[-120.19453, 34.61897], [-120.19414, 34.61966], [-120.19316, 34.61923], [-120.19343, 34.61873], [-120.19247, 34.61831], [-120.19265, 34.618], [-120.19309, 34.61817], [-120.1932, 34.61798], [-120.19324, 34.61799], [-120.19314, 34.61819], [-120.19416, 34.61859], [-120.19407, 34.61865], [-120.19405, 34.61869], [-120.19404, 34.61876], [-120.19407, 34.61883], [-120.19415, 34.61888], [-120.19428, 34.61888], [-120.19453, 34.61897]]]} | Open Access 1 | 735 | Buellton Park | 16482 | 1036 | Buellton, City of 88 | City 2 | City Agency 2 | http://www.cityofbuellton.com/Parks&Rec/parks.asp | City 2 | 1036 | Buellton, City of 86 | City 2 | City Agency 2 | Santa Barbara 7 | 3.366 | Buellton Park | 0 | Local Park 2 | 4 | |
297 | 297 | 296 | {"type": "Polygon", "coordinates": [[[-119.71194, 34.39632], [-119.71076, 34.3961], [-119.71039, 34.39606], [-119.71001, 34.39605], [-119.70963, 34.39607], [-119.70926, 34.39613], [-119.708, 34.39646], [-119.70506, 34.39741], [-119.70451, 34.39762], [-119.70425, 34.39775], [-119.704, 34.39789], [-119.70366, 34.39813], [-119.70336, 34.3984], [-119.70316, 34.39859], [-119.70284, 34.39905], [-119.70263, 34.39947], [-119.70247, 34.39937], [-119.70254, 34.39925], [-119.70255, 34.39906], [-119.70237, 34.39872], [-119.70238, 34.39865], [-119.70232, 34.39849], [-119.70223, 34.39836], [-119.70222, 34.39829], [-119.70226, 34.39829], [-119.7023, 34.39826], [-119.70267, 34.39796], [-119.70303, 34.39798], [-119.70348, 34.39764], [-119.70359, 34.39749], [-119.70367, 34.39741], [-119.70378, 34.39733], [-119.7039, 34.39728], [-119.7041, 34.39723], [-119.70522, 34.39684], [-119.70576, 34.39662], [-119.70624, 34.3965], [-119.70827, 34.39576], [-119.70851, 34.3958], [-119.70907, 34.39583], [-119.71027, 34.39574], [-119.71077, 34.39576], [-119.71113, 34.39574], [-119.71149, 34.39568], [-119.71178, 34.39567], [-119.71194, 34.39632]]]} | Open Access 1 | 801 | Shoreline Park | 25428 | 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 | 13.242 | Shoreline Park | 0 | Local Park 2 | 4 | |
314 | 314 | 313 | {"type": "Polygon", "coordinates": [[[-119.69311, 34.46023], [-119.69221, 34.46094], [-119.69162, 34.46037], [-119.6916, 34.46001], [-119.69199, 34.45915], [-119.69235, 34.45915], [-119.69311, 34.46023]]]} | Open Access 1 | 847 | Skofield Park | 25529 | 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.077 | Skofield Park | 0 | Local Park 2 | 4 | |
345 | 345 | 344 | {"type": "Polygon", "coordinates": [[[-119.5898, 34.42352], [-119.58906, 34.42428], [-119.5885, 34.42388], [-119.58922, 34.42315], [-119.5898, 34.42352]]]} | Open Access 1 | 1191 | Summerland Greenwell Preserve | 25961 | 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 | 1.774 | Summerland Greenwell Preserve | 0 | Local Conservation Area 4 | 2 | |
352 | 352 | 351 | {"type": "Polygon", "coordinates": [[[-120.44058, 34.94325], [-120.44056, 34.94446], [-120.43923, 34.94444], [-120.43925, 34.94324], [-120.44058, 34.94325]]]} | Open Access 1 | 971 | Buena Vista Park | 16495 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 4.028 | Buena Vista Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);