superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where MNG_AGENCY = 63
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
6193 | 6193 | 6192 | {"type": "MultiPolygon", "coordinates": [[[[-117.58559, 33.86101], [-117.58543, 33.86198], [-117.58517, 33.8638], [-117.58405, 33.86369], [-117.58408, 33.86366], [-117.58426, 33.86229], [-117.58268, 33.86215], [-117.58293, 33.86072], [-117.58559, 33.86101]]], [[[-117.58666, 33.86138], [-117.58649, 33.86245], [-117.5863, 33.8639], [-117.58547, 33.86381], [-117.58544, 33.86377], [-117.58568, 33.86217], [-117.58583, 33.8613], [-117.58666, 33.86138]]]]} | Open Access 1 | Lincoln Park | 21262 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 19.199 | Lincoln 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 | ||
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 | ||
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 | ||
7969 | 7969 | 7968 | {"type": "Polygon", "coordinates": [[[-117.5327, 33.90092], [-117.53265, 33.9012], [-117.53261, 33.90168], [-117.53105, 33.90171], [-117.53077, 33.90236], [-117.53009, 33.90237], [-117.53006, 33.90164], [-117.53005, 33.90116], [-117.5327, 33.90092]]]} | Open Access 1 | Parkview Park | 23457 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 5.726 | Parkview Park | ||
8419 | 8419 | 8418 | {"type": "Polygon", "coordinates": [[[-117.52089, 33.89504], [-117.52051, 33.89526], [-117.52025, 33.89543], [-117.52003, 33.89563], [-117.51988, 33.89583], [-117.51963, 33.89603], [-117.51946, 33.8964], [-117.51944, 33.89665], [-117.51935, 33.89664], [-117.51924, 33.89664], [-117.51907, 33.89658], [-117.51879, 33.89672], [-117.51866, 33.89672], [-117.5168, 33.89447], [-117.51733, 33.89416], [-117.51738, 33.89416], [-117.51743, 33.89419], [-117.51752, 33.89415], [-117.51753, 33.89413], [-117.51749, 33.89408], [-117.51896, 33.8931], [-117.51901, 33.89309], [-117.51907, 33.89312], [-117.51956, 33.89371], [-117.51962, 33.89368], [-117.51969, 33.89382], [-117.51992, 33.89385], [-117.52065, 33.89474], [-117.52069, 33.89484], [-117.5208, 33.89492], [-117.52089, 33.89504]]]} | Open Access 1 | Promenade Community Park | 24015 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 19.691 | Promenade Community 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 | ||
8708 | 8708 | 8707 | {"type": "Polygon", "coordinates": [[[-117.54466, 33.84898], [-117.54465, 33.84947], [-117.54193, 33.84944], [-117.54195, 33.84784], [-117.54276, 33.84822], [-117.54466, 33.84898]]]} | Open Access 1 | Rimpau Park | 24366 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 7.089 | Rimpau Park | ||
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 | ||
8765 | 8765 | 8764 | {"type": "Polygon", "coordinates": [[[-117.57724, 33.90087], [-117.57691, 33.90109], [-117.57693, 33.90114], [-117.57661, 33.90134], [-117.57495, 33.89948], [-117.57494, 33.89942], [-117.57521, 33.89888], [-117.57543, 33.89922], [-117.57574, 33.89933], [-117.57612, 33.89952], [-117.57643, 33.89976], [-117.57677, 33.90009], [-117.57721, 33.90049], [-117.57712, 33.90056], [-117.57708, 33.90065], [-117.57708, 33.90072], [-117.57714, 33.90082], [-117.57724, 33.90087]]]} | Open Access 1 | River Road Park | 24424 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 5.569 | River Road Park | ||
8845 | 8845 | 8844 | {"type": "Polygon", "coordinates": [[[-117.52185, 33.89938], [-117.52159, 33.89971], [-117.52161, 33.90071], [-117.52039, 33.90177], [-117.51995, 33.90162], [-117.52017, 33.90133], [-117.52023, 33.90127], [-117.52024, 33.90034], [-117.52049, 33.89983], [-117.52056, 33.89947], [-117.52052, 33.89932], [-117.52036, 33.89886], [-117.52079, 33.89875], [-117.52124, 33.89861], [-117.52185, 33.89938]]]} | Open Access 1 | Rock Vista Park | 24513 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 8.326 | Rock Vista Park | ||
9359 | 9359 | 9358 | {"type": "Polygon", "coordinates": [[[-117.56349, 33.85318], [-117.56349, 33.85323], [-117.56347, 33.85326], [-117.56338, 33.85329], [-117.56301, 33.85347], [-117.56259, 33.85374], [-117.56228, 33.85398], [-117.56195, 33.85445], [-117.56134, 33.85481], [-117.55626, 33.85394], [-117.55937, 33.84936], [-117.5597, 33.84957], [-117.55984, 33.84969], [-117.56006, 33.84991], [-117.56024, 33.85017], [-117.56077, 33.85106], [-117.56108, 33.85144], [-117.56146, 33.85175], [-117.56306, 33.85278], [-117.56329, 33.85296], [-117.56349, 33.85318]]]} | Open Access 1 | Santana Regional Park | 25149 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 49.912 | Santana RP | ||
9511 | 9511 | 9510 | {"type": "Polygon", "coordinates": [[[-117.62126, 33.87017], [-117.62118, 33.8703], [-117.62103, 33.87046], [-117.61976, 33.87148], [-117.61937, 33.87111], [-117.61937, 33.87102], [-117.61933, 33.87096], [-117.619, 33.87061], [-117.61879, 33.87042], [-117.6188, 33.87039], [-117.61909, 33.8702], [-117.62006, 33.86941], [-117.6201, 33.8694], [-117.62016, 33.8694], [-117.62069, 33.86976], [-117.62124, 33.8701], [-117.62126, 33.87017]]]} | Open Access 1 | Serfas Club Park | 25314 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 6.673 | Serfas Club 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 | ||
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 | ||
9899 | 9899 | 9898 | {"type": "Polygon", "coordinates": [[[-117.60087, 33.90743], [-117.6005, 33.90779], [-117.60004, 33.90745], [-117.59927, 33.90815], [-117.59855, 33.90762], [-117.59887, 33.90731], [-117.59834, 33.90692], [-117.59568, 33.90939], [-117.59533, 33.90912], [-117.59888, 33.90588], [-117.60086, 33.90739], [-117.60087, 33.90743]]]} | Open Access 1 | Stagecoach Park | 25778 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 11.366 | Stagecoach 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 | ||
13617 | 13617 | 13616 | {"type": "Polygon", "coordinates": [[[-117.55856, 33.87575], [-117.55721, 33.87574], [-117.5572, 33.8763], [-117.55352, 33.8763], [-117.55351, 33.87591], [-117.55342, 33.8759], [-117.55343, 33.87542], [-117.55341, 33.87468], [-117.55718, 33.87468], [-117.5572, 33.87518], [-117.55855, 33.8752], [-117.55856, 33.87575]]]} | Open Access 1 | City Park | 31099 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 17.357 | City 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]);