superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where MNG_AGENCY = 63 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3172 | 3172 | 3171 | {"type": "Polygon", "coordinates": [[[-117.57659, 33.88504], [-117.57652, 33.88547], [-117.57652, 33.88547], [-117.57638, 33.88542], [-117.57645, 33.88499], [-117.57659, 33.88504]]]} | Open Access 1 | Contreras Park | 17609 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 0.162 | Contreras Park | ||
4512 | 4512 | 4511 | {"type": "Polygon", "coordinates": [[[-117.56206, 33.8703], [-117.562, 33.87064], [-117.56159, 33.87059], [-117.56181, 33.87043], [-117.56206, 33.8703]]]} | Open Access 1 | Joy Park | 20509 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 0.192 | Joy Park | ||
6956 | 6956 | 6955 | {"type": "Polygon", "coordinates": [[[-117.57251, 33.87176], [-117.57208, 33.87172], [-117.57214, 33.87136], [-117.57238, 33.87161], [-117.57251, 33.87176]]]} | Open Access 1 | Merrill Park | 22171 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 0.206 | Merrill Park | ||
1396 | 1396 | 1395 | {"type": "Polygon", "coordinates": [[[-117.58063, 33.90172], [-117.58031, 33.90181], [-117.57957, 33.90195], [-117.57948, 33.90164], [-117.57942, 33.90164], [-117.57931, 33.9014], [-117.57926, 33.90133], [-117.57932, 33.90128], [-117.57934, 33.9012], [-117.57948, 33.90119], [-117.5797, 33.90089], [-117.57996, 33.90104], [-117.58024, 33.90127], [-117.58051, 33.90157], [-117.58063, 33.90172]]]} | Open Access 1 | Aburndale Recreation Center | 15241 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 2.025 | Aburndale Rec. Ctr. | ||
1489 | 1489 | 1488 | {"type": "Polygon", "coordinates": [[[-117.60688, 33.85681], [-117.60632, 33.85768], [-117.60592, 33.85751], [-117.60571, 33.85789], [-117.60568, 33.85771], [-117.60539, 33.85751], [-117.60642, 33.85657], [-117.60688, 33.85681]]]} | Open Access 1 | Border Park | 16280 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 2.097 | Border Park | ||
10862 | 10862 | 10861 | {"type": "Polygon", "coordinates": [[[-117.56441, 33.87107], [-117.56429, 33.87194], [-117.56326, 33.87182], [-117.56339, 33.87096], [-117.56441, 33.87107]]]} | Open Access 1 | Victoria Park | 27079 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 2.283 | Victoria Park | ||
9599 | 9599 | 9598 | {"type": "Polygon", "coordinates": [[[-117.5709, 33.87806], [-117.57077, 33.87892], [-117.56973, 33.8788], [-117.56987, 33.87795], [-117.5709, 33.87806]]]} | Open Access 1 | Sheridan Park | 25392 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 2.287 | Sheridan Park | ||
1488 | 1488 | 1487 | {"type": "Polygon", "coordinates": [[[-117.60541, 33.8572], [-117.60486, 33.85771], [-117.60375, 33.85686], [-117.6043, 33.85636], [-117.60447, 33.85647], [-117.60541, 33.8572]]]} | Open Access 1 | Border Tennis Courts | 16281 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 2.633 | Border Tennis Courts | ||
8733 | 8733 | 8732 | {"type": "Polygon", "coordinates": [[[-117.52962, 33.8943], [-117.52959, 33.89432], [-117.52905, 33.89447], [-117.52893, 33.89421], [-117.52826, 33.8944], [-117.52805, 33.89391], [-117.52824, 33.89374], [-117.52824, 33.89367], [-117.52837, 33.89365], [-117.52848, 33.89356], [-117.52859, 33.8935], [-117.52877, 33.89343], [-117.52898, 33.89339], [-117.52919, 33.89337], [-117.52938, 33.89338], [-117.5294, 33.8934], [-117.52942, 33.89365], [-117.5295, 33.89385], [-117.52962, 33.89425], [-117.52962, 33.8943]]]} | Open Access 1 | Tehachapi Park | 26218 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 2.993 | Tehachapi Park | ||
6574 | 6574 | 6573 | {"type": "Polygon", "coordinates": [[[-117.59945, 33.85865], [-117.59934, 33.85933], [-117.59747, 33.85914], [-117.59758, 33.85844], [-117.59802, 33.85852], [-117.59872, 33.8586], [-117.59945, 33.85865]]]} | Open Access 1 | Mangular Park | 21745 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 3.258 | Mangular Park | ||
3390 | 3390 | 3389 | {"type": "Polygon", "coordinates": [[[-117.56115, 33.87058], [-117.56058, 33.87106], [-117.56017, 33.87147], [-117.56005, 33.87138], [-117.55953, 33.87063], [-117.55987, 33.8703], [-117.56005, 33.87015], [-117.56053, 33.86995], [-117.56115, 33.87058]]]} | Open Access 1 | Cypress Park | 17876 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 3.276 | Cypress Park | ||
5309 | 5309 | 5308 | {"type": "Polygon", "coordinates": [[[-117.57342, 33.86906], [-117.57322, 33.87045], [-117.57284, 33.87041], [-117.57283, 33.87039], [-117.57278, 33.8704], [-117.57229, 33.87035], [-117.5725, 33.86899], [-117.57299, 33.86904], [-117.57299, 33.86906], [-117.57302, 33.86907], [-117.57305, 33.86902], [-117.57342, 33.86906]]]} | Open Access 1 | Husted Park | 20160 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 3.286 | Husted Park | ||
5057 | 5057 | 5056 | {"type": "Polygon", "coordinates": [[[-117.57751, 33.84415], [-117.57745, 33.84458], [-117.57741, 33.84466], [-117.57731, 33.84478], [-117.57728, 33.84484], [-117.57731, 33.84492], [-117.57738, 33.84498], [-117.57734, 33.8453], [-117.57585, 33.84516], [-117.57613, 33.84334], [-117.57618, 33.84334], [-117.57617, 33.84345], [-117.57612, 33.84363], [-117.57612, 33.84368], [-117.57618, 33.84378], [-117.57626, 33.84383], [-117.57623, 33.84413], [-117.57666, 33.84413], [-117.5769, 33.8441], [-117.57751, 33.84415]]]} | Open Access 1 | Heritage Park | 19846 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 4.404 | Heritage Park | ||
5689 | 5689 | 5688 | {"type": "Polygon", "coordinates": [[[-117.559, 33.8633], [-117.5584, 33.86365], [-117.55765, 33.86422], [-117.55735, 33.86439], [-117.5567, 33.86459], [-117.55642, 33.86477], [-117.55641, 33.86476], [-117.55712, 33.86398], [-117.55829, 33.86246], [-117.55841, 33.86232], [-117.559, 33.8633]]]} | Open Access 1 | Kellogg Park | 20581 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 4.546 | Kellogg Park | ||
13619 | 13619 | 13618 | {"type": "Polygon", "coordinates": [[[-117.54184, 33.89563], [-117.5395, 33.8956], [-117.53951, 33.89539], [-117.53954, 33.89522], [-117.53962, 33.89503], [-117.53972, 33.89488], [-117.53985, 33.89475], [-117.54183, 33.89475], [-117.54184, 33.89563]]]} | Open Access 1 | Village Park | http://www.discovercoronadwp.com/parkmaint/parks/village-park.html | 31101 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 4.92 | Village Park | |
9884 | 9884 | 9883 | {"type": "Polygon", "coordinates": [[[-117.53832, 33.81273], [-117.53832, 33.81364], [-117.53826, 33.81383], [-117.53798, 33.81379], [-117.53768, 33.8138], [-117.53741, 33.81385], [-117.53711, 33.81395], [-117.53707, 33.81395], [-117.53677, 33.81359], [-117.53649, 33.81331], [-117.5365, 33.81326], [-117.53675, 33.81299], [-117.53689, 33.81281], [-117.53703, 33.81256], [-117.5371, 33.81243], [-117.53832, 33.81273]]]} | Open Access 1 | Spyglass Park | 25759 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 5.013 | Spyglass Park | ||
8696 | 8696 | 8695 | {"type": "Polygon", "coordinates": [[[-117.62492, 33.8738], [-117.62461, 33.87423], [-117.62431, 33.87461], [-117.62399, 33.87497], [-117.62385, 33.87509], [-117.62374, 33.875], [-117.62357, 33.87479], [-117.62342, 33.87455], [-117.62333, 33.87434], [-117.62326, 33.87406], [-117.62324, 33.87382], [-117.62327, 33.87346], [-117.62336, 33.87316], [-117.62344, 33.87301], [-117.62492, 33.8738]]]} | Open Access 1 | Ridgeline Park | 24354 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 5.034 | Ridgeline Park | ||
6094 | 6094 | 6093 | {"type": "Polygon", "coordinates": [[[-117.58558, 33.83947], [-117.58515, 33.83976], [-117.58468, 33.84037], [-117.5846, 33.84039], [-117.58463, 33.84046], [-117.58338, 33.83989], [-117.58359, 33.83959], [-117.58388, 33.83928], [-117.5841, 33.8391], [-117.58473, 33.83867], [-117.58478, 33.83868], [-117.5855, 33.83935], [-117.58557, 33.83942], [-117.58558, 33.83947]]]} | Open Access 1 | Lemon Heights Park | 21153 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 5.151 | Lemon Heights Park | ||
7692 | 7692 | 7691 | {"type": "Polygon", "coordinates": [[[-117.59394, 33.85918], [-117.5939, 33.85938], [-117.59388, 33.85961], [-117.59389, 33.85995], [-117.59369, 33.85997], [-117.59232, 33.85982], [-117.59215, 33.85984], [-117.59202, 33.85988], [-117.59183, 33.86001], [-117.59174, 33.86011], [-117.59168, 33.86027], [-117.59161, 33.86091], [-117.59153, 33.86127], [-117.59148, 33.86127], [-117.59179, 33.8589], [-117.59389, 33.85913], [-117.59393, 33.85915], [-117.59394, 33.85918]]]} | Open Access 1 | Ontario Park | 23146 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 5.191 | Ontario Park | ||
2862 | 2862 | 2861 | {"type": "Polygon", "coordinates": [[[-117.54442, 33.83785], [-117.54392, 33.83867], [-117.54356, 33.8392], [-117.54238, 33.8388], [-117.54334, 33.83731], [-117.54442, 33.83785]]]} | Open Access 1 | Chase Neighborhood Park | 17154 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 5.209 | Chase Neighborhood 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]);