units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
152 rows where ACCESS_TYP = 1, COUNTY = 7 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 14
- Local Park 93
- Local Other or Unknown 38
- Local Recreation Area 8
- Local Conservation Area 3
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 1
- Open Access · 152 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
362 | 362 | 361 | {"type": "Polygon", "coordinates": [[[-119.70786, 34.42217], [-119.70687, 34.42311], [-119.70648, 34.42283], [-119.70697, 34.42235], [-119.70623, 34.42182], [-119.70672, 34.42135], [-119.70786, 34.42217]]]} | Open Access 1 | 1024 | Spencer Adams Park | 25720 | 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.179 | Spencer Adams Park | 0 | Local Park 2 | 4 | |
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 | |||
422 | 422 | 421 | {"type": "Polygon", "coordinates": [[[-120.47173, 34.64553], [-120.47171, 34.64701], [-120.47055, 34.647], [-120.47057, 34.64552], [-120.47173, 34.64553]]]} | Open Access 1 | 1352 | Thompson Park | 26315 | 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 | 4.345 | Thompson Park | 0 | Local Park 2 | 4 | |
435 | 435 | 434 | {"type": "Polygon", "coordinates": [[[-119.69855, 34.45558], [-119.69836, 34.45579], [-119.69797, 34.45582], [-119.69763, 34.4559], [-119.6974, 34.45592], [-119.69721, 34.45613], [-119.69705, 34.45625], [-119.69706, 34.45701], [-119.69648, 34.45697], [-119.69605, 34.45727], [-119.69579, 34.45719], [-119.69542, 34.45728], [-119.69512, 34.457], [-119.69503, 34.45701], [-119.69485, 34.45705], [-119.69472, 34.45712], [-119.69395, 34.45739], [-119.69294, 34.45739], [-119.6922, 34.45773], [-119.69219, 34.45747], [-119.69224, 34.45747], [-119.6924, 34.45716], [-119.69291, 34.45688], [-119.69296, 34.45676], [-119.69302, 34.45564], [-119.69377, 34.45575], [-119.694, 34.45558], [-119.69406, 34.45526], [-119.69316, 34.45512], [-119.69481, 34.45361], [-119.69524, 34.45356], [-119.69511, 34.45391], [-119.69511, 34.45393], [-119.6963, 34.45392], [-119.69646, 34.45399], [-119.69718, 34.45447], [-119.69735, 34.45452], [-119.69758, 34.45457], [-119.69822, 34.45452], [-119.69832, 34.45556], [-119.69855, 34.45558]]]} | Open Access 1 | 838 | Skofield Park | 25530 | 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 | 35.113 | Skofield Park | 0 | Local Park 2 | 4 | |
454 | 454 | 453 | {"type": "Polygon", "coordinates": [[[-120.41539, 34.9625], [-120.41538, 34.96297], [-120.41382, 34.96295], [-120.41381, 34.96389], [-120.41248, 34.96388], [-120.41249, 34.96273], [-120.41339, 34.96275], [-120.4134, 34.96267], [-120.41373, 34.96267], [-120.41374, 34.96248], [-120.41539, 34.9625]]]} | Open Access 1 | 1454 | Tunnell Park | 26577 | 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 | 5.767 | Tunnell Park | 0 | Local Park 2 | 4 | |
478 | 478 | 477 | {"type": "MultiPolygon", "coordinates": [[[[-119.8811, 34.4255], [-119.8809, 34.42576], [-119.88084, 34.42602], [-119.88092, 34.42609], [-119.88088, 34.42616], [-119.88088, 34.42624], [-119.88082, 34.42627], [-119.88069, 34.42651], [-119.88078, 34.42684], [-119.88091, 34.42693], [-119.88087, 34.42703], [-119.88075, 34.42703], [-119.88061, 34.42714], [-119.88059, 34.42731], [-119.88053, 34.4276], [-119.88047, 34.42762], [-119.88043, 34.42768], [-119.88042, 34.42774], [-119.88043, 34.4278], [-119.88033, 34.42785], [-119.88028, 34.42812], [-119.88025, 34.42813], [-119.8802, 34.4284], [-119.87987, 34.42835], [-119.87989, 34.42816], [-119.87985, 34.42803], [-119.8799, 34.428], [-119.87993, 34.42796], [-119.87994, 34.4279], [-119.87992, 34.42784], [-119.88005, 34.42777], [-119.88007, 34.42753], [-119.88018, 34.42753], [-119.88019, 34.42721], [-119.88027, 34.42716], [-119.88029, 34.42708], [-119.88038, 34.42703], [-119.8804, 34.4267], [-119.8804, 34.42636], [-119.88035, 34.42631], [-119.88032, 34.42622], [-119.88047, 34.42611], [-119.88046, 34.42588], [-119.88062, 34.42588], [-119.88073, 34.42542], [-119.88067, 34.42504], [-119.88084, 34.425], [-119.88095, 34.42528], [-119.88105, 34.42533], [-119.88104, 34.42542], [-119.8811, 34.4255]]], [[[-119.881, 34.42866], [-119.88094, 34.42896], [-119.88089, 34.42907], [-119.88081, 34.42916], [-119.88074, 34.42909], [-119.88065, 34.42907], [-119.88057, 34.4291], [-119.88052, 34.42919], [-119.88054, 34.42929], [-119.88062, 34.42935], [-119.88049, 34.42959], [-119.8807, 34.42968], [-119.88071, 34.4297], [-119.88089, 34.42976], [-119.88088, 34.42983], [-119.88053, 34.42984], [-119.88019, 34.42931], [-119.88011, 34.42913], [-119.88005, 34.42883], [-119.88007, 34.42854], [-119.881, 34.42866]]]]} | Open Access 1 | 1605 | University Village | 26691 | 1121 | Goleta, City of 179 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | Santa Barbara 7 | 4.806 | University Village | 0 | None 50 | ||
504 | 504 | 503 | {"type": "Polygon", "coordinates": [[[-120.42711, 34.97493], [-120.42701, 34.97493], [-120.42662, 34.97474], [-120.42536, 34.97428], [-120.42559, 34.97429], [-120.42578, 34.97425], [-120.42594, 34.97418], [-120.42604, 34.97412], [-120.42632, 34.97403], [-120.42638, 34.97398], [-120.42641, 34.9739], [-120.42648, 34.97388], [-120.42711, 34.97493]]]} | Open Access 1 | 48891 | Jim May Park | 33608 | 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 | https://www.cityofsantamaria.org/city-government/departments/recreation-and-parks/visit-your-parks/view-park-photos-descriptions#Jim%20May%20Park | Santa Barbara 7 | 1.57 | Jim May Park | 0 | Local Park 2 | 4 |
549 | 549 | 548 | {"type": "Polygon", "coordinates": [[[-119.70269, 34.41206], [-119.70265, 34.4121], [-119.70232, 34.41186], [-119.70196, 34.41168], [-119.70157, 34.41156], [-119.70127, 34.41152], [-119.70142, 34.41138], [-119.70167, 34.41155], [-119.70181, 34.41142], [-119.70269, 34.41206]]]} | Open Access 1 | 1830 | Wentworth Park | 27347 | 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.363 | Wentworth Park | 0 | Local Park 2 | 4 | |
657 | 657 | 656 | {"type": "Polygon", "coordinates": [[[-120.14287, 34.588], [-120.1423, 34.58955], [-120.14208, 34.58947], [-120.14139, 34.58931], [-120.14146, 34.58926], [-120.14226, 34.58911], [-120.14247, 34.58854], [-120.14266, 34.58832], [-120.14287, 34.588]]]} | Open Access 1 | 3221 | Alisal Commons Park | 15367 | 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 | 1.023 | Alisal Commons Park | 0 | Local Park 2 | 4 | |
669 | 669 | 668 | {"type": "Polygon", "coordinates": [[[-119.69229, 34.41084], [-119.69211, 34.41099], [-119.69147, 34.41051], [-119.69164, 34.41036], [-119.69229, 34.41084]]]} | Open Access 1 | 5182 | Ambassador Park | 15441 | 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.456 | Ambassador 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]);