units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where DES_TP = 2 and MNG_AGENCY = 35 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME
MNG_AG_TYP 1
- City Agency 26
MNG_AGENCY 1
- Santa Maria, City of · 26 ✖
DES_TP 1
- Local Park · 26 ✖
ACCESS_TYP 1
- Open Access 26
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14590 | 14590 | 14589 | {"type": "MultiPolygon", "coordinates": [[[[-120.42519, 34.92072], [-120.42518, 34.92081], [-120.4251, 34.92088], [-120.42504, 34.92091], [-120.42487, 34.92093], [-120.42463, 34.92091], [-120.42386, 34.92077], [-120.42379, 34.91981], [-120.42411, 34.92026], [-120.42432, 34.92045], [-120.42448, 34.92054], [-120.42466, 34.92061], [-120.42519, 34.92072]]], [[[-120.42515, 34.92046], [-120.42477, 34.92038], [-120.42463, 34.92033], [-120.42451, 34.92026], [-120.42434, 34.9201], [-120.42406, 34.9197], [-120.42511, 34.91967], [-120.42515, 34.92046]]]]} | Open Access 1 | 48289 | Fletcher Park | 32863 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | https://www.cityofsantamaria.org/city-government/departments/recreation-and-parks/visit-your-parks/view-park-photos-descriptions#Fletcher%20Park | Santa Barbara 7 | 2.826 | Fletcher Park | 0 | Local Park 2 | 4 |
2322 | 2322 | 2321 | {"type": "Polygon", "coordinates": [[[-120.41405, 34.94728], [-120.41399, 34.94763], [-120.41355, 34.94784], [-120.41373, 34.94805], [-120.4137, 34.94807], [-120.4134, 34.94791], [-120.41323, 34.94798], [-120.41293, 34.94826], [-120.41288, 34.94824], [-120.41301, 34.94796], [-120.41262, 34.94792], [-120.41232, 34.94771], [-120.41241, 34.94762], [-120.41262, 34.94748], [-120.41285, 34.94737], [-120.41297, 34.94733], [-120.41322, 34.94729], [-120.41378, 34.94726], [-120.41405, 34.94728]]]} | Open Access 1 | 17035 | Joe White Park | 20423 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 2.303 | Joe White Park | 0 | Local Park 2 | 4 | |
454 | 454 | 453 | {"type": "Polygon", "coordinates": [[[-120.41539, 34.9625], [-120.41538, 34.96297], [-120.41382, 34.96295], [-120.41381, 34.96389], [-120.41248, 34.96388], [-120.41249, 34.96273], [-120.41339, 34.96275], [-120.4134, 34.96267], [-120.41373, 34.96267], [-120.41374, 34.96248], [-120.41539, 34.9625]]]} | Open Access 1 | 1454 | Tunnell Park | 26577 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 5.767 | Tunnell Park | 0 | Local Park 2 | 4 | |
12078 | 12078 | 12077 | {"type": "Polygon", "coordinates": [[[-120.42155, 34.95464], [-120.42153, 34.95612], [-120.42074, 34.95611], [-120.42072, 34.95641], [-120.42065, 34.95641], [-120.42065, 34.95606], [-120.42072, 34.95605], [-120.42072, 34.95476], [-120.421, 34.95476], [-120.42119, 34.95474], [-120.42144, 34.95468], [-120.42155, 34.95464]]]} | Open Access 1 | 24849 | Armstrong Park | 15596 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 2.911 | Armstrong Park | 0 | Local Park 2 | 4 | |
5594 | 5594 | 5593 | {"type": "Polygon", "coordinates": [[[-120.42701, 34.97493], [-120.42406, 34.97488], [-120.42406, 34.97395], [-120.42418, 34.97395], [-120.42422, 34.97386], [-120.42662, 34.97474], [-120.42701, 34.97493]]]} | Open Access 1 | 48890 | Jim May Park | 33608 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | https://www.cityofsantamaria.org/city-government/departments/recreation-and-parks/visit-your-parks/view-park-photos-descriptions#Jim%20May%20Park | Santa Barbara 7 | 4.071 | Jim May Park | 0 | Local Park 2 | 4 |
504 | 504 | 503 | {"type": "Polygon", "coordinates": [[[-120.42711, 34.97493], [-120.42701, 34.97493], [-120.42662, 34.97474], [-120.42536, 34.97428], [-120.42559, 34.97429], [-120.42578, 34.97425], [-120.42594, 34.97418], [-120.42604, 34.97412], [-120.42632, 34.97403], [-120.42638, 34.97398], [-120.42641, 34.9739], [-120.42648, 34.97388], [-120.42711, 34.97493]]]} | Open Access 1 | 48891 | Jim May Park | 33608 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | https://www.cityofsantamaria.org/city-government/departments/recreation-and-parks/visit-your-parks/view-park-photos-descriptions#Jim%20May%20Park | Santa Barbara 7 | 1.57 | Jim May Park | 0 | Local Park 2 | 4 |
4017 | 4017 | 4016 | {"type": "Polygon", "coordinates": [[[-120.42732, 34.97528], [-120.42699, 34.97526], [-120.42685, 34.97536], [-120.42682, 34.97661], [-120.42664, 34.97662], [-120.42664, 34.97691], [-120.42404, 34.97697], [-120.42397, 34.97488], [-120.42711, 34.97493], [-120.42732, 34.97528]]]} | Open Access 1 | 48887 | Jim May Park | 33608 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | https://www.cityofsantamaria.org/city-government/departments/recreation-and-parks/visit-your-parks/view-park-photos-descriptions#Jim%20May%20Park | Santa Barbara 7 | 14.607 | Jim May Park | 0 | Local Park 2 | 4 |
14316 | 14316 | 14315 | {"type": "Polygon", "coordinates": [[[-120.42735, 34.90903], [-120.42735, 34.90909], [-120.42706, 34.90914], [-120.42679, 34.90928], [-120.42667, 34.9093], [-120.42662, 34.90934], [-120.42659, 34.90939], [-120.42658, 34.90946], [-120.4266, 34.9095], [-120.42666, 34.90955], [-120.42676, 34.90958], [-120.42681, 34.90964], [-120.42687, 34.90985], [-120.42686, 34.91008], [-120.42682, 34.91013], [-120.42677, 34.91014], [-120.42642, 34.91004], [-120.42574, 34.90993], [-120.42563, 34.90995], [-120.42555, 34.91002], [-120.42552, 34.91011], [-120.4256, 34.91064], [-120.42562, 34.91174], [-120.42566, 34.91186], [-120.42572, 34.91196], [-120.42483, 34.91231], [-120.42424, 34.91125], [-120.42413, 34.91101], [-120.42406, 34.91076], [-120.42401, 34.9105], [-120.424, 34.91033], [-120.424, 34.90909], [-120.42409, 34.90902], [-120.42735, 34.90903]]]} | Open Access 1 | 44279 | Rotary Centennial Park | 24684 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 14.36 | Rotary Centennial Park | 0 | Local Park 2 | 4 | |
5050 | 5050 | 5049 | {"type": "Polygon", "coordinates": [[[-120.42771, 34.96444], [-120.42771, 34.96515], [-120.42677, 34.96515], [-120.42676, 34.96512], [-120.42581, 34.96512], [-120.42581, 34.9647], [-120.42612, 34.9647], [-120.42612, 34.96443], [-120.42677, 34.96443], [-120.42678, 34.96471], [-120.42743, 34.96472], [-120.42768, 34.96471], [-120.42768, 34.96444], [-120.42771, 34.96444]]]} | Open Access 1 | 23 | Rice Park | 24318 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 2.488 | Rice Park | 0 | Local Park 2 | 4 | |
9611 | 9611 | 9610 | {"type": "Polygon", "coordinates": [[[-120.42789, 34.94443], [-120.42481, 34.9444], [-120.42478, 34.94205], [-120.42786, 34.94209], [-120.42789, 34.94443]]]} | Open Access 1 | 47985 | Alice Threfts Park | 15362 | 2421 | Allan Hancock Community College District 917 | Special District 4 | School District 14 | https://www.hancockcollege.edu/ | Special District 4 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 18.102 | Alice Threfts Park | 0 | Local Park 2 | 4 | |
6499 | 6499 | 6498 | {"type": "Polygon", "coordinates": [[[-120.42879, 34.94211], [-120.42872, 34.94444], [-120.42789, 34.94443], [-120.42786, 34.94209], [-120.42879, 34.94211]]]} | Open Access 1 | 2371 | Alice Threfts Park | 15362 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 5.183 | Alice Threfts Park | 0 | Local Park 2 | 4 | |
9792 | 9792 | 9791 | {"type": "Polygon", "coordinates": [[[-120.43176, 34.90913], [-120.43175, 34.90987], [-120.43102, 34.91013], [-120.43089, 34.91004], [-120.42964, 34.90962], [-120.42954, 34.90957], [-120.4294, 34.90947], [-120.4293, 34.90934], [-120.42923, 34.90918], [-120.42921, 34.90902], [-120.43161, 34.90903], [-120.43161, 34.90913], [-120.43176, 34.90913]]]} | Open Access 1 | 16775 | Harvest Ranch Park | 19725 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 5.086 | Harvest Ranch Park | 0 | Local Park 2 | 4 | |
248 | 248 | 247 | {"type": "Polygon", "coordinates": [[[-120.43425, 34.94713], [-120.43423, 34.94857], [-120.43412, 34.94857], [-120.43412, 34.94888], [-120.43362, 34.94888], [-120.43362, 34.94858], [-120.4336, 34.94857], [-120.4336, 34.94842], [-120.43368, 34.94841], [-120.43368, 34.94824], [-120.43331, 34.94824], [-120.4333, 34.94838], [-120.43282, 34.94838], [-120.43281, 34.94836], [-120.43157, 34.94835], [-120.43157, 34.94625], [-120.43274, 34.94627], [-120.43274, 34.94713], [-120.43425, 34.94713]]]} | Open Access 1 | 811 | Simas Basin Park | 25503 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 11.392 | Simas Basin Park | 0 | Local Park 2 | 4 | |
6813 | 6813 | 6812 | {"type": "Polygon", "coordinates": [[[-120.43563, 34.95389], [-120.43489, 34.95388], [-120.43488, 34.95422], [-120.43461, 34.95436], [-120.4346, 34.9544], [-120.43463, 34.95452], [-120.43452, 34.95459], [-120.43435, 34.95459], [-120.43431, 34.9546], [-120.43429, 34.95463], [-120.43429, 34.95474], [-120.43424, 34.95476], [-120.43424, 34.95481], [-120.43421, 34.95484], [-120.43413, 34.95484], [-120.43404, 34.95481], [-120.43401, 34.95483], [-120.43375, 34.95484], [-120.43375, 34.95496], [-120.43368, 34.95499], [-120.43372, 34.95503], [-120.43373, 34.95508], [-120.43363, 34.95512], [-120.43359, 34.95517], [-120.43358, 34.95522], [-120.43291, 34.95522], [-120.43286, 34.9552], [-120.43287, 34.95487], [-120.43288, 34.95486], [-120.4329, 34.95486], [-120.43293, 34.95488], [-120.43294, 34.95502], [-120.43318, 34.95502], [-120.43319, 34.95509], [-120.43346, 34.95509], [-120.43347, 34.95493], [-120.43349, 34.95489], [-120.43359, 34.95485], [-120.43376, 34.95471], [-120.43393, 34.95461], [-120.43397, 34.95454], [-120.43397, 34.95446], [-120.434, 34.95444], [-120.434, 34.9544], [-120.43402, 34.95437], [-120.43406, 34.95435], [-120.43422, 34.95434], [-120.43424, 34.95431], [-120.43425, 34.95422], [-120.43432, 34.95417], [-120.43434, 34.95413], [-120.43438, 34.95413], [-120.4344, 34.95412], [-120.43446, 34.95414], [-120.43457, 34.95409], [-120.43458, 34.95406], [-120.43457, 34.95387], [-120.4346, 34.95376], [-120.43488, 34.95375], [-120.43489, 34.95329], [-120.43559, 34.95328], [-120.43562, 34.9533], [-120.43564, 34.95333], [-120.43563, 34.95389]]]} | Open Access 1 | 5381 | Central Plaza Park | 17071 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 2.876 | Central Plaza Park | 0 | Local Park 2 | 4 | |
10172 | 10172 | 10171 | {"type": "Polygon", "coordinates": [[[-120.43979, 34.95762], [-120.43978, 34.95844], [-120.43764, 34.95842], [-120.43765, 34.9576], [-120.43979, 34.95762]]]} | Open Access 1 | 17751 | Mem Park | 22115 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 4.408 | Mem Park | 0 | Local Park 2 | 4 | |
2644 | 2644 | 2643 | {"type": "Polygon", "coordinates": [[[-120.43985, 34.98228], [-120.43978, 34.98591], [-120.43553, 34.98588], [-120.43551, 34.98453], [-120.43552, 34.98379], [-120.43542, 34.98223], [-120.43985, 34.98228]]]} | Open Access 1 | 18812 | Preisker Park | 23981 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 39.341 | Preisker Park | 0 | Local Park 2 | 4 | |
352 | 352 | 351 | {"type": "Polygon", "coordinates": [[[-120.44058, 34.94325], [-120.44056, 34.94446], [-120.43923, 34.94444], [-120.43925, 34.94324], [-120.44058, 34.94325]]]} | Open Access 1 | 971 | Buena Vista Park | 16495 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 4.028 | Buena Vista Park | 0 | Local Park 2 | 4 | |
6110 | 6110 | 6109 | {"type": "Polygon", "coordinates": [[[-120.44331, 34.9147], [-120.44255, 34.91469], [-120.44185, 34.91468], [-120.44191, 34.91442], [-120.44199, 34.91428], [-120.44206, 34.9142], [-120.44219, 34.9141], [-120.44229, 34.91406], [-120.4425, 34.91403], [-120.44277, 34.91403], [-120.44287, 34.91405], [-120.44297, 34.91409], [-120.4431, 34.91418], [-120.44318, 34.91425], [-120.44326, 34.91439], [-120.44331, 34.91454], [-120.44331, 34.9147]]]} | Open Access 1 | 1061 | Stanley Park | 25789 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 1.977 | Stanley Park | 0 | Local Park 2 | 4 | |
2277 | 2277 | 2276 | {"type": "Polygon", "coordinates": [[[-120.44439, 34.96239], [-120.44437, 34.96412], [-120.44295, 34.96411], [-120.44294, 34.96238], [-120.44439, 34.96239]]]} | Open Access 1 | 16836 | Atkinson Park | 15673 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 6.223 | Atkinson Park | 0 | Local Park 2 | 4 | |
5591 | 5591 | 5590 | {"type": "Polygon", "coordinates": [[[-120.44491, 34.93156], [-120.4448, 34.93855], [-120.44326, 34.93845], [-120.44308, 34.93845], [-120.44309, 34.93816], [-120.44323, 34.938], [-120.44324, 34.93653], [-120.44338, 34.93652], [-120.44338, 34.93626], [-120.4439, 34.93624], [-120.4439, 34.93474], [-120.44224, 34.93471], [-120.44225, 34.93199], [-120.44215, 34.93196], [-120.44216, 34.93144], [-120.44472, 34.93148], [-120.44473, 34.93155], [-120.44491, 34.93156]]]} | Open Access 1 | 14105 | Adam Park/Minami Park | 15255 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 34.301 | Adam Park/Minami 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]);