units_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)
DES_TP 2
MNG_AG_TYP 1
- City Agency 42
MNG_AGENCY 1
- Corona, City of · 42 ✖
ACCESS_TYP 1
- Open Access 42
Link | rowid | id | map ▼ | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5370 | 5370 | 5369 | {"type": "MultiPolygon", "coordinates": [[[[-117.58559, 33.86101], [-117.58543, 33.86198], [-117.58517, 33.8638], [-117.58405, 33.86369], [-117.58408, 33.86366], [-117.58427, 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 | 5695 | Lincoln Park | 21262 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 19.187 | Lincoln Park | 0 | Local Park 2 | 4 | |
6202 | 6202 | 6201 | {"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.509, 33.89278], [-117.50893, 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.50691, 33.89316], [-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.5088, 33.89161], [-117.50924, 33.89166]]]} | Open Access 1 | 1242 | Griffin Park | 19514 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 13.013 | Griffin Park | 0 | Local Park 2 | 4 | |
1419 | 1419 | 1418 | {"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.89657], [-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.89414], [-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.89383], [-117.51992, 33.89385], [-117.52065, 33.89474], [-117.52068, 33.89484], [-117.5208, 33.89492], [-117.52089, 33.89504]]]} | Open Access 1 | 8979 | Promenade Community Park | 24015 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 19.689 | Promenade Community Park | 0 | Local Park 2 | 4 | |
7908 | 7908 | 7907 | {"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 | 10231 | Rock Vista Park | 24513 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 8.325 | Rock Vista Park | 0 | Local Park 2 | 4 | |
8938 | 8938 | 8937 | {"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.89373], [-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 | 14683 | Tehachapi Park | 26218 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 2.99 | Tehachapi Park | 0 | Local Park 2 | 4 | |
7723 | 7723 | 7722 | {"type": "Polygon", "coordinates": [[[-117.5327, 33.90092], [-117.53265, 33.9012], [-117.53261, 33.90168], [-117.53104, 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 | 7948 | Parkview Park | 23457 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 5.722 | Parkview Park | 0 | Local Park 2 | 4 | |
2867 | 2867 | 2866 | {"type": "Polygon", "coordinates": [[[-117.53403, 33.81452], [-117.53381, 33.8147], [-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 | 18848 | Eagle Glen Community Park | 18338 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 13.491 | Eagle Glen Community Park | 0 | Local Park 2 | 4 | |
2700 | 2700 | 2699 | {"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 | 18283 | Cresta Verde Park | 17804 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 5.334 | Cresta Verde Park | 0 | Local Park 2 | 4 | |
1539 | 1539 | 1538 | {"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.8128], [-117.53703, 33.81256], [-117.5371, 33.81243], [-117.53832, 33.81273]]]} | Open Access 1 | 12958 | Spyglass Park | 25759 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 5.013 | Spyglass Park | 0 | Local Park 2 | 4 | |
5268 | 5268 | 5267 | {"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 | 47378 | Village Park | 31101 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.discovercoronadwp.com/parkmaint/parks/village-park.html | Riverside 10 | 4.922 | Village Park | 0 | Local Park 2 | 4 |
9299 | 9299 | 9298 | {"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 | 15494 | Chase Neighborhood Park | 17154 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 5.21 | Chase Neighborhood Park | 0 | Local Park 2 | 4 | |
7893 | 7893 | 7892 | {"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 | 9993 | Rimpau Park | 24366 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 7.089 | Rimpau Park | 0 | Local Park 2 | 4 | |
9442 | 9442 | 9441 | {"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.84478], [-117.54319, 33.84476], [-117.54319, 33.8447], [-117.54325, 33.8446], [-117.54482, 33.84227], [-117.54727, 33.8431], [-117.54728, 33.84317], [-117.54858, 33.84398]]]} | Open Access 1 | 15789 | Citrus Community Park | 17269 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 20.233 | Citrus Community Park | 0 | Local Park 2 | 4 | |
625 | 625 | 624 | {"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 | 2399 | Jameson Park | 20356 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 13.04 | Jameson Park | 0 | Local Park 2 | 4 | |
5572 | 5572 | 5571 | {"type": "Polygon", "coordinates": [[[-117.55856, 33.87575], [-117.5572, 33.87574], [-117.5572, 33.8763], [-117.55352, 33.8763], [-117.55351, 33.8759], [-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 | 47375 | City Park | 31099 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 17.348 | City Park | 0 | Local Park 2 | 4 | |
6716 | 6716 | 6715 | {"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 | 5678 | Kellogg Park | 20581 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 4.546 | Kellogg Park | 0 | Local Park 2 | 4 | |
6446 | 6446 | 6445 | {"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 | 5636 | Cypress Park | 17876 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 3.277 | Cypress Park | 0 | Local Park 2 | 4 | |
5275 | 5275 | 5274 | {"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 | 2579 | Joy Park | 20509 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 0.193 | Joy Park | 0 | Local Park 2 | 4 | |
16343 | 16343 | 16342 | {"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.56005, 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 | 11753 | Santana Regional Park | 25149 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 49.913 | Santana RP | 0 | Local Park 2 | 4 | |
6927 | 6927 | 6926 | {"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 | 5821 | Victoria Park | 27079 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 2.283 | Victoria Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);