units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where MNG_AGENCY = 156 and MNG_AG_TYP = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
DES_TP 3
- Local Park 57
- Local Recreation Area 9
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- Recreation/Parks District · 67 ✖
MNG_AGENCY 1
- Valley-Wide Recreation and Park District · 67 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14442 | 14442 | 14441 | {"type": "Polygon", "coordinates": [[[-117.09337, 33.59269], [-117.09337, 33.59287], [-117.09303, 33.59287], [-117.09303, 33.59269], [-117.09337, 33.59269]]]} | Open Access 1 | 48260 | Northfield Park | 32814 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/northfield-park | Riverside 10 | 0.152 | Northfield Park | 0 | Local Park 2 | 4 |
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 | |
6465 | 6465 | 6464 | {"type": "Polygon", "coordinates": [[[-117.10035, 33.59259], [-117.10035, 33.59281], [-117.09998, 33.59281], [-117.09998, 33.59259], [-117.10035, 33.59259]]]} | Open Access 1 | 48392 | Watermill Park | 32956 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/watermill-park | Riverside 10 | 0.202 | Watermill 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 | |
4162 | 4162 | 4161 | {"type": "Polygon", "coordinates": [[[-117.14454, 33.70443], [-117.14404, 33.70443], [-117.14404, 33.70421], [-117.14454, 33.70421], [-117.14454, 33.70443]]]} | Open Access 1 | 48377 | Mahogany Creek Pocket Park | 32944 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 0.282 | Mahogany Creek PP | 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 | |
14564 | 14564 | 14563 | {"type": "Polygon", "coordinates": [[[-117.14906, 33.69572], [-117.14903, 33.69575], [-117.14866, 33.69568], [-117.14869, 33.69561], [-117.14868, 33.69555], [-117.1486, 33.6954], [-117.14891, 33.69532], [-117.14906, 33.69572]]]} | Open Access 1 | 44687 | Richmond Park | 24341 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 0.305 | Richmond Park | 0 | Local Park 2 | 4 | |
14090 | 14090 | 14089 | {"type": "Polygon", "coordinates": [[[-117.14793, 33.70508], [-117.14765, 33.70532], [-117.14748, 33.70518], [-117.14733, 33.70503], [-117.14766, 33.70484], [-117.14793, 33.70508]]]} | Open Access 1 | 39119 | Eldorado Pocket Park | 18553 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 0.371 | Eldorado PP | 0 | Local Park 2 | 4 | |
14070 | 14070 | 14069 | {"type": "Polygon", "coordinates": [[[-117.15436, 33.65971], [-117.15425, 33.65986], [-117.15419, 33.66001], [-117.15416, 33.66016], [-117.15416, 33.66038], [-117.15407, 33.66045], [-117.15396, 33.66045], [-117.15397, 33.66005], [-117.15418, 33.65966], [-117.15431, 33.65967], [-117.15436, 33.65971]]]} | Open Access 1 | 39107 | Rolling Hills Park | 24582 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 0.378 | Rolling Hills Park | 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 | |
14074 | 14074 | 14073 | {"type": "Polygon", "coordinates": [[[-117.15164, 33.6899], [-117.15158, 33.69017], [-117.15137, 33.69015], [-117.1511, 33.69024], [-117.15102, 33.69011], [-117.15102, 33.69006], [-117.15117, 33.68993], [-117.15129, 33.68976], [-117.15164, 33.6899]]]} | Open Access 1 | 39111 | Desert Green | 18111 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 0.454 | Desert Green | 0 | Local Park 2 | 4 | |
5540 | 5540 | 5539 | {"type": "Polygon", "coordinates": [[[-117.09164, 33.59241], [-117.09164, 33.59294], [-117.09127, 33.59294], [-117.09128, 33.59241], [-117.09164, 33.59241]]]} | Open Access 1 | 48259 | Wagon Wheel Park | 32813 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/wagon-wheel-pocket-park | Riverside 10 | 0.493 | Wagon Wheel Park | 0 | Local Park 2 | 4 |
16254 | 16254 | 16253 | {"type": "Polygon", "coordinates": [[[-117.10095, 33.60539], [-117.10052, 33.6054], [-117.10037, 33.60502], [-117.10047, 33.60497], [-117.10048, 33.60498], [-117.10095, 33.60502], [-117.10095, 33.60539]]]} | Open Access 1 | 48330 | Brookfield Open Space | 32893 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/brookfield-open-sp | Riverside 10 | 0.518 | Brookfield OS | 0 | Local Recreation Area 3 | 4 |
4855 | 4855 | 4854 | {"type": "Polygon", "coordinates": [[[-117.1072, 33.57315], [-117.10686, 33.57344], [-117.10669, 33.57327], [-117.10654, 33.57305], [-117.10656, 33.57299], [-117.10691, 33.5728], [-117.1072, 33.57315]]]} | Open Access 1 | 48336 | Honey Pine Park | 32899 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/honey-pine-park | Riverside 10 | 0.576 | Honey Pine Park | 0 | Local Park 2 | 4 |
14551 | 14551 | 14550 | {"type": "Polygon", "coordinates": [[[-117.11078, 33.59922], [-117.11047, 33.59922], [-117.11042, 33.59918], [-117.11042, 33.59883], [-117.11047, 33.59862], [-117.11044, 33.59855], [-117.11077, 33.59833], [-117.11078, 33.59922]]]} | Open Access 1 | 48277 | Avignon Park | 32832 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 0.671 | Avignon Park | 0 | Local Park 2 | 4 | |
4856 | 4856 | 4855 | {"type": "Polygon", "coordinates": [[[-117.11195, 33.60932], [-117.11169, 33.6096], [-117.11136, 33.6097], [-117.11115, 33.60931], [-117.11144, 33.60917], [-117.11189, 33.6092], [-117.1119, 33.60926], [-117.11195, 33.60932]]]} | Open Access 1 | 48337 | Kona Park | 32900 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/kona-park | Riverside 10 | 0.69 | Kona Park | 0 | Local Park 2 | 4 |
14075 | 14075 | 14074 | {"type": "MultiPolygon", "coordinates": [[[[-117.15218, 33.69093], [-117.15194, 33.69101], [-117.15192, 33.69056], [-117.15197, 33.69021], [-117.15197, 33.69035], [-117.152, 33.69048], [-117.15218, 33.69093]]], [[[-117.15309, 33.68887], [-117.15291, 33.68904], [-117.15256, 33.68921], [-117.15238, 33.68933], [-117.15223, 33.68949], [-117.15213, 33.68967], [-117.15224, 33.68944], [-117.15241, 33.68916], [-117.15259, 33.68891], [-117.15279, 33.68869], [-117.1529, 33.68868], [-117.15309, 33.68882], [-117.15309, 33.68887]]]]} | Open Access 1 | 39112 | Pepita Square Park | 23592 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 0.768 | Pepita Square Park | 0 | Local Park 2 | 4 | |
5546 | 5546 | 5545 | {"type": "Polygon", "coordinates": [[[-117.01524, 33.75152], [-117.01524, 33.75213], [-117.01462, 33.75212], [-117.01463, 33.75152], [-117.01524, 33.75152]]]} | Open Access 1 | 39085 | Cawtson Park | 32962 | 1132 | Hemet, City of 143 | City 2 | City Agency 2 | http://www.cityofhemet.org/index.aspx?nid=95 | City 2 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/devonshire | Riverside 10 | 0.956 | Cawtson Park | 0 | Local Park 2 | 4 |
14443 | 14443 | 14442 | {"type": "Polygon", "coordinates": [[[-117.09722, 33.59201], [-117.09678, 33.59201], [-117.09676, 33.59226], [-117.09668, 33.59227], [-117.09652, 33.59204], [-117.09625, 33.59204], [-117.09621, 33.59183], [-117.09621, 33.59161], [-117.09646, 33.59165], [-117.09678, 33.59166], [-117.09722, 33.59161], [-117.09722, 33.59201]]]} | Open Access 1 | 48261 | Adeline's Farm Park | 32815 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/adeline-s-farm | Riverside 10 | 1.08 | Adeline's Farm Park | 0 | Local Park 2 | 4 |
14072 | 14072 | 14071 | {"type": "Polygon", "coordinates": [[[-117.16259, 33.65631], [-117.16258, 33.65695], [-117.16219, 33.65695], [-117.16219, 33.65684], [-117.16222, 33.65663], [-117.16219, 33.65655], [-117.16212, 33.65649], [-117.16201, 33.65647], [-117.16168, 33.65649], [-117.16168, 33.65618], [-117.16239, 33.65618], [-117.16247, 33.65627], [-117.16259, 33.65631]]]} | Open Access 1 | 39109 | Menifee South Tot Lot | 22155 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 1.114 | Menifee South Tot Lot | 0 | Local Recreation Area 3 | 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]);