units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where MNG_AGENCY = 26 sorted by GAP_STS
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 | |||
5956 | 5956 | 5955 | {"type": "MultiPolygon", "coordinates": [[[[-119.66895, 34.42008], [-119.6673, 34.42053], [-119.66688, 34.42022], [-119.66735, 34.41978], [-119.66759, 34.41994], [-119.66811, 34.41946], [-119.66895, 34.42008]]], [[[-119.66709, 34.42062], [-119.66709, 34.42063], [-119.66625, 34.42085], [-119.66676, 34.42038], [-119.66709, 34.42062]]], [[[-119.6667, 34.42019], [-119.66587, 34.42096], [-119.6649, 34.42122], [-119.6648, 34.42119], [-119.66476, 34.42077], [-119.66422, 34.42048], [-119.66379, 34.42021], [-119.6633, 34.41997], [-119.66314, 34.4197], [-119.66327, 34.41888], [-119.66395, 34.41844], [-119.66417, 34.41798], [-119.66437, 34.4179], [-119.66501, 34.41776], [-119.66507, 34.41822], [-119.66494, 34.41867], [-119.66508, 34.41888], [-119.66539, 34.41889], [-119.66559, 34.41902], [-119.66568, 34.41923], [-119.66562, 34.41949], [-119.66551, 34.4196], [-119.66536, 34.41972], [-119.66533, 34.41978], [-119.6667, 34.42019]]]]} | Open Access 1 | 517 | Santa Barbara Zoological Gardens | 25054 | 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 | 18.052 | Santa Barbara Zoological Gardens | 0 | None 476 | ||
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 | |||
7782 | 7782 | 7781 | {"type": "Polygon", "coordinates": [[[-119.6649, 34.42122], [-119.66069, 34.42234], [-119.65994, 34.42248], [-119.65896, 34.42255], [-119.65662, 34.42136], [-119.65665, 34.42119], [-119.65672, 34.42104], [-119.65679, 34.42096], [-119.65693, 34.42083], [-119.65709, 34.42072], [-119.65739, 34.42055], [-119.65768, 34.42042], [-119.65788, 34.42036], [-119.65829, 34.42029], [-119.66117, 34.4201], [-119.66131, 34.42008], [-119.66144, 34.42003], [-119.66163, 34.41991], [-119.66191, 34.41967], [-119.6621, 34.41949], [-119.66228, 34.4192], [-119.6626, 34.41855], [-119.66269, 34.41843], [-119.6628, 34.41832], [-119.663, 34.41821], [-119.66314, 34.41816], [-119.66437, 34.4179], [-119.66417, 34.41798], [-119.66395, 34.41844], [-119.66327, 34.41888], [-119.66314, 34.41969], [-119.6633, 34.41997], [-119.66379, 34.42021], [-119.66422, 34.42048], [-119.66476, 34.42078], [-119.66479, 34.42119], [-119.6649, 34.42122]]]} | Open Access 1 | 8690 | Andre Clark Bird Refuge | 15482 | 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 | 40.91 | Andre Clark Bird Refuge | 0 | Local Conservation Area 4 | 2 | |
8636 | 8636 | 8635 | {"type": "Polygon", "coordinates": [[[-119.74327, 34.40268], [-119.74281, 34.40401], [-119.74071, 34.40454], [-119.74078, 34.40476], [-119.74033, 34.40489], [-119.74028, 34.4048], [-119.73989, 34.40491], [-119.73968, 34.40495], [-119.73946, 34.40497], [-119.73853, 34.40494], [-119.73635, 34.40462], [-119.73614, 34.40469], [-119.73598, 34.40469], [-119.73437, 34.40428], [-119.73532, 34.40426], [-119.73675, 34.40426], [-119.73677, 34.40319], [-119.73676, 34.40304], [-119.73681, 34.4012], [-119.73505, 34.40118], [-119.73505, 34.40069], [-119.73483, 34.40057], [-119.73463, 34.40056], [-119.73462, 34.39855], [-119.73629, 34.39906], [-119.7367, 34.39936], [-119.73706, 34.39956], [-119.73799, 34.40017], [-119.73809, 34.40013], [-119.7381, 34.40019], [-119.73836, 34.40032], [-119.73916, 34.40081], [-119.74042, 34.40149], [-119.7427, 34.40247], [-119.74327, 34.40268]]]} | Open Access 1 | 13812 | Douglas Family Reserve | 18243 | 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 | 68.84 | Douglas Family Reserve | 0 | Local Conservation Area 4 | 2 | |
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 |
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]);