units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
93 rows where COUNTY = 7, DES_TP = 2 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 | |
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 | |
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 | |
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 | |
871 | 871 | 870 | {"type": "MultiPolygon", "coordinates": [[[[-119.68898, 34.41211], [-119.68773, 34.41331], [-119.68681, 34.41412], [-119.6866, 34.41423], [-119.68633, 34.41434], [-119.68608, 34.41444], [-119.6858, 34.41453], [-119.6855, 34.41459], [-119.68359, 34.41486], [-119.67847, 34.41544], [-119.67588, 34.41588], [-119.67218, 34.41663], [-119.67189, 34.41642], [-119.6721, 34.41639], [-119.67257, 34.41627], [-119.67287, 34.41615], [-119.67322, 34.41608], [-119.6734, 34.41608], [-119.6737, 34.41601], [-119.67381, 34.416], [-119.67398, 34.41595], [-119.67414, 34.41594], [-119.67433, 34.41587], [-119.67443, 34.41586], [-119.67453, 34.41581], [-119.67466, 34.41581], [-119.67476, 34.41577], [-119.67487, 34.41576], [-119.67502, 34.41572], [-119.67515, 34.41571], [-119.67531, 34.41564], [-119.676, 34.41553], [-119.67616, 34.41547], [-119.67634, 34.41544], [-119.67686, 34.41528], [-119.67693, 34.41529], [-119.67771, 34.4151], [-119.67811, 34.41504], [-119.67828, 34.41498], [-119.6785, 34.41496], [-119.67885, 34.41487], [-119.67932, 34.41481], [-119.67977, 34.41478], [-119.68027, 34.41471], [-119.68075, 34.41459], [-119.68096, 34.41448], [-119.68111, 34.41443], [-119.68152, 34.41436], [-119.68168, 34.41435], [-119.68187, 34.41428], [-119.68211, 34.41424], [-119.68233, 34.41415], [-119.68248, 34.41405], [-119.68304, 34.41385], [-119.68321, 34.41382], [-119.68343, 34.41375], [-119.68368, 34.41375], [-119.68413, 34.41361], [-119.68458, 34.4136], [-119.68505, 34.41352], [-119.68519, 34.41344], [-119.68541, 34.41334], [-119.68676, 34.41258], [-119.68787, 34.41207], [-119.68817, 34.41191], [-119.68847, 34.41181], [-119.68852, 34.4118], [-119.68898, 34.41211]]], [[[-119.68695, 34.4149], [-119.68489, 34.41548], [-119.68074, 34.41666], [-119.68055, 34.41553], [-119.68057, 34.41549], [-119.68061, 34.41546], [-119.68255, 34.41524], [-119.68568, 34.4148], [-119.68597, 34.41474], [-119.68626, 34.41466], [-119.68673, 34.41447], [-119.68676, 34.41447], [-119.68679, 34.4145], [-119.68695, 34.4149]]]]} | Open Access 1 | 5611 | Chase Palm Park | 17155 | 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 | 42.884 | Chase Palm Park | 0 | Local Park 2 | 4 | |
1361 | 1361 | 1360 | {"type": "Polygon", "coordinates": [[[-120.46093, 34.64714], [-120.46091, 34.64863], [-120.45969, 34.64862], [-120.45971, 34.64713], [-120.46093, 34.64714]]]} | Open Access 1 | 8073 | College Park | 17509 | 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.568 | College Park | 0 | Local Park 2 | 4 | |
1870 | 1870 | 1869 | {"type": "Polygon", "coordinates": [[[-119.51885, 34.40531], [-119.5185, 34.40564], [-119.51824, 34.40594], [-119.51806, 34.40622], [-119.51784, 34.40664], [-119.51779, 34.40679], [-119.51776, 34.40693], [-119.51755, 34.40688], [-119.51773, 34.40641], [-119.51825, 34.40559], [-119.51853, 34.40523], [-119.51885, 34.40531]]]} | Open Access 1 | 16019 | Franklin Park | 19061 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 1.02 | Franklin Park | 0 | Local Park 2 | 4 | |
2032 | 2032 | 2031 | {"type": "Polygon", "coordinates": [[[-120.45135, 34.64228], [-120.45134, 34.64331], [-120.44908, 34.64329], [-120.44909, 34.64226], [-120.45135, 34.64228]]]} | Open Access 1 | 17052 | Johns-Manville Park | 20474 | 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 | 5.856 | Johns-Manville 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]);