units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
460 rows where COUNTY = 10 and MNG_AG_TYP = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_WEB, MNG_AG_ID, GAP_STS
MNG_AGENCY 25
- Riverside, City of 61
- Murrieta, City of 51
- Corona, City of 42
- Temecula, City of 42
- Moreno Valley, City of 39
- San Jacinto, City of 33
- Lake Elsinore, City of 19
- La Quinta, City of 17
- Norco, City of 16
- Perris, City of 15
- Beaumont, City of 15
- Canyon Lake, City of 14
- Hemet, City of 11
- Indio, City of 11
- Palm Springs, City of 11
- Coachella, City of 10
- Palm Desert, City of 9
- Cathedral City, City of 8
- Blythe, City of 7
- Desert Hot Springs, City of 7
- Menifee, City of 7
- Banning, City of 6
- Rancho Mirage, City of 4
- Wildomar, City of 3
- Calimesa, City of 2
DES_TP 23
- Local Park 393
- Local Recreation Area 38
- Local Conservation Area 5
- National Monument or Landmark 4
- Local Other or Unknown 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 450
- Restricted Access 10
MNG_AG_TYP 1
- City Agency · 460 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2506 | 2506 | 2505 | {"type": "Polygon", "coordinates": [[[-117.3015, 33.61798], [-117.3012, 33.61831], [-117.29877, 33.61679], [-117.29902, 33.61646], [-117.3015, 33.61798]]]} | Open Access 1 | 48910 | Regency-Heritage Park | 33631 | 2437 | Ortega Trail Recreation and Park District 529 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 1706 | Wildomar, City of 522 | City 2 | City Agency 2 | http://www.cityofwildomar.org/community/parks_trails/parks/regency-heritage_park | Riverside 10 | 3.114 | Regency-Heritage Park | 0 | Local Park 2 | 4 | |
5438 | 5438 | 5437 | {"type": "Polygon", "coordinates": [[[-116.49934, 33.94046], [-116.49924, 33.94316], [-116.49819, 33.94316], [-116.49818, 33.94225], [-116.4971, 33.94225], [-116.49718, 33.94045], [-116.49934, 33.94046]]]} | Open Access 1 | 47920 | Mission Springs Park | 32032 | 2330 | Mission Springs Water District 806 | Special District 4 | Water District 13 | Special District 4 | 1670 | Desert Hot Springs, City of 630 | City 2 | City Agency 2 | Riverside 10 | 12.328 | Mission Springs Park | 0 | Local Park 2 | 4 | ||
2928 | 2928 | 2927 | {"type": "Polygon", "coordinates": [[[-117.21419, 33.78669], [-117.21416, 33.78846], [-117.2131, 33.78845], [-117.21308, 33.78667], [-117.21419, 33.78669]]]} | Open Access 1 | 19871 | Bob Long Park | 16210 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | Riverside 10 | 4.867 | Bob Long Park | 0 | Local Park 2 | 4 | |
3650 | 3650 | 3649 | {"type": "Polygon", "coordinates": [[[-117.22792, 33.78575], [-117.22791, 33.7858], [-117.22716, 33.78583], [-117.22716, 33.78652], [-117.22629, 33.78652], [-117.22625, 33.78652], [-117.22623, 33.78649], [-117.22622, 33.78562], [-117.22627, 33.78556], [-117.22768, 33.78556], [-117.22769, 33.78574], [-117.22792, 33.78575]]]} | Open Access 1 | 48805 | Russel Stewart Park/Cesar Chavez Library | 33527 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://www.cityofperris.org/residents/parks/parklist.html | Riverside 10 | 2.684 | Russel Stewart Park/Cesar Chavez Library | None 305 | ||
6235 | 6235 | 6234 | {"type": "Polygon", "coordinates": [[[-117.22851, 33.7902], [-117.22628, 33.7902], [-117.22628, 33.78801], [-117.22746, 33.788], [-117.22746, 33.78956], [-117.22846, 33.78956], [-117.22851, 33.7902]]]} | Open Access 1 | 1291 | Banta Beatty Park | 15802 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | Riverside 10 | 8.216 | Banta Beatty Park | 0 | Local Park 2 | 4 | |
6801 | 6801 | 6800 | {"type": "Polygon", "coordinates": [[[-117.23225, 33.7922], [-117.23211, 33.79221], [-117.23212, 33.7938], [-117.23068, 33.7938], [-117.22974, 33.79171], [-117.22954, 33.79115], [-117.2294, 33.7907], [-117.23224, 33.79069], [-117.23225, 33.7922]]]} | Open Access 1 | 5316 | Metz Park | 22190 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | Riverside 10 | 17.209 | Metz Park | 0 | Local Park 2 | 4 | |
10711 | 10711 | 10710 | {"type": "Polygon", "coordinates": [[[-117.22146, 33.82254], [-117.22143, 33.82281], [-117.22083, 33.82283], [-117.22084, 33.82245], [-117.21981, 33.8224], [-117.21975, 33.82263], [-117.21946, 33.82262], [-117.21943, 33.82277], [-117.21756, 33.82281], [-117.21749, 33.82274], [-117.21749, 33.81948], [-117.21758, 33.8194], [-117.21784, 33.81938], [-117.21788, 33.81979], [-117.21803, 33.81998], [-117.22078, 33.82232], [-117.22109, 33.82246], [-117.22146, 33.82254]]]} | Open Access 1 | 19869 | Paragon Park | 23409 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | Riverside 10 | 15.394 | Paragon Park | 0 | Local Park 2 | 4 | |
10712 | 10712 | 10711 | {"type": "Polygon", "coordinates": [[[-117.2226, 33.80668], [-117.2226, 33.80688], [-117.22237, 33.80757], [-117.22235, 33.80829], [-117.22118, 33.80829], [-117.22116, 33.80616], [-117.22126, 33.80614], [-117.22129, 33.80604], [-117.22131, 33.80534], [-117.22174, 33.80533], [-117.22166, 33.8049], [-117.22196, 33.80489], [-117.22201, 33.80552], [-117.22209, 33.80563], [-117.22225, 33.80566], [-117.22231, 33.80668], [-117.2226, 33.80668]]]} | Open Access 1 | 19870 | Copper Creek Park | 17628 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | Riverside 10 | 8.861 | Copper Creek Park | 0 | Local Park 2 | 4 | |
11995 | 11995 | 11994 | {"type": "MultiPolygon", "coordinates": [[[[-117.22935, 33.73821], [-117.22866, 33.73876], [-117.22889, 33.73903], [-117.22865, 33.73916], [-117.22836, 33.73929], [-117.22809, 33.73937], [-117.22782, 33.73942], [-117.22778, 33.73931], [-117.22785, 33.73923], [-117.22788, 33.73912], [-117.22786, 33.739], [-117.22777, 33.73885], [-117.22769, 33.73834], [-117.22762, 33.73819], [-117.2276, 33.73807], [-117.22764, 33.73797], [-117.22773, 33.73786], [-117.22792, 33.73777], [-117.22805, 33.73767], [-117.22826, 33.73759], [-117.22875, 33.73753], [-117.22881, 33.73782], [-117.2292, 33.73766], [-117.22927, 33.73772], [-117.22909, 33.73802], [-117.22935, 33.73821]]], [[[-117.22935, 33.73999], [-117.22899, 33.7404], [-117.22885, 33.74048], [-117.22861, 33.74056], [-117.22832, 33.74058], [-117.22815, 33.74057], [-117.22794, 33.73959], [-117.22815, 33.73954], [-117.22854, 33.73942], [-117.22876, 33.73932], [-117.22902, 33.73918], [-117.22927, 33.73946], [-117.22922, 33.73973], [-117.22923, 33.73983], [-117.22935, 33.73999]]]]} | Open Access 1 | 24653 | Monument Ranch Park | 22447 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | Riverside 10 | 8.557 | Monument Ranch Park | 0 | Local Park 2 | 4 | |
14708 | 14708 | 14707 | {"type": "MultiPolygon", "coordinates": [[[[-117.22872, 33.7773], [-117.22831, 33.77731], [-117.22788, 33.77723], [-117.22683, 33.7766], [-117.22871, 33.77659], [-117.22872, 33.7773]]], [[[-117.22872, 33.77766], [-117.22872, 33.77766], [-117.22856, 33.77755], [-117.22872, 33.77754], [-117.22872, 33.77766]]]]} | Open Access 1 | 45055 | Mercado Park | 28049 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://www.parks.ca.gov/?Page_id=26463 | Riverside 10 | 2.35 | Mercado Park | 0 | Local Park 2 | 4 |
14901 | 14901 | 14900 | {"type": "Polygon", "coordinates": [[[-117.20331, 33.82801], [-117.20331, 33.82811], [-117.20305, 33.82823], [-117.2028, 33.82828], [-117.2009, 33.82829], [-117.20067, 33.82826], [-117.20056, 33.82829], [-117.20006, 33.82829], [-117.20006, 33.82684], [-117.20188, 33.82684], [-117.20231, 33.82709], [-117.20266, 33.82735], [-117.20304, 33.82769], [-117.20331, 33.82801]]]} | Open Access 1 | 45453 | Liberty Park | 28258 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://www.cityofperris.org/residents/parks/parks/liberty-park.html | Riverside 10 | 9.984 | Liberty Park | 0 | Local Park 2 | 4 |
14902 | 14902 | 14901 | {"type": "Polygon", "coordinates": [[[-117.19176, 33.83854], [-117.19139, 33.83854], [-117.1914, 33.83929], [-117.19101, 33.83918], [-117.19081, 33.83909], [-117.19065, 33.83899], [-117.19043, 33.83883], [-117.19007, 33.83847], [-117.19007, 33.83839], [-117.19066, 33.83797], [-117.19092, 33.83773], [-117.1911, 33.83751], [-117.1912, 33.83748], [-117.19144, 33.83755], [-117.19169, 33.83758], [-117.1917, 33.83847], [-117.19176, 33.83854]]]} | Open Access 1 | 45454 | Frank Eaton Memorial Park | 28257 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://www.cityofperris.org/residents/parks/parks/frank-eaton-park.html | Riverside 10 | 4.423 | Frank Eaton Memorial Park | 0 | Local Park 2 | 4 |
14903 | 14903 | 14902 | {"type": "Polygon", "coordinates": [[[-117.21216, 33.83907], [-117.20865, 33.83908], [-117.20865, 33.8374], [-117.21216, 33.83739], [-117.21216, 33.83907]]]} | Open Access 1 | 45455 | Morgan Park | 28256 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://www.cityofperris.org/residents/parks/parks/morgan-park.html | Riverside 10 | 14.952 | Morgan Park | 0 | Local Park 2 | 4 |
14904 | 14904 | 14903 | {"type": "Polygon", "coordinates": [[[-117.1894, 33.82787], [-117.18909, 33.82788], [-117.18908, 33.8279], [-117.18702, 33.8279], [-117.18699, 33.8278], [-117.1869, 33.82772], [-117.1869, 33.8267], [-117.18897, 33.82669], [-117.18898, 33.82733], [-117.18935, 33.82734], [-117.1894, 33.82742], [-117.18942, 33.82749], [-117.18942, 33.82778], [-117.1894, 33.82787]]]} | Open Access 1 | 45456 | May Ranch Park | 28255 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://www.cityofperris.org/residents/parks/parks/may-ranch-park.html | Riverside 10 | 6.905 | May Ranch Park | 0 | Local Park 2 | 4 |
14905 | 14905 | 14904 | {"type": "Polygon", "coordinates": [[[-117.20841, 33.79369], [-117.20708, 33.79371], [-117.20708, 33.79261], [-117.2084, 33.79258], [-117.20841, 33.79369]]]} | Open Access 1 | 45458 | Patriot Park | 28261 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://www.cityofperris.org/residents/parks/parks/patriot-park.html | Riverside 10 | 3.698 | Patriot Park | 0 | Local Park 2 | 4 |
14906 | 14906 | 14905 | {"type": "Polygon", "coordinates": [[[-117.23464, 33.77386], [-117.23309, 33.77386], [-117.23308, 33.77214], [-117.23463, 33.77213], [-117.23464, 33.77386]]]} | Open Access 1 | 45459 | Rotary Park | 28260 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://www.cityofperris.org/residents/parks/parks/rotary-park.html | Riverside 10 | 6.795 | Rotary Park | 0 | Local Park 2 | 4 |
14907 | 14907 | 14906 | {"type": "Polygon", "coordinates": [[[-117.21722, 33.79009], [-117.21716, 33.79014], [-117.21519, 33.79015], [-117.21519, 33.78843], [-117.21609, 33.78842], [-117.21662, 33.78887], [-117.21678, 33.78905], [-117.2169, 33.7892], [-117.21702, 33.78939], [-117.21712, 33.78963], [-117.21718, 33.78985], [-117.21722, 33.79009]]]} | Open Access 1 | 45460 | Skydive Baseball Park | 28259 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://www.cityofperris.org/residents/parks/parks/skydive-park.html | Riverside 10 | 7.227 | Skydive Baseball Park | 0 | Local Park 2 | 4 |
3207 | 3207 | 3206 | {"type": "Polygon", "coordinates": [[[-116.45782, 33.80354], [-116.45775, 33.80354], [-116.45775, 33.80353], [-116.45733, 33.80318], [-116.45732, 33.80237], [-116.45718, 33.80209], [-116.45693, 33.80178], [-116.45654, 33.80169], [-116.45577, 33.80168], [-116.45534, 33.80181], [-116.45506, 33.80207], [-116.45499, 33.80207], [-116.45498, 33.80158], [-116.45772, 33.80157], [-116.4578, 33.80164], [-116.45782, 33.80354]]]} | Open Access 1 | 28137 | Patriot Park | 23512 | 1049 | Cathedral City, City of 595 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | Riverside 10 | 3.56 | Patriot Park | 0 | Local Park 2 | 4 | |
5398 | 5398 | 5397 | {"type": "Polygon", "coordinates": [[[-116.46342, 33.80566], [-116.46342, 33.80671], [-116.46339, 33.80676], [-116.46334, 33.80677], [-116.46152, 33.80678], [-116.46148, 33.80677], [-116.46145, 33.80674], [-116.46142, 33.80596], [-116.46182, 33.80595], [-116.46182, 33.8055], [-116.46243, 33.80549], [-116.46261, 33.8055], [-116.46303, 33.80549], [-116.46303, 33.80567], [-116.46342, 33.80566]]]} | Open Access 1 | 47903 | Ocotillo Park | 31989 | 1049 | Cathedral City, City of 595 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | http://www.cathedralcity.gov/Home/Components/FacilityDirectory/FacilityDirectory/12/1768 | Riverside 10 | 5.823 | Ocotillo Park | 0 | Local Park 2 | 4 |
10746 | 10746 | 10745 | {"type": "Polygon", "coordinates": [[[-116.44234, 33.82833], [-116.44229, 33.82838], [-116.44163, 33.82837], [-116.44146, 33.82835], [-116.44132, 33.82838], [-116.44093, 33.82838], [-116.44092, 33.82714], [-116.44101, 33.82706], [-116.44228, 33.82706], [-116.44233, 33.8271], [-116.44234, 33.82833]]]} | Open Access 1 | 19966 | Century Park | 17078 | 1049 | Cathedral City, City of 595 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | Riverside 10 | 4.677 | Century 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]);