superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 35 sorted by map 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
8195 | 8195 | 8194 | {"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 | Pioneer Park | 23733 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 0.642 | Pioneer Park | ||
4774 | 4774 | 4773 | {"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.45149, 34.97783], [-120.45136, 34.97735], [-120.45304, 34.97738]]]} | Open Access 1 | Grogan Park | 19529 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 5.833 | Grogan Park | ||
7605 | 7605 | 7604 | {"type": "Polygon", "coordinates": [[[-120.45229, 34.9638], [-120.45228, 34.96452], [-120.45062, 34.9645], [-120.4506, 34.96502], [-120.45027, 34.96501], [-120.45027, 34.96439], [-120.45032, 34.96427], [-120.45033, 34.96419], [-120.4503, 34.96407], [-120.45021, 34.96398], [-120.45023, 34.96377], [-120.45229, 34.9638]]]} | Open Access 1 | Oakley Park | 23031 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 4.086 | Oakley Park | ||
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 | ||
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 | |
1404 | 1404 | 1403 | {"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.93799], [-120.44324, 34.93653], [-120.44338, 34.93652], [-120.44338, 34.93626], [-120.4439, 34.93623], [-120.4439, 34.93475], [-120.44224, 34.93471], [-120.44225, 34.932], [-120.44215, 34.93196], [-120.44216, 34.93144], [-120.44472, 34.93148], [-120.44473, 34.93155], [-120.44491, 34.93156]]]} | Open Access 1 | Adam Park/Minami Park | 15255 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 34.325 | Adam Park/Minami 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 | ||
1648 | 1648 | 1647 | {"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 | Atkinson Park | 15673 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 6.222 | Atkinson Park | ||
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 | ||
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 | ||
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 | ||
2345 | 2345 | 2344 | {"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 | Buena Vista Park | 16495 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 4.028 | Buena Vista Park | ||
8392 | 8392 | 8391 | {"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 | Preisker Park | 23981 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 39.34 | Preisker Park | ||
6903 | 6903 | 6902 | {"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 | Mem Park | 22115 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 4.408 | Mem Park | ||
2783 | 2783 | 2782 | {"type": "Polygon", "coordinates": [[[-120.43563, 34.95389], [-120.43489, 34.95389], [-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.43376, 34.95484], [-120.43375, 34.95496], [-120.43369, 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.4332, 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.95433], [-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.95413], [-120.43457, 34.95409], [-120.43458, 34.95405], [-120.43457, 34.95387], [-120.4346, 34.95376], [-120.43488, 34.95374], [-120.43489, 34.95329], [-120.43559, 34.95328], [-120.43562, 34.9533], [-120.43564, 34.95333], [-120.43563, 34.95389]]]} | Open Access 1 | Central Plaza Park | 17071 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 2.889 | Central Plaza 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 | ||
4949 | 4949 | 4948 | {"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.43162, 34.90913], [-120.43176, 34.90913]]]} | Open Access 1 | Harvest Ranch Park | 19725 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 5.086 | Harvest Ranch Park | ||
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 |
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]);