superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where MNG_AGENCY = 63 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
4757 | 4757 | 4756 | {"type": "Polygon", "coordinates": [[[-117.50924, 33.89166], [-117.50914, 33.89183], [-117.50907, 33.89201], [-117.50905, 33.89215], [-117.50906, 33.89225], [-117.50902, 33.89272], [-117.50894, 33.89315], [-117.50884, 33.89338], [-117.50868, 33.89365], [-117.50843, 33.89393], [-117.50831, 33.89405], [-117.50801, 33.89426], [-117.50785, 33.89435], [-117.50747, 33.89389], [-117.50692, 33.89317], [-117.50664, 33.89331], [-117.50658, 33.89323], [-117.50684, 33.89305], [-117.50628, 33.89215], [-117.50657, 33.89202], [-117.50718, 33.89212], [-117.50799, 33.89137], [-117.50844, 33.89133], [-117.50873, 33.89117], [-117.50894, 33.89126], [-117.50881, 33.8916], [-117.50924, 33.89166]]]} | Open Access 1 | Griffin Park | 19514 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 13.03 | Griffin 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 | ||
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 | ||
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 | ||
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 | ||
3766 | 3766 | 3765 | {"type": "Polygon", "coordinates": [[[-117.53403, 33.81452], [-117.53381, 33.81471], [-117.53285, 33.81636], [-117.53282, 33.81686], [-117.53209, 33.81689], [-117.53207, 33.81691], [-117.53166, 33.81689], [-117.53138, 33.81684], [-117.5312, 33.81679], [-117.53061, 33.81651], [-117.53073, 33.81636], [-117.53088, 33.81612], [-117.53106, 33.81571], [-117.53112, 33.81549], [-117.53118, 33.81518], [-117.5312, 33.81496], [-117.5312, 33.81465], [-117.53124, 33.81462], [-117.53374, 33.81438], [-117.53375, 33.81446], [-117.53381, 33.81452], [-117.53403, 33.81452]]]} | Open Access 1 | Eagle Glen Community Park | 18338 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 13.492 | Eagle Glen Community Park | ||
3320 | 3320 | 3319 | {"type": "Polygon", "coordinates": [[[-117.53678, 33.88883], [-117.53627, 33.89037], [-117.53499, 33.89006], [-117.53552, 33.88853], [-117.53678, 33.88883]]]} | Open Access 1 | Cresta Verde Park | 17804 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 5.333 | Cresta Verde 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 | ||
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 | |
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 | ||
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 | ||
2188 | 2188 | 2187 | {"type": "Polygon", "coordinates": [[[-117.54858, 33.84398], [-117.54832, 33.84393], [-117.54799, 33.84391], [-117.54751, 33.84394], [-117.54705, 33.84403], [-117.54682, 33.8441], [-117.54656, 33.84421], [-117.54621, 33.84441], [-117.54593, 33.84463], [-117.54574, 33.84481], [-117.54534, 33.84528], [-117.5451, 33.8455], [-117.54495, 33.84561], [-117.5449, 33.84561], [-117.54474, 33.84547], [-117.54461, 33.84539], [-117.54458, 33.84536], [-117.54418, 33.84513], [-117.54382, 33.84499], [-117.54323, 33.84479], [-117.54319, 33.84476], [-117.54319, 33.8447], [-117.54325, 33.8446], [-117.54482, 33.84227], [-117.54727, 33.8431], [-117.54729, 33.84318], [-117.54858, 33.84398]]]} | Open Access 1 | Citrus Community Park | 17269 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 20.234 | Citrus Community Park | ||
5464 | 5464 | 5463 | {"type": "Polygon", "coordinates": [[[-117.55597, 33.83411], [-117.55531, 33.83547], [-117.55479, 33.83646], [-117.55375, 33.83618], [-117.55329, 33.83601], [-117.55276, 33.83579], [-117.55424, 33.83354], [-117.55458, 33.83373], [-117.55476, 33.83382], [-117.55496, 33.83389], [-117.55532, 33.834], [-117.55597, 33.83411]]]} | Open Access 1 | Jameson Park | 20356 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 13.039 | Jameson 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);