units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where DES_TP = 2 and MNG_AGENCY = 183
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 18
MNG_AGENCY 1
- Lake Elsinore, City of · 18 ✖
DES_TP 1
- Local Park · 18 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
497 | 497 | 496 | {"type": "Polygon", "coordinates": [[[-117.31082, 33.65409], [-117.31079, 33.65427], [-117.30502, 33.65344], [-117.30504, 33.65336], [-117.30568, 33.65345], [-117.30583, 33.65264], [-117.30709, 33.65186], [-117.30779, 33.65154], [-117.30788, 33.65166], [-117.30804, 33.65157], [-117.30845, 33.65132], [-117.30899, 33.65089], [-117.31082, 33.65409]]]} | Open Access 1 | 48360 | Summerly Community Park | 32925 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/city-hall/community-services/parks-and-facilities/parks/summerly-park-2232#ad-image-3 | Riverside 10 | 24.134 | Summerly Community Park | 2018 | Local Park 2 | 4 |
686 | 686 | 685 | {"type": "Polygon", "coordinates": [[[-117.3286, 33.66059], [-117.32833, 33.66191], [-117.32579, 33.66157], [-117.32607, 33.66022], [-117.3286, 33.66059]]]} | Open Access 1 | 3497 | Lake Point Park | 28266 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 8.839 | Lake Point Park | 0 | Local Park 2 | 4 | |
3086 | 3086 | 3085 | {"type": "Polygon", "coordinates": [[[-117.3313, 33.67558], [-117.33087, 33.67667], [-117.32993, 33.6764], [-117.33024, 33.67564], [-117.33069, 33.67576], [-117.33083, 33.67545], [-117.3313, 33.67558]]]} | Open Access 1 | 22128 | Yarborough Park | 27763 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 2.462 | Yarborough Park | 0 | Local Park 2 | 4 | |
10704 | 10704 | 10703 | {"type": "Polygon", "coordinates": [[[-117.40078, 33.68705], [-117.40065, 33.68723], [-117.40054, 33.68729], [-117.40043, 33.68757], [-117.40029, 33.68771], [-117.40016, 33.68775], [-117.39981, 33.68762], [-117.39954, 33.68758], [-117.39733, 33.68757], [-117.39678, 33.68734], [-117.39588, 33.68656], [-117.39619, 33.68621], [-117.39646, 33.68581], [-117.39663, 33.68543], [-117.39671, 33.6852], [-117.39677, 33.68497], [-117.39714, 33.68509], [-117.39755, 33.68527], [-117.39787, 33.68546], [-117.39829, 33.68576], [-117.39852, 33.6859], [-117.39872, 33.68601], [-117.39938, 33.68628], [-117.39964, 33.68643], [-117.39993, 33.68665], [-117.40016, 33.68679], [-117.40045, 33.68693], [-117.40078, 33.68705]]]} | Open Access 1 | 19875 | McVicker Canyon Park | 28282 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=851 | Riverside 10 | 18.103 | McVicker Canyon Park | 0 | Local Park 2 | 4 |
10705 | 10705 | 10704 | {"type": "Polygon", "coordinates": [[[-117.3338, 33.6662], [-117.33359, 33.66642], [-117.33375, 33.66652], [-117.33364, 33.66653], [-117.33324, 33.66754], [-117.33232, 33.6673], [-117.3322, 33.66738], [-117.33146, 33.66717], [-117.33217, 33.66595], [-117.33228, 33.66585], [-117.33268, 33.66608], [-117.33274, 33.66592], [-117.33238, 33.66571], [-117.33249, 33.66554], [-117.33244, 33.66551], [-117.33254, 33.66534], [-117.3338, 33.6662]]]} | Open Access 1 | 19876 | Swick and Matich Park | 26109 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 7.124 | Swick and Matich Park | 0 | Local Park 2 | 4 | |
10706 | 10706 | 10705 | {"type": "Polygon", "coordinates": [[[-117.2986, 33.66519], [-117.29859, 33.66565], [-117.29855, 33.66584], [-117.29846, 33.66606], [-117.29839, 33.66608], [-117.29804, 33.66592], [-117.29774, 33.66584], [-117.29749, 33.66581], [-117.29721, 33.66581], [-117.29694, 33.66579], [-117.29715, 33.66497], [-117.29785, 33.66509], [-117.29833, 33.66523], [-117.2986, 33.66519]]]} | Open Access 1 | 19877 | Summerhill Park | 25960 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 3.106 | Summerhill Park | 0 | Local Park 2 | 4 | |
10713 | 10713 | 10712 | {"type": "Polygon", "coordinates": [[[-117.39344, 33.69094], [-117.39311, 33.69099], [-117.39309, 33.69136], [-117.39312, 33.69339], [-117.39168, 33.69308], [-117.39162, 33.69302], [-117.39148, 33.69276], [-117.39126, 33.69278], [-117.39021, 33.69283], [-117.39021, 33.69131], [-117.3903, 33.69123], [-117.39046, 33.69122], [-117.39065, 33.69119], [-117.39135, 33.69095], [-117.39212, 33.69088], [-117.39237, 33.69083], [-117.39261, 33.69074], [-117.39301, 33.69048], [-117.39325, 33.6904], [-117.39331, 33.69043], [-117.39339, 33.69069], [-117.39344, 33.69094]]]} | Restricted Access 2 | 19872 | Summer Lake Park | 31649 | 2326 | Elsinore Unified School District 954 | Special District 4 | School District 14 | http://www.leusd.k12.ca.us/ | Special District 4 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 15.756 | Summer Lake Park | 0 | Local Park 2 | 4 | |
10714 | 10714 | 10713 | {"type": "Polygon", "coordinates": [[[-117.39701, 33.69228], [-117.3969, 33.6926], [-117.39659, 33.69245], [-117.39638, 33.69233], [-117.39615, 33.69215], [-117.39512, 33.69124], [-117.39571, 33.69106], [-117.39701, 33.69228]]]} | Open Access 1 | 19873 | Oak Tree Park | 23011 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 2.484 | Oak Tree Park | 0 | Local Park 2 | 4 | |
10715 | 10715 | 10714 | {"type": "Polygon", "coordinates": [[[-117.37796, 33.68413], [-117.377, 33.68522], [-117.37602, 33.68457], [-117.37627, 33.68425], [-117.3764, 33.68423], [-117.37651, 33.68416], [-117.37655, 33.68405], [-117.37676, 33.68385], [-117.37693, 33.68398], [-117.37718, 33.6839], [-117.37729, 33.68369], [-117.37796, 33.68413]]]} | Restricted Access 2 | 19874 | Machado Park | 31594 | 2326 | Elsinore Unified School District 954 | Special District 4 | School District 14 | http://www.leusd.k12.ca.us/ | Special District 4 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/city-hall/city-departments/community-services/parks/machado-park#ad-image-0 | Riverside 10 | 3.781 | Machado Park | 0 | Local Park 2 | 4 |
10716 | 10716 | 10715 | {"type": "Polygon", "coordinates": [[[-117.28878, 33.68466], [-117.28861, 33.68481], [-117.28849, 33.68471], [-117.28839, 33.6848], [-117.28854, 33.68493], [-117.28848, 33.68499], [-117.28836, 33.68506], [-117.28824, 33.68511], [-117.28813, 33.68514], [-117.28798, 33.68515], [-117.28776, 33.68534], [-117.28775, 33.6855], [-117.2877, 33.68563], [-117.2876, 33.68575], [-117.28748, 33.68584], [-117.28733, 33.68572], [-117.28729, 33.68574], [-117.2866, 33.68518], [-117.28704, 33.68481], [-117.28736, 33.68435], [-117.28745, 33.68414], [-117.28754, 33.68409], [-117.28827, 33.68419], [-117.28827, 33.68423], [-117.28834, 33.68429], [-117.28838, 33.6843], [-117.28841, 33.68427], [-117.28868, 33.6845], [-117.28865, 33.68455], [-117.28878, 33.68466]]]} | Open Access 1 | 19878 | Tuscany Hills Park | 28283 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=854 | Riverside 10 | 4.824 | Tuscany Hills Park | 0 | Local Park 2 | 4 |
11990 | 11990 | 11989 | {"type": "Polygon", "coordinates": [[[-117.25891, 33.65896], [-117.25828, 33.65922], [-117.25818, 33.65929], [-117.25812, 33.65937], [-117.25807, 33.65947], [-117.25805, 33.65961], [-117.25807, 33.65969], [-117.25817, 33.6599], [-117.25822, 33.66004], [-117.25824, 33.66019], [-117.25822, 33.6603], [-117.25698, 33.66046], [-117.25687, 33.66], [-117.25677, 33.65982], [-117.25663, 33.65966], [-117.25664, 33.65958], [-117.25695, 33.65925], [-117.25726, 33.65885], [-117.25751, 33.65843], [-117.25768, 33.65805], [-117.25815, 33.65824], [-117.25849, 33.65852], [-117.25891, 33.65896]]]} | Open Access 1 | 24644 | Creekside Park | 17782 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 7.192 | Creekside Park | 0 | Local Park 2 | 4 | |
13411 | 13411 | 13410 | {"type": "Polygon", "coordinates": [[[-117.32935, 33.66648], [-117.32846, 33.66623], [-117.32853, 33.66509], [-117.32905, 33.66522], [-117.32919, 33.66557], [-117.32929, 33.66596], [-117.32935, 33.66648]]]} | Open Access 1 | 35521 | City Park | 17342 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 2.243 | City Park | 0 | Local Park 2 | 4 | |
14083 | 14083 | 14082 | {"type": "Polygon", "coordinates": [[[-117.24954, 33.66164], [-117.24953, 33.66189], [-117.24928, 33.66181], [-117.24901, 33.66183], [-117.24888, 33.66176], [-117.24838, 33.66189], [-117.2471, 33.6627], [-117.24687, 33.66297], [-117.2466, 33.66347], [-117.24643, 33.66354], [-117.24402, 33.66036], [-117.24412, 33.66035], [-117.2443, 33.66024], [-117.24434, 33.66015], [-117.2454, 33.65959], [-117.24574, 33.65943], [-117.24608, 33.6596], [-117.24636, 33.65984], [-117.24674, 33.65982], [-117.24712, 33.65987], [-117.2475, 33.66001], [-117.24777, 33.66027], [-117.24798, 33.6606], [-117.24825, 33.66081], [-117.24874, 33.66098], [-117.24899, 33.66115], [-117.24919, 33.66142], [-117.24939, 33.6615], [-117.24954, 33.66164]]]} | Open Access 1 | 39131 | Canyon Hills Community Park | 16817 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 27.11 | Canyon Hills Community Park | 0 | Local Park 2 | 4 | |
14084 | 14084 | 14083 | {"type": "Polygon", "coordinates": [[[-117.29434, 33.66485], [-117.29419, 33.665], [-117.29409, 33.66486], [-117.29397, 33.66475], [-117.29384, 33.66467], [-117.29369, 33.66459], [-117.29261, 33.66423], [-117.29238, 33.66418], [-117.29211, 33.66417], [-117.29216, 33.66396], [-117.29221, 33.66397], [-117.29246, 33.66412], [-117.29265, 33.6642], [-117.29415, 33.66471], [-117.29434, 33.66485]]]} | Open Access 1 | 39132 | Linear Park | 28281 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | Riverside 10 | 0.46 | Linear Park | 0 | Local Park 2 | 4 |
14085 | 14085 | 14084 | {"type": "Polygon", "coordinates": [[[-117.38656, 33.68396], [-117.38652, 33.68399], [-117.38628, 33.68405], [-117.38553, 33.68405], [-117.38472, 33.68409], [-117.38469, 33.68405], [-117.38428, 33.68406], [-117.38456, 33.68363], [-117.38474, 33.68342], [-117.38492, 33.68328], [-117.3852, 33.68347], [-117.38573, 33.68372], [-117.38628, 33.6839], [-117.38656, 33.68396]]]} | Open Access 1 | 39134 | Lincoln Street Park | 21276 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 2.248 | Lincoln Street Park | 0 | Local Park 2 | 4 | |
14086 | 14086 | 14085 | {"type": "Polygon", "coordinates": [[[-117.30789, 33.62449], [-117.30782, 33.62473], [-117.30773, 33.62479], [-117.30737, 33.62481], [-117.30688, 33.62475], [-117.30616, 33.62463], [-117.3052, 33.62419], [-117.30444, 33.62375], [-117.30435, 33.62366], [-117.30409, 33.62351], [-117.304, 33.62361], [-117.30261, 33.62285], [-117.30247, 33.62299], [-117.30093, 33.62204], [-117.3013, 33.62163], [-117.30142, 33.62161], [-117.30179, 33.62185], [-117.3036, 33.62318], [-117.30378, 33.6233], [-117.30526, 33.62414], [-117.30554, 33.62423], [-117.3068, 33.62443], [-117.30715, 33.62446], [-117.30789, 33.62449]]]} | Open Access 1 | 39136 | Serenity Park | 25313 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 5.527 | Serenity Park | 0 | Local Park 2 | 4 | |
14908 | 14908 | 14907 | {"type": "Polygon", "coordinates": [[[-117.38626, 33.70915], [-117.38502, 33.7109], [-117.38481, 33.71122], [-117.38462, 33.71156], [-117.38451, 33.71172], [-117.38375, 33.7121], [-117.38344, 33.71201], [-117.3829, 33.71181], [-117.38264, 33.7117], [-117.38218, 33.71145], [-117.3821, 33.71141], [-117.3822, 33.71122], [-117.38214, 33.71123], [-117.3821, 33.71121], [-117.38163, 33.71087], [-117.38136, 33.71064], [-117.38299, 33.70983], [-117.38327, 33.70933], [-117.38336, 33.7093], [-117.38343, 33.70923], [-117.38344, 33.70919], [-117.38343, 33.70912], [-117.38338, 33.70905], [-117.38333, 33.70902], [-117.38354, 33.7087], [-117.3836, 33.70843], [-117.38375, 33.70852], [-117.38383, 33.70852], [-117.3839, 33.70849], [-117.38626, 33.70915]]]} | Open Access 1 | 45464 | Alberhill Ranch Community Park | 28274 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=831 | Riverside 10 | 23.134 | Alberhill Ranch Community Park | 0 | Local Park 2 | 4 |
14909 | 14909 | 14908 | {"type": "Polygon", "coordinates": [[[-117.32581, 33.69902], [-117.32571, 33.70127], [-117.3256, 33.70144], [-117.32536, 33.70128], [-117.32508, 33.70118], [-117.32477, 33.70113], [-117.32446, 33.70115], [-117.32415, 33.70124], [-117.32397, 33.70127], [-117.32379, 33.70134], [-117.32366, 33.70144], [-117.32242, 33.70194], [-117.3223, 33.70191], [-117.32177, 33.70099], [-117.32164, 33.7008], [-117.32147, 33.70059], [-117.32155, 33.70054], [-117.32162, 33.70056], [-117.32179, 33.70055], [-117.32191, 33.70048], [-117.32195, 33.7004], [-117.32207, 33.69988], [-117.32223, 33.69954], [-117.32231, 33.69943], [-117.32241, 33.69933], [-117.32269, 33.6992], [-117.32295, 33.69913], [-117.32441, 33.69899], [-117.32461, 33.69904], [-117.3248, 33.69904], [-117.325, 33.69899], [-117.32517, 33.69887], [-117.32531, 33.69896], [-117.32581, 33.69902]]]} | Open Access 1 | 45465 | Rosetta Canyon Community Park | 28275 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=833 | Riverside 10 | 22.796 | Rosetta Canyon Community 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]);