units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where MNG_AGENCY = 26 sorted by LAYER
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2810 | 2810 | 2809 | {"type": "Polygon", "coordinates": [[[-119.69855, 34.4095], [-119.69842, 34.40964], [-119.69608, 34.40791], [-119.69508, 34.40884], [-119.69458, 34.40847], [-119.69487, 34.4083], [-119.69505, 34.40813], [-119.69526, 34.40776], [-119.69509, 34.40772], [-119.69496, 34.40802], [-119.69475, 34.40822], [-119.69446, 34.40838], [-119.69407, 34.4081], [-119.69422, 34.40794], [-119.69435, 34.40773], [-119.69444, 34.4075], [-119.69448, 34.40738], [-119.69474, 34.40743], [-119.69492, 34.40763], [-119.6955, 34.40754], [-119.6957, 34.40752], [-119.69614, 34.40772], [-119.69676, 34.40788], [-119.69747, 34.40846], [-119.69826, 34.40917], [-119.6982, 34.40924], [-119.69855, 34.4095]]]} | Open Access 1 | 18644 | Plaza del Mar Park | 23779 | 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.277 | Plaza del Mar 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 | |
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 | |
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 | |
4946 | 4946 | 4945 | {"type": "Polygon", "coordinates": [[[-119.7272, 34.4336], [-119.72698, 34.43445], [-119.72664, 34.43545], [-119.72639, 34.43526], [-119.72657, 34.43483], [-119.72679, 34.43462], [-119.72695, 34.43445], [-119.72702, 34.43416], [-119.72681, 34.43413], [-119.72683, 34.43397], [-119.72706, 34.43399], [-119.72716, 34.43359], [-119.7272, 34.4336]]]} | Unknown Access 4 | 14659 | El Mission Creek | 18514 | 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.719 | El Mission Creek | 0 | Local Other or Unknown 14 | 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 | |
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 | ||
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 | |
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 | |
8645 | 8645 | 8644 | {"type": "Polygon", "coordinates": [[[-119.84198, 34.43602], [-119.84029, 34.43629], [-119.84059, 34.43759], [-119.83711, 34.43794], [-119.8371, 34.43824], [-119.83253, 34.43871], [-119.83248, 34.43844], [-119.83238, 34.43817], [-119.83224, 34.43792], [-119.83216, 34.43781], [-119.83206, 34.4377], [-119.83185, 34.43751], [-119.8314, 34.43726], [-119.83139, 34.43653], [-119.83079, 34.43653], [-119.83079, 34.43627], [-119.83084, 34.43621], [-119.8316, 34.43584], [-119.83163, 34.43585], [-119.83209, 34.43564], [-119.83212, 34.43565], [-119.83313, 34.4352], [-119.83403, 34.43483], [-119.83675, 34.43411], [-119.84127, 34.43296], [-119.84152, 34.43404], [-119.84073, 34.43425], [-119.83908, 34.43451], [-119.83912, 34.43479], [-119.83853, 34.43491], [-119.83884, 34.43629], [-119.84193, 34.4358], [-119.84198, 34.43602]]]} | Restricted Access 2 | 1483 | Twin Lakes Golf Course | 32998 | 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 | 81.664 | Twin Lakes GC | 0 | Local Recreation Area 3 | 4 | |
8687 | 8687 | 8686 | {"type": "MultiPolygon", "coordinates": [[[[-119.67017, 34.41907], [-119.66916, 34.41999], [-119.66802, 34.41916], [-119.66813, 34.41909], [-119.66819, 34.41908], [-119.66824, 34.41909], [-119.66837, 34.41922], [-119.6685, 34.4191], [-119.66837, 34.41896], [-119.66827, 34.41881], [-119.66819, 34.41851], [-119.66799, 34.41803], [-119.668, 34.41799], [-119.66805, 34.41796], [-119.66831, 34.41797], [-119.66916, 34.41832], [-119.67017, 34.41907]]], [[[-119.67083, 34.41956], [-119.67083, 34.41956], [-119.66952, 34.41992], [-119.67032, 34.41918], [-119.67083, 34.41956]]], [[[-119.67046, 34.4188], [-119.6703, 34.41894], [-119.6697, 34.41849], [-119.67033, 34.41874], [-119.67046, 34.4188]]], [[[-119.67166, 34.41932], [-119.67104, 34.4195], [-119.67046, 34.41906], [-119.67064, 34.41889], [-119.67166, 34.41932]]]]} | Open Access 1 | 14048 | Dwight Murphy Field | 18326 | 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.685 | Dwight Murphy Field | 0 | Local Recreation Area 3 | 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 | |
9105 | 9105 | 9104 | {"type": "Polygon", "coordinates": [[[-119.66149, 34.43582], [-119.6613, 34.43592], [-119.66056, 34.43591], [-119.66024, 34.43602], [-119.65968, 34.43602], [-119.65934, 34.43618], [-119.65904, 34.43601], [-119.65885, 34.43601], [-119.65652, 34.4347], [-119.6564, 34.43449], [-119.65633, 34.43428], [-119.65646, 34.43417], [-119.65655, 34.43403], [-119.65657, 34.43391], [-119.65657, 34.43343], [-119.65695, 34.43342], [-119.6577, 34.43379], [-119.65812, 34.43422], [-119.65823, 34.4345], [-119.65885, 34.43497], [-119.65907, 34.4351], [-119.6598, 34.43512], [-119.66101, 34.43551], [-119.66149, 34.43582]]]} | Open Access 1 | 16721 | Hale Park | 19604 | 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 | 12.798 | Hale 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 |
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]);