units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
39 rows where AGNCY_LEV = 2, DES_TP = 2 and MNG_AGENCY = 26 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 39
MNG_AGENCY 1
- Santa Barbara, City of · 39 ✖
DES_TP 1
- Local Park · 39 ✖
ACCESS_TYP 1
- Open Access 39
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 | |
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 | |
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 | |
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 | |
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 | |
4846 | 4846 | 4845 | {"type": "MultiPolygon", "coordinates": [[[[-119.73568, 34.45038], [-119.73544, 34.45039], [-119.73544, 34.45079], [-119.73524, 34.45095], [-119.73485, 34.45159], [-119.73481, 34.45214], [-119.73369, 34.45213], [-119.73436, 34.45153], [-119.73445, 34.45128], [-119.73426, 34.45121], [-119.73432, 34.45069], [-119.73489, 34.45026], [-119.73488, 34.44987], [-119.73564, 34.45003], [-119.73568, 34.45038]]], [[[-119.73562, 34.44978], [-119.73477, 34.44958], [-119.73475, 34.44943], [-119.73453, 34.4491], [-119.73428, 34.44881], [-119.73413, 34.44825], [-119.73413, 34.44798], [-119.73429, 34.44771], [-119.73453, 34.44745], [-119.73478, 34.44691], [-119.73504, 34.44659], [-119.7351, 34.44647], [-119.73546, 34.44662], [-119.73554, 34.4467], [-119.73559, 34.44682], [-119.73559, 34.44688], [-119.73527, 34.44708], [-119.73525, 34.44735], [-119.73516, 34.44757], [-119.73518, 34.44818], [-119.73517, 34.4484], [-119.73526, 34.44867], [-119.73549, 34.44928], [-119.73551, 34.44941], [-119.73562, 34.44964], [-119.73562, 34.44978]]]]} | Open Access 1 | 1101 | Stevens Park | 25842 | 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 | 11.199 | Stevens Park | 0 | Local Park 2 | 4 | |
6174 | 6174 | 6173 | {"type": "Polygon", "coordinates": [[[-119.67729, 34.42514], [-119.67711, 34.42531], [-119.67655, 34.42489], [-119.67674, 34.42472], [-119.67729, 34.42514]]]} | Open Access 1 | 1205 | Sunflower Park | 25994 | 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.436 | Sunflower Park | 0 | Local Park 2 | 4 | |
6197 | 6197 | 6196 | {"type": "Polygon", "coordinates": [[[-119.67538, 34.41624], [-119.67378, 34.41777], [-119.67247, 34.41684], [-119.67247, 34.41683], [-119.67538, 34.41624]]]} | Open Access 1 | 1236 | Cabrillo Bell Park | 16636 | 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 | 4.414 | Cabrillo Bell Park | 0 | Local Park 2 | 4 | |
3954 | 3954 | 3953 | {"type": "Polygon", "coordinates": [[[-119.71396, 34.40727], [-119.71154, 34.40952], [-119.70861, 34.40741], [-119.70928, 34.40652], [-119.70845, 34.40612], [-119.70889, 34.4055], [-119.70961, 34.40598], [-119.71081, 34.40655], [-119.71152, 34.40576], [-119.71396, 34.40727]]]} | Open Access 1 | 1356 | Thornbury Park | 26318 | 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 | 28.27 | Thornbury Park | 0 | Local Park 2 | 4 | |
5637 | 5637 | 5636 | {"type": "Polygon", "coordinates": [[[-119.70715, 34.42924], [-119.70617, 34.43016], [-119.70504, 34.42933], [-119.70601, 34.42841], [-119.70715, 34.42924]]]} | Open Access 1 | 1768 | Alice Keck Park Memorial Garden | 15360 | 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 | 4.663 | Alice Keck Park Memorial Garden | 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 | |
4189 | 4189 | 4188 | {"type": "Polygon", "coordinates": [[[-119.74462, 34.44971], [-119.74467, 34.45001], [-119.74464, 34.45023], [-119.74453, 34.45043], [-119.74451, 34.45056], [-119.74444, 34.45065], [-119.74425, 34.4507], [-119.74414, 34.45082], [-119.74332, 34.45033], [-119.74343, 34.45017], [-119.74362, 34.44971], [-119.74462, 34.44971]]]} | Open Access 1 | 1918 | Willowglen Park | 27592 | 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 | 2.681 | Willowglen 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 | |
8708 | 8708 | 8707 | {"type": "Polygon", "coordinates": [[[-119.67194, 34.41667], [-119.669, 34.41725], [-119.66872, 34.41728], [-119.66845, 34.41728], [-119.66817, 34.41726], [-119.66745, 34.41715], [-119.6672, 34.41714], [-119.66696, 34.41715], [-119.66476, 34.41752], [-119.66303, 34.41788], [-119.66286, 34.41796], [-119.66271, 34.41806], [-119.66258, 34.41819], [-119.66244, 34.41841], [-119.66263, 34.418], [-119.66275, 34.418], [-119.66293, 34.41764], [-119.66235, 34.41717], [-119.66236, 34.41673], [-119.66251, 34.41671], [-119.6634, 34.41653], [-119.66377, 34.41657], [-119.66411, 34.41652], [-119.66485, 34.41655], [-119.66517, 34.41651], [-119.66579, 34.41653], [-119.66637, 34.41643], [-119.66731, 34.41649], [-119.67157, 34.41641], [-119.67194, 34.41667]]]} | Open Access 1 | 14131 | East Beach | 18362 | 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.753 | East Beach | 0 | Local Park 2 | 4 | |
8735 | 8735 | 8734 | {"type": "Polygon", "coordinates": [[[-119.67798, 34.42666], [-119.67699, 34.42759], [-119.67641, 34.42717], [-119.6774, 34.42624], [-119.67798, 34.42666]]]} | Open Access 1 | 14180 | East Side Neighborhood Park | 18383 | 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 | 2.403 | East Side Neighborhood Park | 0 | Local Park 2 | 4 | |
9010 | 9010 | 9009 | {"type": "Polygon", "coordinates": [[[-119.7343, 34.41613], [-119.73406, 34.41714], [-119.73257, 34.41702], [-119.73165, 34.41638], [-119.73245, 34.41544], [-119.73233, 34.41537], [-119.7324, 34.41534], [-119.73246, 34.4153], [-119.73249, 34.41525], [-119.73251, 34.41518], [-119.7323, 34.41433], [-119.73236, 34.41425], [-119.73243, 34.41421], [-119.73249, 34.4142], [-119.73256, 34.41422], [-119.73262, 34.41427], [-119.73265, 34.41427], [-119.73287, 34.41495], [-119.73361, 34.41603], [-119.7343, 34.41613]]]} | Open Access 1 | 14915 | Elings Park | 18559 | 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 | 8.842 | Elings Park | 0 | Local Park 2 | 4 | |
9375 | 9375 | 9374 | {"type": "Polygon", "coordinates": [[[-119.72847, 34.41054], [-119.72834, 34.41074], [-119.72791, 34.41158], [-119.72565, 34.41096], [-119.72618, 34.40986], [-119.72627, 34.40989], [-119.72631, 34.40981], [-119.72847, 34.41054]]]} | Open Access 1 | 15685 | Escondido Park | 18712 | 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 | 7.274 | Escondido Park | 0 | Local Park 2 | 4 | |
9513 | 9513 | 9512 | {"type": "MultiPolygon", "coordinates": [[[[-119.69777, 34.44032], [-119.69777, 34.44084], [-119.69696, 34.44067], [-119.69697, 34.44231], [-119.69618, 34.44213], [-119.69597, 34.44191], [-119.69602, 34.4418], [-119.69605, 34.44141], [-119.69625, 34.44117], [-119.69627, 34.44112], [-119.69626, 34.44105], [-119.6962, 34.44097], [-119.69575, 34.44069], [-119.69547, 34.44062], [-119.69581, 34.44057], [-119.6959, 34.44057], [-119.6959, 34.4402], [-119.69569, 34.44015], [-119.69558, 34.44016], [-119.69546, 34.44018], [-119.69532, 34.44024], [-119.69478, 34.44055], [-119.69335, 34.44044], [-119.69273, 34.4401], [-119.69351, 34.44024], [-119.69379, 34.44013], [-119.69402, 34.4398], [-119.69447, 34.43964], [-119.69527, 34.43963], [-119.69606, 34.43974], [-119.69692, 34.43992], [-119.69777, 34.44032]]], [[[-119.69693, 34.43941], [-119.69691, 34.43942], [-119.69691, 34.43976], [-119.69613, 34.43958], [-119.6952, 34.43947], [-119.69444, 34.43947], [-119.69417, 34.43957], [-119.69416, 34.43941], [-119.69311, 34.43942], [-119.69314, 34.43877], [-119.69693, 34.43923], [-119.69693, 34.43941]]]]} | Open Access 1 | 15954 | Franceschi Park | 19043 | 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 | 16.151 | Franceschi Park | 0 | Local Park 2 | 4 | |
9782 | 9782 | 9781 | {"type": "MultiPolygon", "coordinates": [[[[-119.65321, 34.45478], [-119.65321, 34.45483], [-119.65321, 34.45564], [-119.65308, 34.45559], [-119.65289, 34.45557], [-119.65279, 34.45541], [-119.65284, 34.45523], [-119.65283, 34.45507], [-119.65296, 34.45486], [-119.65321, 34.45478]]], [[[-119.68835, 34.49092], [-119.68799, 34.49083], [-119.68751, 34.49061], [-119.68738, 34.49057], [-119.68725, 34.49055], [-119.68713, 34.49056], [-119.68702, 34.49059], [-119.68691, 34.49065], [-119.68663, 34.49093], [-119.6865, 34.49101], [-119.68643, 34.49101], [-119.68614, 34.49093], [-119.68601, 34.49091], [-119.68588, 34.49091], [-119.68575, 34.49095], [-119.68563, 34.49101], [-119.68554, 34.4911], [-119.68549, 34.49121], [-119.68546, 34.49131], [-119.68544, 34.49152], [-119.68543, 34.49182], [-119.68541, 34.4919], [-119.68538, 34.49196], [-119.68532, 34.49201], [-119.68517, 34.49207], [-119.68484, 34.49212], [-119.68473, 34.49211], [-119.68462, 34.49207], [-119.6836, 34.49155], [-119.68316, 34.49136], [-119.68287, 34.49128], [-119.68272, 34.49125], [-119.68256, 34.49124], [-119.68217, 34.49127], [-119.68208, 34.49126], [-119.68181, 34.4911], [-119.68168, 34.49107], [-119.68154, 34.49107], [-119.68142, 34.49112], [-119.68133, 34.4912], [-119.68118, 34.49147], [-119.68111, 34.49154], [-119.68092, 34.49167], [-119.68086, 34.49174], [-119.68075, 34.49207], [-119.68065, 34.49218], [-119.68049, 34.49224], [-119.68026, 34.49225], [-119.68, 34.49225], [-119.67976, 34.49222], [-119.67967, 34.49219], [-119.67959, 34.49214], [-119.67947, 34.492], [-119.67932, 34.49173], [-119.67923, 34.49163], [-119.67912, 34.49155], [-119.67899, 34.49152], [-119.67885, 34.49153], [-119.67873, 34.49158], [-119.67853, 34.49169], [-119.67843, 34.49172], [-119.67832, 34.49172], [-119.67776, 34.49166], [-119.67748, 34.49165], [-119.67728, 34.49162], [-119.67713, 34.49151], [-119.67707, 34.49143], [-119.67685, 34.49096], [-119.67678, 34.49087], [-119.67668, 34.4908], [-119.67656, 34.49078], [-119.67643, 34.49079], [-119.67587, 34.49098], [-119.67568, 34.49099], [-119.67553, 34.49094], [-119.67547, 34.49089], [-119.67518, 34.49043], [-119.67509, 34.49036], [-119.67497, 34.49033], [-119.67485, 34.49032], [-119.6746, 34.49033], [-119.67433, 34.49037], [-119.67394, 34.49046], [-119.67383, 34.49047], [-119.67373, 34.49046], [-119.67363, 34.49042], [-119.67317, 34.4902], [-119.67287, 34.49003], [-119.6728, 34.48997], [-119.67263, 34.48968], [-119.67254, 34.48958], [-119.67224, 34.48934], [-119.67185, 34.48899], [-119.67105, 34.48846], [-119.67092, 34.48841], [-119.67079, 34.48837], [-119.67065, 34.48835], [-119.67001, 34.48834], [-119.66974, 34.4884], [-119.66962, 34.48845], [-119.66918, 34.48871], [-119.66876, 34.48899], [-119.66854, 34.48908], [-119.66829, 34.48914], [-119.66759, 34.48918], [-119.66715, 34.48919], [-119.66701, 34.48918], [-119.66627, 34.48906], [-119.66613, 34.48906], [-119.666, 34.48909], [-119.66588, 34.48915], [-119.66579, 34.48923], [-119.66559, 34.48949], [-119.6654, 34.48963], [-119.66493, 34.48988], [-119.66481, 34.48993], [-119.66469, 34.48994], [-119.66442, 34.48993], [-119.66366, 34.48982], [-119.66336, 34.48974], [-119.6628, 34.48953], [-119.66265, 34.48949], [-119.66205, 34.48939], [-119.66117, 34.48914], [-119.66102, 34.48912], [-119.65991, 34.48904], [-119.65926, 34.48894], [-119.65911, 34.4889], [-119.65837, 34.48864], [-119.65806, 34.48857], [-119.65717, 34.48852], [-119.65703, 34.48854], [-119.65648, 34.48866], [-119.65621, 34.48867], [-119.65607, 34.48865], [-119.65564, 34.48854], [-119.65491, 34.48833], [-119.65462, 34.48828], [-119.65447, 34.4883], [-119.65381, 34.48854], [-119.65352, 34.48862], [-119.65352, 34.48638], [-119.65337, 34.47918], [-119.64732, 34.47923], [-119.64736, 34.46829], [-119.6428, 34.46827], [-119.64282, 34.46488], [-119.64731, 34.46487], [-119.64736, 34.4576], [-119.65243, 34.45762], [-119.65246, 34.45408], [-119.65308, 34.45409], [-119.6532, 34.45428], [-119.65319, 34.45464], [-119.65286, 34.45475], [-119.65267, 34.45502], [-119.65267, 34.45521], [-119.65263, 34.45547], [-119.65278, 34.4557], [-119.65302, 34.45571], [-119.65322, 34.45577], [-119.65323, 34.45762], [-119.65319, 34.46486], [-119.65369, 34.46488], [-119.6537, 34.46624], [-119.65975, 34.46625], [-119.65976, 34.46487], [-119.67111, 34.46469], [-119.67108, 34.4723], [-119.67109, 34.47597], [-119.67096, 34.48649], [-119.67956, 34.48655], [-119.67953, 34.49022], [-119.68834, 34.49028], [-119.68835, 34.49092]]], [[[-119.70636, 34.50775], [-119.69716, 34.50773], [-119.68837, 34.50774], [-119.67085, 34.50759], [-119.65781, 34.50764], [-119.65789, 34.50467], [-119.66233, 34.50469], [-119.66237, 34.50103], [-119.65341, 34.50097], [-119.65351, 34.49372], [-119.65352, 34.48879], [-119.65373, 34.48874], [-119.65453, 34.48846], [-119.65462, 34.48845], [-119.65486, 34.48849], [-119.65557, 34.4887], [-119.65603, 34.48881], [-119.65619, 34.48883], [-119.65651, 34.48882], [-119.65707, 34.4887], [-119.65718, 34.48869], [-119.65803, 34.48873], [-119.65829, 34.48879], [-119.65905, 34.48906], [-119.65922, 34.4891], [-119.65988, 34.48921], [-119.66112, 34.4893], [-119.66199, 34.48955], [-119.6626, 34.48965], [-119.6633, 34.48989], [-119.66361, 34.48998], [-119.66439, 34.49009], [-119.66471, 34.49011], [-119.66487, 34.49008], [-119.66502, 34.49003], [-119.66551, 34.48976], [-119.66573, 34.4896], [-119.66595, 34.48933], [-119.66601, 34.48928], [-119.66608, 34.48924], [-119.66626, 34.48922], [-119.66698, 34.48935], [-119.66714, 34.48936], [-119.6676, 34.48935], [-119.66833, 34.4893], [-119.66861, 34.48923], [-119.66887, 34.48912], [-119.6693, 34.48884], [-119.66982, 34.48855], [-119.66992, 34.48852], [-119.67014, 34.4885], [-119.67074, 34.48853], [-119.67094, 34.4886], [-119.67104, 34.48866], [-119.67171, 34.48911], [-119.67181, 34.48919], [-119.672, 34.48937], [-119.67239, 34.48968], [-119.67245, 34.48977], [-119.67264, 34.49007], [-119.67273, 34.49015], [-119.67307, 34.49034], [-119.67354, 34.49056], [-119.67368, 34.49061], [-119.67382, 34.49063], [-119.67397, 34.49062], [-119.67437, 34.49054], [-119.67463, 34.4905], [-119.67493, 34.49049], [-119.67502, 34.49053], [-119.67524, 34.49091], [-119.67531, 34.491], [-119.67541, 34.49107], [-119.67552, 34.49113], [-119.67565, 34.49115], [-119.67578, 34.49116], [-119.67592, 34.49114], [-119.67639, 34.49097], [-119.67648, 34.49095], [-119.67659, 34.49095], [-119.67667, 34.49103], [-119.6769, 34.49151], [-119.67697, 34.49161], [-119.67707, 34.4917], [-119.67719, 34.49177], [-119.67733, 34.4918], [-119.67746, 34.49182], [-119.67774, 34.49183], [-119.67831, 34.49189], [-119.67847, 34.49188], [-119.67862, 34.49184], [-119.67883, 34.49172], [-119.67891, 34.49169], [-119.67897, 34.49169], [-119.67902, 34.4917], [-119.67908, 34.49174], [-119.67914, 34.49181], [-119.67929, 34.49207], [-119.67936, 34.49217], [-119.67945, 34.49226], [-119.67957, 34.49234], [-119.67971, 34.49238], [-119.67999, 34.49241], [-119.68026, 34.49242], [-119.68053, 34.4924], [-119.68066, 34.49237], [-119.68078, 34.49231], [-119.68087, 34.49223], [-119.68094, 34.49214], [-119.68103, 34.49182], [-119.68125, 34.49166], [-119.68134, 34.49156], [-119.6815, 34.49129], [-119.68154, 34.49126], [-119.68159, 34.49124], [-119.68165, 34.49124], [-119.68172, 34.49125], [-119.68189, 34.49136], [-119.68201, 34.49142], [-119.68216, 34.49144], [-119.68256, 34.4914], [-119.68269, 34.49141], [-119.68308, 34.49152], [-119.6835, 34.49169], [-119.68453, 34.49222], [-119.68468, 34.49227], [-119.68484, 34.49228], [-119.68523, 34.49223], [-119.68535, 34.49219], [-119.68545, 34.49214], [-119.68554, 34.49205], [-119.6856, 34.49195], [-119.68563, 34.49184], [-119.68564, 34.49153], [-119.68568, 34.49125], [-119.68572, 34.49119], [-119.68583, 34.4911], [-119.686, 34.49107], [-119.68641, 34.49118], [-119.68655, 34.49117], [-119.68668, 34.49112], [-119.68678, 34.49105], [-119.68704, 34.49078], [-119.68711, 34.49074], [-119.68724, 34.49071], [-119.68742, 34.49076], [-119.68791, 34.49098], [-119.68817, 34.49106], [-119.68836, 34.49109], [-119.68841, 34.4938], [-119.6884, 34.4973], [-119.70601, 34.49744], [-119.70608, 34.50095], [-119.70636, 34.50775]]]]} | Open Access 1 | 16652 | Gould Park | 11707 | 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 | http://www.placesonline.com/north_america/united_states/california/santa_barbara/parks_and_gardens/gould_park.asp | Santa Barbara 7 | 3420.055 | Gould 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]);