units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where MNG_AGENCY = 26 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 8
- Local Park 39
- Local Other or Unknown 11
- Local Recreation Area 8
- Local Conservation Area 2
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 64
MNG_AGENCY 1
- Santa Barbara, City of · 64 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
5945 | 5945 | 5944 | {"type": "Polygon", "coordinates": [[[-119.69499, 34.40303], [-119.69487, 34.40308], [-119.69454, 34.40328], [-119.69431, 34.40361], [-119.69416, 34.40436], [-119.69411, 34.4044], [-119.6942, 34.40471], [-119.69451, 34.40523], [-119.69453, 34.40539], [-119.69436, 34.40701], [-119.69433, 34.40713], [-119.69425, 34.40736], [-119.69413, 34.40758], [-119.69397, 34.40777], [-119.69385, 34.40789], [-119.69365, 34.40807], [-119.6936, 34.40805], [-119.69183, 34.40968], [-119.68981, 34.41138], [-119.68908, 34.41202], [-119.68861, 34.41172], [-119.68875, 34.41149], [-119.68913, 34.41125], [-119.68933, 34.41106], [-119.6896, 34.41072], [-119.68985, 34.41045], [-119.69007, 34.41014], [-119.69037, 34.4098], [-119.69048, 34.40968], [-119.69095, 34.4093], [-119.69144, 34.40892], [-119.69169, 34.4087], [-119.6919, 34.4084], [-119.69229, 34.40799], [-119.69239, 34.40782], [-119.69244, 34.40763], [-119.69251, 34.40751], [-119.6926, 34.40739], [-119.69279, 34.40689], [-119.69284, 34.40662], [-119.69291, 34.40651], [-119.69301, 34.40641], [-119.69335, 34.40585], [-119.69366, 34.40559], [-119.69379, 34.40541], [-119.69394, 34.40523], [-119.69401, 34.40511], [-119.69406, 34.40497], [-119.69408, 34.40477], [-119.69188, 34.40313], [-119.69141, 34.40331], [-119.69132, 34.40338], [-119.69111, 34.40346], [-119.69068, 34.40369], [-119.6902, 34.40385], [-119.68996, 34.40398], [-119.68969, 34.40409], [-119.68948, 34.40415], [-119.68917, 34.40431], [-119.68905, 34.40444], [-119.68887, 34.40475], [-119.68867, 34.40495], [-119.68857, 34.40546], [-119.68865, 34.40575], [-119.68871, 34.40584], [-119.68872, 34.40608], [-119.68928, 34.40696], [-119.68924, 34.40705], [-119.68901, 34.40719], [-119.68896, 34.4075], [-119.68881, 34.40757], [-119.68835, 34.40763], [-119.68816, 34.40759], [-119.68786, 34.40746], [-119.68763, 34.40728], [-119.68753, 34.407], [-119.68765, 34.40652], [-119.68781, 34.40621], [-119.6879, 34.40539], [-119.68785, 34.40501], [-119.68756, 34.40499], [-119.68714, 34.40514], [-119.68705, 34.40509], [-119.68704, 34.40502], [-119.68707, 34.40497], [-119.68786, 34.4046], [-119.68859, 34.40433], [-119.689, 34.40415], [-119.68941, 34.40399], [-119.68973, 34.40384], [-119.69088, 34.40338], [-119.69117, 34.40322], [-119.69131, 34.40318], [-119.69192, 34.40295], [-119.69204, 34.40296], [-119.69233, 34.40306], [-119.69314, 34.40285], [-119.69444, 34.40258], [-119.69499, 34.40303]]]} | Open Access 1 | 507 | Santa Barbara Maitime Museum | 25052 | 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 | 39.477 | Santa Barbara Maitime Museum | None 475 | |||
10396 | 10396 | 10395 | {"type": "Polygon", "coordinates": [[[-119.69501, 34.41928], [-119.69462, 34.41964], [-119.69441, 34.41949], [-119.69436, 34.41944], [-119.69436, 34.41942], [-119.69424, 34.41933], [-119.69421, 34.41934], [-119.6935, 34.41882], [-119.69388, 34.41847], [-119.69501, 34.41928]]]} | Open Access 1 | 18375 | Palza Vera Cruz | 23376 | 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 | 1.807 | Palza Vera Cruz | None 910 | |||
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 | |
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 | |
177 | 177 | 176 | {"type": "Polygon", "coordinates": [[[-119.74164, 34.43295], [-119.74153, 34.43576], [-119.73893, 34.43575], [-119.73887, 34.43693], [-119.73869, 34.43693], [-119.73853, 34.43695], [-119.73837, 34.437], [-119.73822, 34.43708], [-119.73804, 34.43724], [-119.73783, 34.43753], [-119.73766, 34.43766], [-119.73751, 34.43772], [-119.73402, 34.43838], [-119.73394, 34.43798], [-119.73391, 34.43769], [-119.73392, 34.43573], [-119.73369, 34.43572], [-119.73366, 34.43384], [-119.73517, 34.43387], [-119.73518, 34.43141], [-119.73888, 34.43138], [-119.73888, 34.42908], [-119.73969, 34.42935], [-119.74016, 34.42954], [-119.74079, 34.42982], [-119.7407, 34.4325], [-119.74164, 34.43295]]]} | Restricted Access 2 | 492 | Santa Barbara Golf Club | 32988 | 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 | 110.039 | Santa Barbara Golf Club | 0 | Local Recreation Area 3 | 4 | |
285 | 285 | 284 | {"type": "MultiPolygon", "coordinates": [[[[-119.69069, 34.44329], [-119.69064, 34.4434], [-119.69065, 34.44355], [-119.69068, 34.44362], [-119.69097, 34.44402], [-119.69099, 34.44413], [-119.69098, 34.44422], [-119.69094, 34.4443], [-119.69087, 34.44436], [-119.69029, 34.44464], [-119.69015, 34.44481], [-119.69015, 34.44384], [-119.68972, 34.44402], [-119.68956, 34.44406], [-119.68939, 34.44408], [-119.68783, 34.44396], [-119.68772, 34.44393], [-119.6876, 34.44389], [-119.68726, 34.44363], [-119.68703, 34.44354], [-119.68683, 34.4435], [-119.68629, 34.44347], [-119.68596, 34.4434], [-119.68596, 34.44324], [-119.68632, 34.44331], [-119.6869, 34.44334], [-119.6871, 34.44338], [-119.6873, 34.44346], [-119.68745, 34.44355], [-119.68767, 34.44372], [-119.68782, 34.44378], [-119.68937, 34.44392], [-119.68964, 34.44387], [-119.69015, 34.44364], [-119.69013, 34.44286], [-119.69069, 34.44329]]], [[[-119.69482, 34.44571], [-119.69452, 34.44628], [-119.69438, 34.44643], [-119.69253, 34.44663], [-119.69154, 34.4466], [-119.69056, 34.44614], [-119.69014, 34.44596], [-119.69015, 34.44498], [-119.69037, 34.44471], [-119.69094, 34.44446], [-119.69102, 34.4444], [-119.69109, 34.44429], [-119.69113, 34.44416], [-119.6911, 34.444], [-119.6908, 34.44353], [-119.69078, 34.44345], [-119.6908, 34.44337], [-119.69144, 34.44386], [-119.69193, 34.44417], [-119.69239, 34.44438], [-119.6932, 34.44461], [-119.69391, 34.4449], [-119.69482, 34.44571]]]]} | Unknown Access 4 | 777 | Sheffield Reservoir | 25382 | 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 | 26.245 | Sheffield Reservoir | 0 | Local Recreation Area 3 | 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 | |
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 | |
364 | 364 | 363 | {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} | Unknown Access 4 | 1276 | Sycamore Creek | 26121 | 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.446 | Sycamore Creek | 0 | Local Other or Unknown 14 | 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 | |
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 | |
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 | |
1412 | 1412 | 1411 | {"type": "Polygon", "coordinates": [[[-119.67034, 34.43903], [-119.67034, 34.4395], [-119.66917, 34.4395], [-119.66941, 34.43903], [-119.67034, 34.43903]]]} | Unknown Access 4 | 36486 | Santa Barbara holding 9 | 25051 | 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 | 1.234 | Santa Barbara holding 9 | 0 | Local Other or Unknown 14 | 4 | |
2154 | 2154 | 2153 | {"type": "Polygon", "coordinates": [[[-119.75676, 34.44653], [-119.75671, 34.44688], [-119.75658, 34.447], [-119.75605, 34.44728], [-119.75605, 34.447], [-119.75603, 34.44678], [-119.75606, 34.44662], [-119.75612, 34.4465], [-119.75644, 34.44655], [-119.75676, 34.44653]]]} | Open Access 1 | 17474 | Los Robles Park | 21534 | 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.976 | Los Robles Park | 0 | Local Park 2 | 4 | |
2287 | 2287 | 2286 | {"type": "MultiPolygon", "coordinates": [[[[-119.75025, 34.42221], [-119.75027, 34.4225], [-119.75032, 34.42268], [-119.75041, 34.42282], [-119.75062, 34.42303], [-119.75066, 34.42315], [-119.75069, 34.42406], [-119.75073, 34.42421], [-119.75088, 34.42452], [-119.75092, 34.42468], [-119.7509, 34.42564], [-119.75084, 34.42585], [-119.75076, 34.42605], [-119.75063, 34.42623], [-119.75045, 34.42642], [-119.75037, 34.42656], [-119.75025, 34.42691], [-119.74963, 34.42691], [-119.74999, 34.42633], [-119.75011, 34.42602], [-119.75014, 34.42574], [-119.74994, 34.42554], [-119.74988, 34.4254], [-119.75025, 34.4249], [-119.75026, 34.42476], [-119.74978, 34.42439], [-119.74961, 34.4242], [-119.74951, 34.42403], [-119.74953, 34.42385], [-119.74967, 34.4237], [-119.74975, 34.4235], [-119.74983, 34.42345], [-119.74972, 34.42319], [-119.74956, 34.4231], [-119.74952, 34.42316], [-119.74937, 34.42303], [-119.74915, 34.42294], [-119.74872, 34.42269], [-119.74873, 34.42249], [-119.74887, 34.42206], [-119.74877, 34.4219], [-119.7485, 34.42179], [-119.7481, 34.42156], [-119.74832, 34.42139], [-119.74919, 34.42152], [-119.74931, 34.42163], [-119.7494, 34.42186], [-119.74927, 34.42191], [-119.74925, 34.42209], [-119.74929, 34.42222], [-119.74936, 34.42226], [-119.75025, 34.42221]]], [[[-119.75135, 34.42914], [-119.75062, 34.42944], [-119.75042, 34.43027], [-119.75038, 34.4311], [-119.74987, 34.43189], [-119.74995, 34.43212], [-119.75014, 34.43251], [-119.74972, 34.43262], [-119.74914, 34.43315], [-119.74924, 34.43345], [-119.74892, 34.43323], [-119.74894, 34.43305], [-119.74912, 34.43286], [-119.74925, 34.43281], [-119.7494, 34.43262], [-119.74942, 34.43254], [-119.74969, 34.43239], [-119.74984, 34.4324], [-119.74994, 34.43231], [-119.74988, 34.4322], [-119.74991, 34.43212], [-119.74982, 34.43203], [-119.74969, 34.43174], [-119.74978, 34.43156], [-119.74969, 34.4315], [-119.74979, 34.43142], [-119.74981, 34.43128], [-119.74984, 34.43122], [-119.74991, 34.43114], [-119.75012, 34.43099], [-119.75018, 34.43089], [-119.75011, 34.4308], [-119.75019, 34.43059], [-119.7502, 34.43043], [-119.75003, 34.4301], [-119.75005, 34.42985], [-119.75051, 34.42936], [-119.751, 34.42907], [-119.75104, 34.42877], [-119.75091, 34.42841], [-119.75064, 34.42814], [-119.75025, 34.42817], [-119.75007, 34.42806], [-119.74999, 34.42785], [-119.74997, 34.42758], [-119.75001, 34.42733], [-119.75011, 34.4271], [-119.75043, 34.42765], [-119.75061, 34.42793], [-119.75133, 34.42859], [-119.75135, 34.42914]]]]} | Open Access 1 | 16877 | Hidden Valley Park | 19919 | 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 | 17.695 | Hidden Valley Park | 0 | Local Park 2 | 4 | |
2299 | 2299 | 2298 | {"type": "Polygon", "coordinates": [[[-119.71793, 34.40835], [-119.71759, 34.40933], [-119.71741, 34.40926], [-119.71644, 34.40915], [-119.71625, 34.40916], [-119.71528, 34.40937], [-119.71521, 34.40916], [-119.71496, 34.40912], [-119.71278, 34.40837], [-119.71396, 34.40727], [-119.71483, 34.40644], [-119.71793, 34.40835]]]} | Open Access 1 | 16930 | Honda Valley Park | 20065 | 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 | 20.686 | Honda Valley Park | 0 | Local Park 2 | 4 | |
2568 | 2568 | 2567 | {"type": "MultiPolygon", "coordinates": [[[[-119.71235, 34.43717], [-119.71239, 34.43727], [-119.71242, 34.43741], [-119.71236, 34.43784], [-119.71238, 34.43805], [-119.71242, 34.43818], [-119.71249, 34.43831], [-119.71277, 34.43863], [-119.71287, 34.43882], [-119.7129, 34.43896], [-119.71292, 34.4391], [-119.71289, 34.43922], [-119.71284, 34.43934], [-119.71275, 34.43944], [-119.71264, 34.43952], [-119.71251, 34.43957], [-119.71237, 34.43958], [-119.7122, 34.43955], [-119.71208, 34.43948], [-119.7116, 34.43929], [-119.71145, 34.43926], [-119.71108, 34.43926], [-119.71107, 34.43818], [-119.71119, 34.43793], [-119.71137, 34.43759], [-119.71141, 34.43755], [-119.71152, 34.4375], [-119.71158, 34.43745], [-119.71161, 34.43737], [-119.71161, 34.43726], [-119.71163, 34.4372], [-119.71188, 34.43689], [-119.71194, 34.43689], [-119.71235, 34.43717]]], [[[-119.71303, 34.43937], [-119.71304, 34.43947], [-119.71301, 34.43961], [-119.71273, 34.44012], [-119.71272, 34.44021], [-119.71228, 34.44022], [-119.71217, 34.44025], [-119.71191, 34.44045], [-119.71188, 34.44029], [-119.71184, 34.44019], [-119.71172, 34.44003], [-119.71127, 34.43969], [-119.71117, 34.43965], [-119.71108, 34.43965], [-119.71108, 34.4394], [-119.7114, 34.43941], [-119.71158, 34.43945], [-119.7122, 34.43971], [-119.71233, 34.43973], [-119.71252, 34.43973], [-119.7127, 34.43967], [-119.71282, 34.4396], [-119.71296, 34.43947], [-119.71303, 34.43937]]]]} | Open Access 1 | 17851 | Mission Park | 22305 | 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 | 10.435 | Mission Park | 0 | Local Park 2 | 4 | |
2581 | 2581 | 2580 | {"type": "Polygon", "coordinates": [[[-119.66557, 34.42181], [-119.6652, 34.42296], [-119.66446, 34.42284], [-119.66145, 34.42302], [-119.66143, 34.42284], [-119.66412, 34.42212], [-119.66557, 34.42181]]]} | Unknown Access 4 | 17913 | Montecity Country Club | 22411 | 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.027 | Montecity Country Club | 0 | Local Recreation Area 3 | 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]);