superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 35 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA ▲ | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1112 | 1112 | 1111 | {"type": "Polygon", "coordinates": [[[-120.42732, 34.97528], [-120.42699, 34.97526], [-120.42685, 34.97537], [-120.42682, 34.97661], [-120.42664, 34.97662], [-120.42664, 34.97691], [-120.42404, 34.97697], [-120.42397, 34.97488], [-120.42406, 34.97487], [-120.42406, 34.97395], [-120.42418, 34.97395], [-120.42422, 34.97386], [-120.42536, 34.97428], [-120.42558, 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.42732, 34.97528]]]} | Open Access 1 | Jim May Park | https://www.cityofsantamaria.org/city-government/departments/recreation-and-parks/visit-your-parks/view-park-photos-descriptions#Jim%20May%20Park | 33608 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 20.25 | Jim May Park | |
846 | 846 | 845 | {"type": "Polygon", "coordinates": [[[-120.44605, 34.98496], [-120.44603, 34.98581], [-120.44476, 34.98579], [-120.44466, 34.98576], [-120.44461, 34.9857], [-120.4446, 34.98566], [-120.44461, 34.98494], [-120.44605, 34.98496]]]} | Open Access 1 | North Preisker Ranch Park | https://www.cityofsantamaria.org/city-government/departments/recreation-and-parks/visit-your-parks/view-park-photos-descriptions#North%20Preisker%20Ranch%20Park | 33566 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 3.027 | North Preisker Ranch Park | |
13615 | 13615 | 13614 | {"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.92014], [-120.42858, 34.92016], [-120.42858, 34.92107]]]} | Restricted Access 2 | Crossroads Open Space | 32864 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 12.825 | Crossroads OS | ||
1103 | 1103 | 1102 | {"type": "MultiPolygon", "coordinates": [[[[-120.42519, 34.92072], [-120.42518, 34.92081], [-120.4251, 34.92088], [-120.42503, 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.92045], [-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.92045]]]]} | Open Access 1 | Fletcher Park | https://www.cityofsantamaria.org/city-government/departments/recreation-and-parks/visit-your-parks/view-park-photos-descriptions#Fletcher%20Park | 32863 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 2.825 | Fletcher Park | |
11129 | 11129 | 11128 | {"type": "Polygon", "coordinates": [[[-120.45844, 34.92685], [-120.45843, 34.92783], [-120.45585, 34.9278], [-120.4559, 34.9276], [-120.456, 34.92741], [-120.45613, 34.92724], [-120.4563, 34.92709], [-120.45649, 34.92697], [-120.45671, 34.92687], [-120.45695, 34.92681], [-120.45719, 34.92679], [-120.45837, 34.92679], [-120.45842, 34.92681], [-120.45844, 34.92685]]]} | Open Access 1 | Westgate Ranch Park | 27396 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 5.778 | Westgate Ranch Park | ||
9018 | 9018 | 9017 | {"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 | Tunnell Park | 26577 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 5.778 | Tunnell Park | ||
9910 | 9910 | 9909 | {"type": "Polygon", "coordinates": [[[-120.44331, 34.9147], [-120.44331, 34.9147], [-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.44311, 34.91418], [-120.44318, 34.91425], [-120.44326, 34.91439], [-120.44331, 34.91454], [-120.44331, 34.9147]]]} | Open Access 1 | Stanley Park | 25789 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1.977 | Stanley Park | ||
9690 | 9690 | 9689 | {"type": "Polygon", "coordinates": [[[-120.43425, 34.94713], [-120.43423, 34.94857], [-120.43412, 34.94858], [-120.43412, 34.94888], [-120.43362, 34.94888], [-120.43362, 34.94859], [-120.4336, 34.94857], [-120.4336, 34.94842], [-120.43368, 34.94841], [-120.43367, 34.94824], [-120.43331, 34.94824], [-120.4333, 34.94838], [-120.43282, 34.94838], [-120.4328, 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 | Simas Basin Park | 25503 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 11.404 | Simas Basin Park | ||
7915 | 7915 | 7914 | {"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 | Santa Maria holding 9 | 25113 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 0.341 | Santa Maria holding 9 | ||
7914 | 7914 | 7913 | {"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 | Santa Maria holding 8 | 25112 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1.837 | Santa Maria holding 8 | ||
9332 | 9332 | 9331 | {"type": "Polygon", "coordinates": [[[-120.41587, 34.97214], [-120.4158, 34.97224], [-120.41558, 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 | Santa Maria holding 7 | 25111 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 0.886 | Santa Maria holding 7 | ||
9331 | 9331 | 9330 | {"type": "Polygon", "coordinates": [[[-120.42993, 34.90438], [-120.4295, 34.90438], [-120.42947, 34.90435], [-120.42977, 34.90426], [-120.42977, 34.90424], [-120.42937, 34.90378], [-120.42935, 34.90377], [-120.42912, 34.90348], [-120.42901, 34.90343], [-120.42909, 34.90341], [-120.42993, 34.90438]]]} | Open Access 1 | Santa Maria holding 6 | 25110 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 0.176 | Santa Maria holding 6 | ||
9330 | 9330 | 9329 | {"type": "Polygon", "coordinates": [[[-120.4434, 34.91658], [-120.44338, 34.91661], [-120.44335, 34.91662], [-120.44129, 34.9166], [-120.4413, 34.91649], [-120.44339, 34.91651], [-120.4434, 34.91658]]]} | Open Access 1 | Santa Maria holding 4 | 25108 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 0.606 | Santa Maria holding 4 | ||
9329 | 9329 | 9328 | {"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 | Santa Maria holding 3 | 25107 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 0.034 | Santa Maria holding 3 | ||
9328 | 9328 | 9327 | {"type": "Polygon", "coordinates": [[[-120.42896, 34.90324], [-120.42894, 34.90328], [-120.42891, 34.9033], [-120.4289, 34.9032], [-120.42866, 34.90294], [-120.42866, 34.90292], [-120.42843, 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 | Santa Maria holding 2 | 25106 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 0.53 | Santa Maria holding 2 | ||
9327 | 9327 | 9326 | {"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 | Santa Maria holding 10 | 25105 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1.082 | Santa Maria holding 10 | ||
9326 | 9326 | 9325 | {"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 | Santa Maria holding 1 | 25104 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1.315 | Santa Maria holding 1 | ||
9069 | 9069 | 9068 | {"type": "Polygon", "coordinates": [[[-120.4514, 34.95145], [-120.45139, 34.95211], [-120.45135, 34.95213], [-120.45059, 34.95212], [-120.4506, 34.95142], [-120.45136, 34.95142], [-120.4514, 34.95145]]]} | Open Access 1 | Russell Park | 24739 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1.403 | Russell Park | ||
9009 | 9009 | 9008 | {"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 | Rotary Centennial Park | 24684 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 14.361 | Rotary Centennial Park | ||
8660 | 8660 | 8659 | {"type": "Polygon", "coordinates": [[[-120.42771, 34.96444], [-120.42771, 34.96515], [-120.42677, 34.96515], [-120.42675, 34.96512], [-120.42581, 34.96512], [-120.42581, 34.9647], [-120.42611, 34.9647], [-120.42612, 34.96443], [-120.42677, 34.96443], [-120.42679, 34.96471], [-120.42743, 34.96472], [-120.42767, 34.96471], [-120.42768, 34.96444], [-120.42771, 34.96444]]]} | Open Access 1 | Rice Park | 24318 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 2.494 | Rice Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);