superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where MNG_AGENCY = 63 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15490 | 15490 | 15489 | {"type": "Polygon", "coordinates": [[[-117.58455, 33.83845], [-117.58452, 33.83851], [-117.58398, 33.83887], [-117.58344, 33.83848], [-117.58239, 33.8389], [-117.58202, 33.83901], [-117.5816, 33.83909], [-117.58106, 33.83914], [-117.58005, 33.83911], [-117.57995, 33.83919], [-117.57974, 33.83918], [-117.57932, 33.83908], [-117.57914, 33.83908], [-117.57914, 33.83937], [-117.57905, 33.83939], [-117.57899, 33.83911], [-117.57853, 33.83917], [-117.57807, 33.83928], [-117.57658, 33.83973], [-117.57668, 33.83999], [-117.5766, 33.84002], [-117.57642, 33.83977], [-117.576, 33.83995], [-117.57599, 33.83997], [-117.57628, 33.84053], [-117.57635, 33.84092], [-117.57632, 33.84135], [-117.5764, 33.84199], [-117.57664, 33.84306], [-117.57637, 33.84309], [-117.57595, 33.84308], [-117.57553, 33.84302], [-117.57529, 33.84296], [-117.57489, 33.84284], [-117.57468, 33.84275], [-117.57431, 33.84256], [-117.57417, 33.84247], [-117.5738, 33.84219], [-117.57345, 33.84184], [-117.57252, 33.84056], [-117.57329, 33.84023], [-117.57354, 33.84016], [-117.5738, 33.84012], [-117.57408, 33.84013], [-117.57525, 33.84034], [-117.57542, 33.8403], [-117.57557, 33.8402], [-117.57563, 33.84011], [-117.57571, 33.83988], [-117.57579, 33.83938], [-117.57576, 33.839], [-117.57564, 33.83874], [-117.57536, 33.83829], [-117.57463, 33.8382], [-117.57394, 33.83815], [-117.57365, 33.83814], [-117.57336, 33.83816], [-117.57253, 33.8383], [-117.57229, 33.83833], [-117.57222, 33.83857], [-117.57218, 33.83851], [-117.57221, 33.8383], [-117.57228, 33.83824], [-117.5734, 33.83804], [-117.57376, 33.83802], [-117.57411, 33.83804], [-117.57526, 33.83815], [-117.57537, 33.83799], [-117.57543, 33.8378], [-117.57546, 33.8376], [-117.57547, 33.8374], [-117.57543, 33.83721], [-117.57519, 33.83664], [-117.57478, 33.83635], [-117.57416, 33.83607], [-117.57382, 33.83567], [-117.57366, 33.83552], [-117.57347, 33.83545], [-117.57312, 33.83535], [-117.57269, 33.8353], [-117.57278, 33.83474], [-117.5728, 33.83472], [-117.57392, 33.83484], [-117.57383, 33.83547], [-117.57433, 33.8359], [-117.57502, 33.83625], [-117.57534, 33.83652], [-117.57565, 33.83724], [-117.57563, 33.83809], [-117.57569, 33.83843], [-117.57577, 33.83864], [-117.57611, 33.83924], [-117.57633, 33.83937], [-117.57651, 33.8394], [-117.5767, 33.83938], [-117.57693, 33.83931], [-117.57794, 33.83915], [-117.57876, 33.83896], [-117.57918, 33.83889], [-117.58093, 33.83894], [-117.58132, 33.83892], [-117.58172, 33.83887], [-117.58203, 33.8388], [-117.58236, 33.8387], [-117.58323, 33.83835], [-117.58356, 33.83824], [-117.58398, 33.83791], [-117.58453, 33.83841], [-117.58455, 33.83845]]]} | Open Access 1 | Mountaingate Community Park | 22561 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 32.87 | Mountaingate Community 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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);