units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
39 rows where DES_TP = 2, MNG_AGENCY = 26 and MNG_AG_TYP = 2 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
10547 | 10547 | 10546 | {"type": "Polygon", "coordinates": [[[-119.71388, 34.41721], [-119.71339, 34.41767], [-119.71312, 34.41748], [-119.71262, 34.41794], [-119.71134, 34.41701], [-119.71188, 34.41649], [-119.71202, 34.41659], [-119.71201, 34.41661], [-119.71215, 34.41671], [-119.71209, 34.41678], [-119.71222, 34.41688], [-119.71221, 34.41691], [-119.71233, 34.417], [-119.7124, 34.41695], [-119.71296, 34.41736], [-119.71345, 34.41689], [-119.71388, 34.41721]]]} | Open Access 1 | 18761 | Bohnett Park | 16234 | 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.582 | Bohnett Park | 0 | Local Park 2 | 4 | |
10373 | 10373 | 10372 | {"type": "MultiPolygon", "coordinates": [[[[-119.70584, 34.4382], [-119.70455, 34.43838], [-119.70355, 34.43837], [-119.70346, 34.43833], [-119.70343, 34.43825], [-119.70343, 34.43822], [-119.7035, 34.43807], [-119.70359, 34.43794], [-119.70368, 34.43787], [-119.70382, 34.43784], [-119.70584, 34.4382]]], [[[-119.70624, 34.43759], [-119.70606, 34.43805], [-119.70399, 34.43771], [-119.70396, 34.43769], [-119.70395, 34.43765], [-119.70396, 34.4376], [-119.7044, 34.43724], [-119.70495, 34.43742], [-119.70575, 34.43752], [-119.70576, 34.43759], [-119.70624, 34.43759]]]]} | Open Access 1 | 18313 | Orpet Park | 23223 | 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.385 | Orpet 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 | |
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 | |
10376 | 10376 | 10375 | {"type": "Polygon", "coordinates": [[[-119.69114, 34.42502], [-119.69001, 34.42608], [-119.68889, 34.42526], [-119.69003, 34.42419], [-119.69114, 34.42502]]]} | Open Access 1 | 18317 | Ortega Park | 23226 | 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 | 5.35 | Ortega Park | 0 | Local Park 2 | 4 | |
2769 | 2769 | 2768 | {"type": "Polygon", "coordinates": [[[-119.69755, 34.409], [-119.6969, 34.40961], [-119.69661, 34.4094], [-119.69628, 34.40971], [-119.69508, 34.40884], [-119.69608, 34.40791], [-119.69755, 34.409]]]} | Open Access 1 | 18496 | Pershing Park | 23618 | 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 | 5.763 | Pershing Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
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 | |
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 | |
10260 | 10260 | 10259 | {"type": "MultiPolygon", "coordinates": [[[[-119.70586, 34.4283], [-119.7049, 34.42922], [-119.70377, 34.4284], [-119.70473, 34.42748], [-119.70586, 34.4283]]], [[[-119.707, 34.42723], [-119.70599, 34.42818], [-119.70487, 34.42735], [-119.70587, 34.4264], [-119.707, 34.42723]]]]} | Open Access 1 | 17974 | Alameda Park | 15313 | 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.404 | Alameda 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]);