units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where DES_TP = 2 and MNG_AGENCY = 156 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
AGNCY_LEV 3 ✖
- Special District 49
- Private 7
- City 1
MNG_AG_TYP 1
MNG_AGENCY 1
- Valley-Wide Recreation and Park District · 57 ✖
DES_TP 1
- Local Park · 57 ✖
ACCESS_TYP 1
- Open Access 57
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
14076 | 14076 | 14075 | {"type": "Polygon", "coordinates": [[[-117.15686, 33.69873], [-117.15685, 33.69915], [-117.1563, 33.69916], [-117.15626, 33.69919], [-117.15628, 33.69997], [-117.15634, 33.70004], [-117.15639, 33.70004], [-117.1564, 33.70034], [-117.15589, 33.70031], [-117.15545, 33.70012], [-117.15443, 33.69945], [-117.15435, 33.69919], [-117.15465, 33.69866], [-117.15483, 33.69828], [-117.15493, 33.69823], [-117.15632, 33.69856], [-117.15633, 33.69861], [-117.15637, 33.69863], [-117.15674, 33.69872], [-117.15686, 33.69873]]]} | Open Access 1 | 39114 | Aldergate Park | 15348 | 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 | 8.124 | Aldergate Park | 0 | Local Park 2 | 4 | |
14071 | 14071 | 14070 | {"type": "Polygon", "coordinates": [[[-117.16253, 33.66383], [-117.16252, 33.66493], [-117.16247, 33.66497], [-117.16218, 33.66497], [-117.16213, 33.66493], [-117.16211, 33.66466], [-117.16205, 33.66446], [-117.16195, 33.66425], [-117.16181, 33.66408], [-117.16181, 33.66403], [-117.16204, 33.6639], [-117.1621, 33.66382], [-117.16253, 33.66383]]]} | Open Access 1 | 39108 | Autumn Breeze Park | 15715 | 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.484 | Autumn Breeze 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 | |
5547 | 5547 | 5546 | {"type": "Polygon", "coordinates": [[[-116.91484, 33.75491], [-116.91479, 33.75495], [-116.91369, 33.75495], [-116.91368, 33.75334], [-116.9141, 33.7533], [-116.91482, 33.7533], [-116.91484, 33.75491]]]} | Open Access 1 | 39087 | Bill Gray Park | 16105 | 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 | 4.762 | Bill Gray Park | 0 | Local Park 2 | 4 | |
4414 | 4414 | 4413 | {"type": "Polygon", "coordinates": [[[-117.10295, 33.61494], [-117.10289, 33.61502], [-117.10284, 33.61516], [-117.10178, 33.61637], [-117.10172, 33.6164], [-117.10165, 33.61642], [-117.10128, 33.61638], [-117.10127, 33.6163], [-117.10121, 33.6163], [-117.10124, 33.61517], [-117.10122, 33.61452], [-117.10119, 33.61433], [-117.10114, 33.61419], [-117.10107, 33.61406], [-117.10076, 33.61419], [-117.10058, 33.6139], [-117.10062, 33.61381], [-117.10088, 33.61369], [-117.10141, 33.61349], [-117.10151, 33.61352], [-117.1018, 33.61394], [-117.10213, 33.61431], [-117.10251, 33.61463], [-117.10295, 33.61494]]]} | Open Access 1 | 48328 | Brookfield Park | 32890 | 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-park | Riverside 10 | 8.252 | Brookfield Park | 0 | Local Park 2 | 4 |
11964 | 11964 | 11963 | {"type": "Polygon", "coordinates": [[[-117.0966, 33.59065], [-117.09652, 33.59071], [-117.09467, 33.59071], [-117.09467, 33.59033], [-117.09462, 33.59028], [-117.09464, 33.59021], [-117.09463, 33.59014], [-117.09458, 33.5901], [-117.09451, 33.59007], [-117.09451, 33.58973], [-117.0966, 33.58973], [-117.0966, 33.59065]]]} | Open Access 1 | 48258 | Butterfield Park | 32812 | 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/butterfield-park | Riverside 10 | 5.011 | Butterfield 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 | |
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 |
4465 | 4465 | 4464 | {"type": "Polygon", "coordinates": [[[-116.91077, 33.47935], [-116.90845, 33.47939], [-116.90841, 33.47781], [-116.90988, 33.47778], [-116.9101, 33.47862], [-116.91077, 33.47862], [-116.91077, 33.47935]]]} | Open Access 1 | 48397 | Cottonwood Park | 32963 | 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 | 7.767 | Cottonwood Park | 0 | Local Park 2 | 4 | |
15384 | 15384 | 15383 | {"type": "Polygon", "coordinates": [[[-117.10681, 33.57934], [-117.10568, 33.58036], [-117.1054, 33.58065], [-117.10534, 33.58066], [-117.10466, 33.58035], [-117.10443, 33.5802], [-117.10424, 33.58001], [-117.10415, 33.57986], [-117.1041, 33.57976], [-117.10486, 33.57954], [-117.10466, 33.57863], [-117.10506, 33.57859], [-117.10533, 33.57861], [-117.10559, 33.57865], [-117.10585, 33.57871], [-117.1061, 33.57881], [-117.10643, 33.57899], [-117.10681, 33.57929], [-117.10681, 33.57934]]]} | Open Access 1 | 48331 | Crown Valley Park | 32894 | 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/crown-valley-park | Riverside 10 | 8.004 | Crown Valley 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 | |
14530 | 14530 | 14529 | {"type": "Polygon", "coordinates": [[[-116.99122, 33.70431], [-116.98836, 33.70483], [-116.98832, 33.70447], [-116.9881, 33.70417], [-116.98774, 33.70391], [-116.98732, 33.70372], [-116.98685, 33.70363], [-116.98649, 33.70367], [-116.98616, 33.70376], [-116.98571, 33.70384], [-116.98516, 33.70373], [-116.98444, 33.70319], [-116.98418, 33.70319], [-116.98331, 33.70296], [-116.98311, 33.70272], [-116.98287, 33.70237], [-116.98231, 33.70215], [-116.98164, 33.70201], [-116.98124, 33.70207], [-116.98106, 33.70207], [-116.98083, 33.70195], [-116.98095, 33.70139], [-116.98119, 33.70138], [-116.98148, 33.70133], [-116.98177, 33.70121], [-116.98204, 33.701], [-116.98228, 33.7007], [-116.98262, 33.6997], [-116.98616, 33.69994], [-116.98807, 33.70009], [-116.9889, 33.70009], [-116.98983, 33.69993], [-116.99006, 33.70029], [-116.99122, 33.70431]]]} | Open Access 1 | 48273 | Diamond Valley Lake Community Park | 32828 | 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/diamond-valley-lake-community-park | Riverside 10 | 83.298 | Diamond Valley Lake Community Park | 0 | Local Park 2 | 4 |
5889 | 5889 | 5888 | {"type": "Polygon", "coordinates": [[[-117.14273, 33.71059], [-117.14273, 33.71059], [-117.14015, 33.71058], [-117.1403, 33.71029], [-117.14052, 33.70999], [-117.14079, 33.70972], [-117.14111, 33.70949], [-117.14136, 33.70936], [-117.14176, 33.7092], [-117.14219, 33.70909], [-117.14264, 33.70905], [-117.14271, 33.70911], [-117.14273, 33.70959], [-117.14273, 33.71059]]]} | Open Access 1 | 48332 | Discovery Park | 32895 | 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/discovery | Riverside 10 | 7.306 | Discovery 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 | |
14077 | 14077 | 14076 | {"type": "Polygon", "coordinates": [[[-117.14763, 33.70309], [-117.14757, 33.70315], [-117.14622, 33.70314], [-117.14544, 33.70307], [-117.14539, 33.70302], [-117.14538, 33.70279], [-117.14577, 33.70264], [-117.14604, 33.70252], [-117.14638, 33.70233], [-117.14665, 33.70216], [-117.1468, 33.70229], [-117.14703, 33.70238], [-117.1471, 33.70244], [-117.14715, 33.70251], [-117.14719, 33.70262], [-117.14724, 33.70309], [-117.14763, 33.70309]]]} | Open Access 1 | 39115 | Eldorado Park | 18552 | 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 | 3.128 | Eldorado Park | 0 | Local Park 2 | 4 | |
14236 | 14236 | 14235 | {"type": "Polygon", "coordinates": [[[-117.17155, 33.74421], [-117.16954, 33.74422], [-117.16953, 33.74303], [-117.17041, 33.74301], [-117.17154, 33.7437], [-117.17155, 33.74421]]]} | Open Access 1 | 44114 | Eller Park | 18585 | 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 | 5.132 | Eller Park | 0 | Local Park 2 | 4 | |
5901 | 5901 | 5900 | {"type": "Polygon", "coordinates": [[[-117.10627, 33.60302], [-117.10626, 33.60307], [-117.10591, 33.60338], [-117.10576, 33.60354], [-117.10416, 33.60291], [-117.10415, 33.60211], [-117.10504, 33.60211], [-117.1052, 33.60213], [-117.10535, 33.60218], [-117.10548, 33.60225], [-117.1056, 33.60233], [-117.10627, 33.60302]]]} | Open Access 1 | 48333 | Emerald Park | 32896 | 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/emerald-park | Riverside 10 | 5.023 | Emerald Park | 0 | Local Park 2 | 4 |
3786 | 3786 | 3785 | {"type": "Polygon", "coordinates": [[[-117.08558, 33.59306], [-117.08555, 33.59312], [-117.08555, 33.59329], [-117.08551, 33.59349], [-117.08543, 33.59369], [-117.08546, 33.59379], [-117.08528, 33.59387], [-117.08528, 33.59418], [-117.08394, 33.59423], [-117.08395, 33.59249], [-117.08487, 33.59316], [-117.08525, 33.59289], [-117.08558, 33.59306]]]} | Open Access 1 | 48334 | Fieldview Park | 32897 | 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/fieldview-park | Riverside 10 | 5.007 | Fieldview Park | 0 | Local Park 2 | 4 |
14079 | 14079 | 14078 | {"type": "Polygon", "coordinates": [[[-117.14961, 33.72167], [-117.14957, 33.72188], [-117.14951, 33.72209], [-117.1493, 33.72259], [-117.14746, 33.72206], [-117.14735, 33.72196], [-117.1474, 33.72192], [-117.14775, 33.72118], [-117.14828, 33.72134], [-117.14869, 33.72144], [-117.14954, 33.72159], [-117.14961, 33.72167]]]} | Open Access 1 | 39117 | Heritage Park | 19862 | 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 | 4.834 | Heritage 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]);