units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
766 rows where COUNTY = 10 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, MNG_AG_LEV, YR_EST, GAP_STS
MNG_AGENCY >30
- Valley-Wide Recreation and Park District 67
- Riverside, City of 61
- Murrieta, City of 51
- Corona, City of 42
- Temecula, City of 42
- Moreno Valley, City of 39
- Riverside, County of 39
- San Jacinto, City of 33
- Lake Elsinore, City of 19
- Jurupa Area Recreation and Park District 18
- California Department of Fish and Wildlife 17
- La Quinta, City of 17
- Norco, City of 16
- Desert Recreation District 15
- Perris, City of 15
- Beaumont, City of 15
- Riverside County Habitat Conservation Agency 14
- Canyon Lake, City of 14
- Hemet, City of 11
- Indio, City of 11
- Palm Springs, City of 11
- United States Bureau of Land Management 10
- California Department of Parks and Recreation 10
- Coachella, City of 10
- Friends of the Desert Mountains 10
- Jurupa Community Services District 10
- Rivers and Lands Conservancy 10
- University of California 9
- Palm Desert, City of 9
- Riverside County Regional Park and Open Space District 8
- …
DES_TP >30
- Local Park 509
- Local Recreation Area 60
- State Conservation Area 26
- Local Conservation Area 24
- Private Conservation 17
- Local Other or Unknown 14
- National Monument or Landmark 13
- Private Other or Unknown 13
- State Resource Management Area 6
- National Park 5
- State Recreation Area 4
- State Other or Unknown 4
- State Park 3
- Private Recreation or Education 3
- National Public Lands 2
- National Forest 2
- Local Historic or Cultural Area 2
- Wilderness Area 2
- Federal Other or Unknown 2
- Area of Critical Environmental Concern 2
- None 1
- None 1
- Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 14
- City Agency 460
- Recreation/Parks District 110
- State Agency 54
- County Agency 40
- Non Profit - Land Trust 29
- Federal Agency 23
- Open Space District 21
- Community Services District 10
- Water District 7
- Home Owners Association 5
- Non Profit - Conservation 2
- Non Profit - Other 2
- Metropolitan Planning Organization 2
- Irrigation District 1
ACCESS_TYP 4
- Open Access 678
- Restricted Access 44
- No Public Access 28
- Unknown Access 16
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 | |
4163 | 4163 | 4162 | {"type": "Polygon", "coordinates": [[[-117.13273, 33.61299], [-117.13267, 33.61334], [-117.13238, 33.61333], [-117.13235, 33.61297], [-117.13273, 33.61299]]]} | Open Access 1 | 48381 | Mahogany Meadows Pocket Park | 32945 | 6124 | Mahogany Hills Home Owner Association 727 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/mahogany-meadows-pocket-park | Riverside 10 | 0.3 | Mahogany Meadows PP | 0 | Local Park 2 | 4 | |
4456 | 4456 | 4455 | {"type": "Polygon", "coordinates": [[[-117.1099, 33.59108], [-117.10987, 33.59122], [-117.10982, 33.59131], [-117.10976, 33.59136], [-117.10963, 33.59141], [-117.10945, 33.59141], [-117.1093, 33.59153], [-117.10929, 33.59152], [-117.10934, 33.59147], [-117.10936, 33.5914], [-117.10933, 33.59112], [-117.10941, 33.59108], [-117.1099, 33.59108]]]} | Open Access 1 | 48396 | Capri Park | 32961 | 6123 | Brindisi Owners Association 763 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/capri-pocket-park | Riverside 10 | 0.419 | Capri Park | 0 | Local Park 2 | 4 | |
4476 | 4476 | 4475 | {"type": "Polygon", "coordinates": [[[-117.65558, 33.90986], [-117.6554, 33.91873], [-117.65315, 33.91871], [-117.65252, 33.91691], [-117.65255, 33.91689], [-117.65245, 33.9166], [-117.65241, 33.91659], [-117.65165, 33.91438], [-117.65169, 33.91436], [-117.65166, 33.91426], [-117.65161, 33.91426], [-117.65146, 33.91385], [-117.6516, 33.91359], [-117.65131, 33.91341], [-117.65124, 33.91319], [-117.6516, 33.9131], [-117.65161, 33.91309], [-117.65123, 33.91201], [-117.65089, 33.91209], [-117.65019, 33.91006], [-117.65189, 33.91007], [-117.65558, 33.90986]]]} | Open Access 1 | 3702 | Unnamed site - Other Federal | 28636 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Riverside 10 | 83.657 | 0 | Federal Other or Unknown 87 | 4 | |||
4488 | 4488 | 4487 | {"type": "Polygon", "coordinates": [[[-117.65093, 33.90642], [-117.64926, 33.90648], [-117.64867, 33.90481], [-117.64847, 33.90433], [-117.64801, 33.90334], [-117.65091, 33.90307], [-117.65093, 33.90642]]]} | Open Access 1 | 4845 | Unnamed site - Other Federal | 28636 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Riverside 10 | 18.733 | 0 | Federal Other or Unknown 87 | 4 | |||
5068 | 5068 | 5067 | {"type": "Polygon", "coordinates": [[[-116.81544, 33.65099], [-116.80691, 33.65114], [-116.80684, 33.64208], [-116.8047, 33.64211], [-116.80467, 33.64032], [-116.8025, 33.64032], [-116.80249, 33.63844], [-116.79816, 33.63837], [-116.79814, 33.63666], [-116.80466, 33.63671], [-116.80469, 33.63843], [-116.8068, 33.63845], [-116.80683, 33.64023], [-116.81105, 33.64011], [-116.8111, 33.64388], [-116.81536, 33.64383], [-116.81544, 33.65099]]]} | Open Access 1 | 14230 | California State Lands Commission | 16727 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Riverside 10 | 255.037 | SLC | None 417 | ||||
5258 | 5258 | 5257 | {"type": "Polygon", "coordinates": [[[-117.1093, 33.59153], [-117.1089, 33.59184], [-117.10882, 33.59184], [-117.10882, 33.59154], [-117.10915, 33.59157], [-117.10922, 33.59155], [-117.10929, 33.59152], [-117.1093, 33.59153]]]} | Open Access 1 | 48383 | Pompei Pocket Park | 32947 | 6123 | Brindisi Owners Association 763 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/pompei-pocket-park | Riverside 10 | 0.197 | Pompei PP | 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 | ||
6391 | 6391 | 6390 | {"type": "Polygon", "coordinates": [[[-117.10569, 33.59244], [-117.10566, 33.59249], [-117.10549, 33.59255], [-117.10527, 33.59259], [-117.10527, 33.59237], [-117.10566, 33.59232], [-117.10569, 33.59244]]]} | Open Access 1 | 48388 | Sicily Pocket Park | 32952 | 6123 | Brindisi Owners Association 763 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/sicily-pocket-park | Riverside 10 | 0.212 | Sicily PP | 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 |
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]);