units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where MNG_AGENCY = 26 sorted by ACCESS_TYP
This data as json, copyable, CSV (advanced)
DES_TP 7
- Local Park 20
- Local Other or Unknown 11
- Local Recreation Area 8
- Local Conservation Area 2
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 44
MNG_AGENCY 1
- Santa Barbara, City of · 44 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 |
9866 | 9866 | 9865 | {"type": "Polygon", "coordinates": [[[-119.72501, 34.41157], [-119.72523, 34.41174], [-119.72525, 34.4118], [-119.72524, 34.41189], [-119.72517, 34.41196], [-119.725, 34.41202], [-119.72498, 34.41201], [-119.72474, 34.41246], [-119.72467, 34.4125], [-119.72461, 34.41249], [-119.72448, 34.41204], [-119.72439, 34.41189], [-119.72486, 34.41146], [-119.72501, 34.41157]]]} | Open Access 1 | 16899 | Hilda Ray Park | 19957 | 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.126 | Hilda Ray Park | 0 | Local Park 2 | 4 | |
9957 | 9957 | 9956 | {"type": "Polygon", "coordinates": [[[-119.71792, 34.40505], [-119.71754, 34.40566], [-119.71711, 34.40547], [-119.71658, 34.40556], [-119.71599, 34.40633], [-119.71585, 34.40616], [-119.71579, 34.4061], [-119.71571, 34.40607], [-119.7156, 34.40605], [-119.71379, 34.40496], [-119.71548, 34.40414], [-119.71691, 34.40345], [-119.71722, 34.40332], [-119.71755, 34.40488], [-119.71792, 34.40505]]]} | Open Access 1 | 17135 | La Coronilla Park | 20750 | 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 | 14.793 | La Coronilla Park | 0 | Local Park 2 | 4 | |
9968 | 9968 | 9967 | {"type": "Polygon", "coordinates": [[[-119.72462, 34.39825], [-119.72456, 34.39841], [-119.72452, 34.39858], [-119.72232, 34.39894], [-119.72233, 34.3985], [-119.72231, 34.39835], [-119.72226, 34.39817], [-119.72215, 34.3979], [-119.72205, 34.39774], [-119.72187, 34.39752], [-119.72174, 34.39738], [-119.72176, 34.39724], [-119.72165, 34.39716], [-119.71991, 34.39689], [-119.71978, 34.39623], [-119.7212, 34.39605], [-119.72168, 34.39596], [-119.72233, 34.39574], [-119.72282, 34.39565], [-119.72329, 34.39562], [-119.72326, 34.39578], [-119.72331, 34.39588], [-119.72348, 34.39599], [-119.72326, 34.39624], [-119.72326, 34.3964], [-119.72314, 34.39669], [-119.72343, 34.39699], [-119.7235, 34.39716], [-119.72371, 34.39743], [-119.72394, 34.39757], [-119.72399, 34.39772], [-119.72424, 34.39786], [-119.72448, 34.39785], [-119.72448, 34.39805], [-119.72462, 34.39825]]]} | Open Access 1 | 17144 | La Mesa Park | 20773 | 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.698 | La Mesa Park | 0 | Local Park 2 | 4 | |
10028 | 10028 | 10027 | {"type": "MultiPolygon", "coordinates": [[[[-119.72885, 34.45108], [-119.72869, 34.45118], [-119.72808, 34.45176], [-119.72821, 34.45247], [-119.72822, 34.4527], [-119.72775, 34.45265], [-119.72654, 34.45155], [-119.72624, 34.45093], [-119.72629, 34.45059], [-119.72885, 34.45108]]], [[[-119.7298, 34.45232], [-119.72966, 34.45236], [-119.72946, 34.45246], [-119.7293, 34.4526], [-119.72922, 34.45272], [-119.72913, 34.45293], [-119.72897, 34.45366], [-119.72882, 34.45333], [-119.72917, 34.45262], [-119.72938, 34.45233], [-119.7298, 34.45232]]], [[[-119.73102, 34.45204], [-119.73085, 34.45212], [-119.7306, 34.45217], [-119.73094, 34.45203], [-119.73102, 34.45204]]], [[[-119.73489, 34.45026], [-119.73432, 34.45069], [-119.73426, 34.4512], [-119.73445, 34.45128], [-119.73436, 34.45153], [-119.7337, 34.45212], [-119.73371, 34.45213], [-119.73403, 34.45213], [-119.73401, 34.45256], [-119.73401, 34.45385], [-119.73131, 34.45385], [-119.73197, 34.4526], [-119.73258, 34.45262], [-119.73345, 34.45095], [-119.73391, 34.45045], [-119.73409, 34.45008], [-119.73489, 34.45026]]]]} | Open Access 1 | 17290 | Lauro Canyon Reservoir | 33320 | 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 | 21.132 | Lauro Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
10030 | 10030 | 10029 | {"type": "Polygon", "coordinates": [[[-119.70263, 34.39947], [-119.70218, 34.40017], [-119.70064, 34.40169], [-119.69974, 34.40255], [-119.69913, 34.40289], [-119.69882, 34.40299], [-119.69812, 34.4031], [-119.69762, 34.4031], [-119.69708, 34.40307], [-119.69699, 34.40296], [-119.69685, 34.40286], [-119.69669, 34.4028], [-119.69653, 34.40279], [-119.69499, 34.40303], [-119.69444, 34.40258], [-119.69516, 34.4027], [-119.69996, 34.40125], [-119.70201, 34.40009], [-119.70247, 34.39937], [-119.70263, 34.39947]]]} | Open Access 1 | 17322 | Leadbetter Beach | 21125 | 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 | 15.841 | Leadbetter Beach | 0 | Local Park 2 | 4 | |
10085 | 10085 | 10084 | {"type": "Polygon", "coordinates": [[[-119.73402, 34.43961], [-119.73313, 34.43967], [-119.7328, 34.43975], [-119.73263, 34.43981], [-119.73234, 34.43995], [-119.73188, 34.44027], [-119.73082, 34.44026], [-119.7306, 34.44024], [-119.73006, 34.44013], [-119.73269, 34.43879], [-119.73244, 34.43842], [-119.73358, 34.43784], [-119.73362, 34.43784], [-119.73362, 34.43833], [-119.73392, 34.43888], [-119.73402, 34.43913], [-119.73402, 34.43961]]]} | Open Access 1 | 17507 | Mackenzie Park | 21636 | 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 | 9.591 | Mackenzie 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]);