superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where MNG_AGENCY = 312
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87 | 87 | 86 | {"type": "Polygon", "coordinates": [[[-117.85212, 33.98947], [-117.85182, 33.9896], [-117.8517, 33.98973], [-117.8516, 33.9899], [-117.85177, 33.99025], [-117.85212, 33.99036], [-117.85201, 33.99068], [-117.85197, 33.99071], [-117.85185, 33.99073], [-117.8518, 33.99078], [-117.85179, 33.99085], [-117.85186, 33.99093], [-117.85186, 33.99097], [-117.85184, 33.99102], [-117.8518, 33.99105], [-117.85106, 33.99068], [-117.85088, 33.99061], [-117.8507, 33.99056], [-117.85041, 33.99053], [-117.8496, 33.99057], [-117.84933, 33.99061], [-117.84932, 33.99034], [-117.84954, 33.99025], [-117.8496, 33.99], [-117.84997, 33.98961], [-117.85022, 33.98963], [-117.85052, 33.98959], [-117.85071, 33.9896], [-117.85108, 33.98948], [-117.85119, 33.98952], [-117.85127, 33.98952], [-117.85144, 33.98945], [-117.85182, 33.98949], [-117.85208, 33.98939], [-117.85212, 33.98947]]]} | Open Access 1 | Larkstone Park | https://www.diamondbarca.gov/Facilities/Facility/Details/Larkstone-Park-38 | 31798 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 6.425 | Larkstone Park | 2018 |
201 | 201 | 200 | {"type": "Polygon", "coordinates": [[[-117.79029, 34.00176], [-117.79027, 34.00206], [-117.79028, 34.00231], [-117.79016, 34.00236], [-117.78948, 34.00182], [-117.78963, 34.00169], [-117.78979, 34.0015], [-117.79029, 34.00176]]]} | Open Access 1 | Longview Park North | 31869 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 0.991 | Longview Park North | ||
224 | 224 | 223 | {"type": "Polygon", "coordinates": [[[-117.84833, 33.96677], [-117.84766, 33.96715], [-117.84745, 33.96733], [-117.84713, 33.96767], [-117.84702, 33.96771], [-117.84699, 33.96774], [-117.8468, 33.96774], [-117.84679, 33.96772], [-117.84666, 33.96772], [-117.84618, 33.96778], [-117.84613, 33.96766], [-117.84619, 33.96762], [-117.8462, 33.96756], [-117.84623, 33.96755], [-117.84629, 33.96747], [-117.84634, 33.96745], [-117.84671, 33.96683], [-117.84686, 33.96663], [-117.84697, 33.96655], [-117.84715, 33.9665], [-117.84727, 33.96651], [-117.84729, 33.96648], [-117.84718, 33.96644], [-117.84698, 33.96642], [-117.84674, 33.96634], [-117.84666, 33.96633], [-117.84658, 33.96626], [-117.84649, 33.96622], [-117.84643, 33.96629], [-117.84616, 33.9662], [-117.8459, 33.96634], [-117.84585, 33.96623], [-117.8458, 33.96617], [-117.84555, 33.96607], [-117.8453, 33.96591], [-117.84508, 33.96583], [-117.84502, 33.96576], [-117.84498, 33.96566], [-117.84502, 33.9657], [-117.84507, 33.96572], [-117.84518, 33.96571], [-117.8469, 33.96621], [-117.84705, 33.96627], [-117.84763, 33.96656], [-117.8478, 33.96635], [-117.84796, 33.96641], [-117.84817, 33.96659], [-117.84814, 33.96665], [-117.84815, 33.96671], [-117.84818, 33.96673], [-117.84825, 33.96675], [-117.84831, 33.96674], [-117.84833, 33.96677]]]} | Open Access 1 | Diamond Canyon Park | 31870 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 4.991 | Diamond Canyon Park | 2016 | |
2634 | 2634 | 2633 | {"type": "Polygon", "coordinates": [[[-117.79585, 34.02808], [-117.7958, 34.02861], [-117.79581, 34.02896], [-117.79584, 34.02928], [-117.79581, 34.02932], [-117.79395, 34.02952], [-117.79357, 34.02963], [-117.79326, 34.02979], [-117.79312, 34.0299], [-117.79302, 34.02972], [-117.79193, 34.02881], [-117.79145, 34.02909], [-117.79139, 34.02848], [-117.79182, 34.02765], [-117.7921, 34.02764], [-117.79311, 34.02794], [-117.79402, 34.02779], [-117.79414, 34.0279], [-117.79509, 34.02802], [-117.79582, 34.02806], [-117.79585, 34.02808]]]} | Open Access 1 | Carlton Peterson Park | 16864 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 16.515 | Carlton Peterson Park | ||
3602 | 3602 | 3601 | {"type": "Polygon", "coordinates": [[[-117.79006, 34.00967], [-117.79004, 34.00971], [-117.78974, 34.0096], [-117.78945, 34.01001], [-117.78965, 34.01034], [-117.78977, 34.01034], [-117.78976, 34.01051], [-117.78948, 34.01053], [-117.78824, 34.01649], [-117.78516, 34.01804], [-117.78507, 34.00896], [-117.78533, 34.00903], [-117.78547, 34.00869], [-117.7855, 34.00871], [-117.78542, 34.00893], [-117.78545, 34.00899], [-117.78571, 34.00903], [-117.78612, 34.00901], [-117.78683, 34.00888], [-117.78708, 34.00914], [-117.7874, 34.00913], [-117.78748, 34.00855], [-117.78747, 34.00832], [-117.78745, 34.00821], [-117.78803, 34.00766], [-117.78831, 34.00722], [-117.78843, 34.00727], [-117.7888, 34.00738], [-117.78945, 34.00861], [-117.78944, 34.00885], [-117.7896, 34.00899], [-117.78979, 34.00941], [-117.79006, 34.00967]], [[-117.78913, 34.01023], [-117.78913, 34.01021], [-117.78845, 34.00965], [-117.7879, 34.01011], [-117.78752, 34.01059], [-117.78744, 34.01075], [-117.78744, 34.01091], [-117.78746, 34.01097], [-117.78758, 34.01112], [-117.78767, 34.01118], [-117.78795, 34.0113], [-117.78801, 34.01124], [-117.78913, 34.01023]]]} | Open Access 1 | Diamond Bar City Parkland | 18139 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 83.264 | Diamond Bar City Parkland | ||
5059 | 5059 | 5058 | {"type": "Polygon", "coordinates": [[[-117.84397, 33.97359], [-117.84302, 33.97478], [-117.84226, 33.97435], [-117.84321, 33.97317], [-117.84397, 33.97359]]]} | Open Access 1 | Heritage Park | 19848 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 3.321 | Heritage Park | ||
6609 | 6609 | 6608 | {"type": "Polygon", "coordinates": [[[-117.82764, 33.99581], [-117.82737, 33.99619], [-117.82708, 33.99653], [-117.82693, 33.9969], [-117.82682, 33.99742], [-117.82649, 33.99722], [-117.82631, 33.99704], [-117.82623, 33.99692], [-117.82613, 33.99674], [-117.82604, 33.99646], [-117.82587, 33.99617], [-117.82566, 33.99594], [-117.82538, 33.99573], [-117.82569, 33.99537], [-117.82593, 33.99528], [-117.82611, 33.99525], [-117.82613, 33.99542], [-117.82663, 33.99576], [-117.82749, 33.99565], [-117.82764, 33.99581]]]} | Open Access 1 | Maple Hill Park | 21776 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 5.456 | Maple Hill Park | ||
7922 | 7922 | 7921 | {"type": "Polygon", "coordinates": [[[-117.79207, 34.01316], [-117.79205, 34.01327], [-117.79179, 34.01396], [-117.7917, 34.01429], [-117.79168, 34.01447], [-117.79168, 34.0148], [-117.79166, 34.01481], [-117.79119, 34.01486], [-117.79088, 34.01492], [-117.79055, 34.01503], [-117.79024, 34.01518], [-117.78919, 34.01435], [-117.78862, 34.01465], [-117.78948, 34.01052], [-117.78978, 34.01052], [-117.78979, 34.01067], [-117.78985, 34.01089], [-117.79001, 34.01122], [-117.79019, 34.01142], [-117.79043, 34.01162], [-117.79167, 34.01237], [-117.79178, 34.01245], [-117.79192, 34.0126], [-117.79201, 34.01275], [-117.79207, 34.01297], [-117.79207, 34.01316]]]} | Open Access 1 | Pantera Park | 23395 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 23.834 | Pantera Park | ||
8028 | 8028 | 8027 | {"type": "Polygon", "coordinates": [[[-117.81235, 33.99363], [-117.81228, 33.99415], [-117.81211, 33.99483], [-117.81022, 33.99456], [-117.81021, 33.99442], [-117.81011, 33.99401], [-117.8108, 33.99397], [-117.81193, 33.99365], [-117.81214, 33.99363], [-117.81235, 33.99363]]]} | Open Access 1 | Paul C Grow Park | 23529 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 4.54 | Paul C Grow Park | ||
8925 | 8925 | 8924 | {"type": "Polygon", "coordinates": [[[-117.85457, 33.98176], [-117.85439, 33.98199], [-117.85418, 33.98222], [-117.85375, 33.98257], [-117.85342, 33.98277], [-117.85308, 33.98295], [-117.85265, 33.98311], [-117.85237, 33.98319], [-117.85235, 33.98317], [-117.85221, 33.98276], [-117.85197, 33.98237], [-117.85183, 33.98205], [-117.85179, 33.98192], [-117.85177, 33.98168], [-117.85457, 33.98176]]]} | Open Access 1 | Ronald Reagan Park | 24590 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 6.462 | Ronald Reagan Park | ||
9936 | 9936 | 9935 | {"type": "Polygon", "coordinates": [[[-117.85129, 33.98551], [-117.85129, 33.98556], [-117.85116, 33.98567], [-117.851, 33.98586], [-117.85088, 33.98606], [-117.85081, 33.98626], [-117.85015, 33.98616], [-117.85052, 33.98543], [-117.85061, 33.98532], [-117.85078, 33.98525], [-117.85092, 33.98525], [-117.85099, 33.98527], [-117.8511, 33.98533], [-117.85129, 33.98551]]]} | Open Access 1 | Starshine Park | 25810 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1.664 | Starshine Park | ||
10063 | 10063 | 10062 | {"type": "Polygon", "coordinates": [[[-117.80011, 33.99948], [-117.80007, 33.99959], [-117.79991, 33.9996], [-117.7998, 33.99957], [-117.7997, 33.9995], [-117.7996, 33.99952], [-117.79957, 33.99954], [-117.79955, 33.99961], [-117.79943, 33.99962], [-117.79931, 33.99959], [-117.79922, 33.99954], [-117.79917, 33.9995], [-117.79921, 33.99934], [-117.79898, 33.99925], [-117.79894, 33.9993], [-117.79888, 33.99934], [-117.79871, 33.99928], [-117.79821, 33.99926], [-117.79803, 33.99909], [-117.79772, 33.99901], [-117.79762, 33.99924], [-117.79762, 33.99937], [-117.79713, 33.99952], [-117.79709, 33.99955], [-117.79708, 33.99959], [-117.79697, 33.9997], [-117.79676, 33.9998], [-117.79678, 33.99985], [-117.79667, 33.99992], [-117.79647, 33.99997], [-117.79631, 33.99995], [-117.7963, 33.99996], [-117.79635, 33.99999], [-117.79599, 34.00029], [-117.79557, 34.00028], [-117.79525, 34.00004], [-117.79533, 33.99995], [-117.79551, 33.99972], [-117.79566, 33.99944], [-117.79585, 33.99892], [-117.79596, 33.99875], [-117.79609, 33.9986], [-117.79617, 33.99851], [-117.79643, 33.99834], [-117.79708, 33.99802], [-117.79725, 33.99791], [-117.79741, 33.99778], [-117.79754, 33.99765], [-117.79765, 33.9975], [-117.79775, 33.9973], [-117.79783, 33.99707], [-117.79785, 33.99694], [-117.79786, 33.99647], [-117.7979, 33.9963], [-117.79797, 33.99608], [-117.79901, 33.99627], [-117.79879, 33.99694], [-117.79897, 33.99742], [-117.79888, 33.99783], [-117.7991, 33.99809], [-117.79906, 33.99824], [-117.7992, 33.9985], [-117.79964, 33.99868], [-117.80011, 33.99948]]]} | Open Access 1 | Summit Ridge Park | 25970 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 19.919 | Summit Ridge Park | ||
10170 | 10170 | 10169 | {"type": "Polygon", "coordinates": [[[-117.81668, 34.00605], [-117.8144, 34.00711], [-117.81362, 34.00794], [-117.81389, 34.00821], [-117.81456, 34.00864], [-117.81489, 34.00878], [-117.8157, 34.00993], [-117.81507, 34.01038], [-117.8146, 34.01079], [-117.81376, 34.01016], [-117.8139, 34.00997], [-117.81382, 34.00967], [-117.81318, 34.00921], [-117.81275, 34.00934], [-117.81207, 34.00877], [-117.81126, 34.00825], [-117.81107, 34.00815], [-117.81087, 34.00806], [-117.80947, 34.00756], [-117.80908, 34.00722], [-117.8088, 34.00719], [-117.80833, 34.00721], [-117.80842, 34.00669], [-117.80852, 34.00627], [-117.80865, 34.00587], [-117.80876, 34.00559], [-117.81294, 34.00554], [-117.81542, 34.00599], [-117.81668, 34.00605]]]} | Open Access 1 | Sycamore Canyon Park | 26119 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 50.064 | Sycamore Canyon Park | ||
11872 | 11872 | 11871 | {"type": "Polygon", "coordinates": [[[-117.79047, 34.00735], [-117.79026, 34.0077], [-117.78999, 34.0084], [-117.78986, 34.00849], [-117.78946, 34.00861], [-117.78881, 34.00738], [-117.78917, 34.00745], [-117.78965, 34.00748], [-117.79008, 34.00744], [-117.79047, 34.00735]]]} | Open Access 1 | Silver Tip Park | 28565 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 2.875 | Silver Tip Park | ||
12648 | 12648 | 12647 | {"type": "Polygon", "coordinates": [[[-117.79552, 33.99224], [-117.7952, 33.99257], [-117.79464, 33.99225], [-117.79462, 33.99222], [-117.79477, 33.99201], [-117.79491, 33.99186], [-117.79552, 33.99224]]]} | Open Access 1 | Longview Park South | 29762 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 0.835 | Longview Park South | ||
12649 | 12649 | 12648 | {"type": "Polygon", "coordinates": [[[-117.84213, 34.00669], [-117.84211, 34.00671], [-117.84182, 34.00685], [-117.84177, 34.0068], [-117.8416, 34.00669], [-117.84174, 34.00646], [-117.84201, 34.00646], [-117.84205, 34.00643], [-117.84207, 34.00653], [-117.84213, 34.00669]]]} | Open Access 1 | Washington Park | 29763 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 0.353 | Washington Park | ||
12650 | 12650 | 12649 | {"type": "Polygon", "coordinates": [[[-117.79454, 33.99731], [-117.79403, 33.99775], [-117.79393, 33.99762], [-117.79384, 33.99749], [-117.79365, 33.99715], [-117.79366, 33.99713], [-117.79402, 33.99691], [-117.79406, 33.99692], [-117.79454, 33.99731]]]} | Open Access 1 | Stardust Park | 29764 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 0.983 | Stardust Park | ||
14363 | 14363 | 14362 | {"type": "Polygon", "coordinates": [[[-117.78588, 34.00726], [-117.78565, 34.00739], [-117.78506, 34.00701], [-117.78504, 34.00526], [-117.78514, 34.00526], [-117.78514, 34.0053], [-117.78517, 34.00534], [-117.78508, 34.00537], [-117.78509, 34.00642], [-117.78513, 34.00642], [-117.7853, 34.00662], [-117.78543, 34.00667], [-117.78578, 34.00669], [-117.78585, 34.00678], [-117.78583, 34.00699], [-117.78588, 34.00726]]]} | No Public Access 3 | Unnamed site - Diamond Bar, City of | 31868 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1.383 |
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]);