units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where MNG_AGENCY = 35 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, PARK_URL, LABEL_NAME
DES_TP 5
LAYER 3 ✖
- City 35
- Special District 2
- County 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 38
MNG_AGENCY 1
- Santa Maria, City of · 38 ✖
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 |
14580 | 14580 | 14579 | {"type": "Polygon", "coordinates": [[[-120.42858, 34.92107], [-120.42838, 34.92118], [-120.4282, 34.92135], [-120.42815, 34.92137], [-120.42777, 34.92127], [-120.42747, 34.92122], [-120.42583, 34.9211], [-120.42574, 34.92107], [-120.42569, 34.92102], [-120.42563, 34.92091], [-120.42554, 34.92065], [-120.42551, 34.92051], [-120.42549, 34.92037], [-120.42543, 34.91899], [-120.4272, 34.91903], [-120.42719, 34.92015], [-120.42858, 34.92016], [-120.42858, 34.92107]]]} | Restricted Access 2 | 48290 | Crossroads Open Space | 32864 | 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 | 12.815 | Crossroads OS | 0 | Local Recreation Area 3 | 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 | |
13995 | 13995 | 13994 | {"type": "Polygon", "coordinates": [[[-120.42993, 34.90438], [-120.4295, 34.90438], [-120.42947, 34.90435], [-120.42977, 34.90426], [-120.42978, 34.90425], [-120.42937, 34.90377], [-120.42935, 34.90377], [-120.42911, 34.90347], [-120.42901, 34.90343], [-120.42909, 34.90341], [-120.42993, 34.90438]]]} | Open Access 1 | 36679 | Santa Maria holding 6 | 25110 | 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 | 0.176 | Santa Maria holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13338 | 13338 | 13337 | {"type": "Polygon", "coordinates": [[[-120.42896, 34.90324], [-120.42894, 34.90328], [-120.42891, 34.9033], [-120.4289, 34.9032], [-120.42866, 34.90294], [-120.42867, 34.90293], [-120.42842, 34.90265], [-120.42813, 34.90282], [-120.42786, 34.90269], [-120.42786, 34.90235], [-120.4282, 34.90235], [-120.42896, 34.90324]]]} | Open Access 1 | 35416 | Santa Maria holding 2 | 25106 | 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 | 0.528 | Santa Maria holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13337 | 13337 | 13336 | {"type": "Polygon", "coordinates": [[[-120.44339, 34.91651], [-120.4434, 34.91658], [-120.44338, 34.91661], [-120.44335, 34.91662], [-120.44129, 34.9166], [-120.4413, 34.91649], [-120.44339, 34.91651]]]} | Open Access 1 | 35414 | Santa Maria holding 4 | 25108 | 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 | 0.606 | Santa Maria holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13336 | 13336 | 13335 | {"type": "Polygon", "coordinates": [[[-120.44198, 34.91627], [-120.44198, 34.91649], [-120.44191, 34.91649], [-120.44191, 34.91632], [-120.44193, 34.91628], [-120.44198, 34.91627]]]} | Open Access 1 | 35413 | Santa Maria holding 3 | 25107 | 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 | 0.034 | Santa Maria holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13304 | 13304 | 13303 | {"type": "Polygon", "coordinates": [[[-120.43154, 34.92528], [-120.43151, 34.92642], [-120.43149, 34.92645], [-120.43145, 34.92647], [-120.4311, 34.92646], [-120.43107, 34.92642], [-120.4311, 34.92527], [-120.43154, 34.92528]]]} | Open Access 1 | 35366 | Santa Maria holding 1 | 25104 | 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.315 | Santa Maria holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13265 | 13265 | 13264 | {"type": "Polygon", "coordinates": [[[-120.44479, 34.91652], [-120.44479, 34.91663], [-120.44368, 34.91662], [-120.44363, 34.91659], [-120.44361, 34.9165], [-120.44479, 34.91652]]]} | Open Access 1 | 35314 | Santa Maria holding 9 | 25113 | 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 | 0.341 | Santa Maria holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13264 | 13264 | 13263 | {"type": "Polygon", "coordinates": [[[-120.46379, 34.92368], [-120.46378, 34.92427], [-120.46375, 34.9243], [-120.46307, 34.92428], [-120.46307, 34.92402], [-120.46315, 34.92397], [-120.4632, 34.92388], [-120.46317, 34.92363], [-120.46378, 34.92363], [-120.46379, 34.92368]]]} | Open Access 1 | 35312 | Santa Maria holding 10 | 25105 | 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.082 | Santa Maria holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13238 | 13238 | 13237 | {"type": "Polygon", "coordinates": [[[-120.43155, 34.93228], [-120.43146, 34.93389], [-120.43143, 34.93393], [-120.43138, 34.93394], [-120.43103, 34.93389], [-120.431, 34.93385], [-120.431, 34.93354], [-120.43109, 34.93282], [-120.43112, 34.93227], [-120.43155, 34.93228]]]} | Open Access 1 | 35282 | Santa Maria holding 8 | 25112 | 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.838 | Santa Maria holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13216 | 13216 | 13215 | {"type": "Polygon", "coordinates": [[[-120.41587, 34.97214], [-120.4158, 34.97224], [-120.41559, 34.97213], [-120.41511, 34.97201], [-120.41521, 34.97161], [-120.41526, 34.97159], [-120.41582, 34.9716], [-120.41587, 34.97214]]]} | Open Access 1 | 35255 | Santa Maria holding 7 | 25111 | 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 | 0.886 | Santa Maria holding 7 | 0 | Local Other or Unknown 14 | 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 | |
10491 | 10491 | 10490 | {"type": "Polygon", "coordinates": [[[-120.45392, 34.87874], [-120.45391, 34.87958], [-120.45361, 34.87957], [-120.45361, 34.87874], [-120.45392, 34.87874]]]} | Open Access 1 | 18588 | Pioneer Park | 23733 | 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 | 0.643 | Pioneer 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 | |
10115 | 10115 | 10114 | {"type": "Polygon", "coordinates": [[[-120.43082, 34.90777], [-120.43082, 34.90903], [-120.42927, 34.90902], [-120.42927, 34.90789], [-120.4297, 34.90776], [-120.42989, 34.90768], [-120.43021, 34.90763], [-120.43052, 34.90766], [-120.43082, 34.90777]]]} | Open Access 1 | 17570 | Maramonte Park (North) | 21788 | 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.088 | Maramonte Park (North) | None 877 | |||
10072 | 10072 | 10071 | {"type": "Polygon", "coordinates": [[[-120.43022, 34.9066], [-120.43021, 34.90749], [-120.42997, 34.90751], [-120.42984, 34.90753], [-120.42924, 34.90774], [-120.42901, 34.90778], [-120.42894, 34.90775], [-120.42884, 34.90754], [-120.42883, 34.90739], [-120.42885, 34.90707], [-120.42884, 34.90701], [-120.4288, 34.90696], [-120.4289, 34.90691], [-120.4289, 34.9066], [-120.43022, 34.9066]]]} | Open Access 1 | 17573 | Maramonte Park (South) | 21789 | 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 | 3.488 | Maramonte Park (South) | None 870 | |||
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 | |
9778 | 9778 | 9777 | {"type": "Polygon", "coordinates": [[[-120.45304, 34.97738], [-120.45301, 34.97877], [-120.45142, 34.97875], [-120.45135, 34.97834], [-120.45133, 34.97828], [-120.45127, 34.97823], [-120.45118, 34.97789], [-120.4515, 34.97783], [-120.45136, 34.97735], [-120.45304, 34.97738]]]} | Open Access 1 | 16692 | Grogan Park | 19529 | 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.83 | Grogan 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 |
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]);