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 PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3716 | 3716 | 3715 | {"type": "Polygon", "coordinates": [[[-117.14745, 33.63659], [-117.14744, 33.63711], [-117.1473, 33.63771], [-117.14628, 33.6377], [-117.1457, 33.63776], [-117.14565, 33.63775], [-117.14565, 33.63773], [-117.14561, 33.63772], [-117.14558, 33.63768], [-117.14557, 33.6362], [-117.14581, 33.6362], [-117.14597, 33.63623], [-117.14633, 33.63635], [-117.14648, 33.63646], [-117.14666, 33.63664], [-117.14703, 33.63668], [-117.14745, 33.63659]]]} | Open Access 1 | 44686 | Woodbine Park | 27682 | 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.864 | Woodbine Park | 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 | |
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 | |
5283 | 5283 | 5282 | {"type": "Polygon", "coordinates": [[[-117.12889, 33.61282], [-117.12851, 33.61291], [-117.12886, 33.61428], [-117.12859, 33.61432], [-117.12851, 33.61411], [-117.12842, 33.61354], [-117.1283, 33.61315], [-117.1283, 33.61293], [-117.12828, 33.61271], [-117.12798, 33.6127], [-117.128, 33.61263], [-117.12799, 33.61259], [-117.12794, 33.61253], [-117.12789, 33.61251], [-117.1278, 33.61251], [-117.12774, 33.61254], [-117.12769, 33.61249], [-117.12733, 33.61255], [-117.12733, 33.61251], [-117.12788, 33.61241], [-117.12845, 33.61224], [-117.12854, 33.61226], [-117.12889, 33.61282]]]} | Open Access 1 | 48401 | Linear Workout Park | 32968 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 2.073 | Linear Workout 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 | |
5551 | 5551 | 5550 | {"type": "Polygon", "coordinates": [[[-117.16102, 33.67575], [-117.1606, 33.67571], [-117.16019, 33.67569], [-117.15874, 33.67568], [-117.15832, 33.67565], [-117.15805, 33.6756], [-117.15778, 33.67551], [-117.15753, 33.6754], [-117.15729, 33.67527], [-117.15728, 33.67518], [-117.15756, 33.67483], [-117.15769, 33.67465], [-117.15792, 33.67428], [-117.1581, 33.67388], [-117.15817, 33.67368], [-117.15829, 33.67327], [-117.15836, 33.67286], [-117.15838, 33.67265], [-117.15838, 33.67219], [-117.16102, 33.67219], [-117.16102, 33.67575]]]} | Open Access 1 | 39105 | Wheatfield Park | 27450 | 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 | 26.885 | Wheatfield Park | 0 | Local Park 2 | 4 | |
5552 | 5552 | 5551 | {"type": "Polygon", "coordinates": [[[-117.1538, 33.6642], [-117.15379, 33.66552], [-117.15334, 33.66552], [-117.15332, 33.66547], [-117.15329, 33.66544], [-117.15319, 33.66541], [-117.15318, 33.66512], [-117.15301, 33.66491], [-117.15266, 33.66491], [-117.15334, 33.6642], [-117.1538, 33.6642]]]} | Open Access 1 | 39106 | Hidden Meadows Park | 19909 | 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 | 2.398 | Hidden Meadows Park | 0 | Local Park 2 | 4 | |
6821 | 6821 | 6820 | {"type": "Polygon", "coordinates": [[[-116.95223, 33.78381], [-116.95117, 33.78381], [-116.95116, 33.78295], [-116.95223, 33.78295], [-116.95223, 33.78381]]]} | Open Access 1 | 5395 | Mistletoe Park | 22319 | 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 | 2.338 | Mistletoe Park | 0 | Local Park 2 | 4 | |
8487 | 8487 | 8486 | {"type": "Polygon", "coordinates": [[[-116.89516, 33.73953], [-116.89482, 33.73953], [-116.89475, 33.73958], [-116.89469, 33.73967], [-116.89468, 33.73973], [-116.89469, 33.73984], [-116.89473, 33.73995], [-116.8947, 33.73996], [-116.8947, 33.7402], [-116.89484, 33.74024], [-116.89493, 33.74035], [-116.89516, 33.74035], [-116.89515, 33.74049], [-116.89326, 33.74049], [-116.89328, 33.73866], [-116.89512, 33.73866], [-116.89515, 33.73902], [-116.89516, 33.73953]]]} | Open Access 1 | 48497 | Jim Venable Exchange Club Park | 33315 | 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.857 | Jim Venable Exchange Club Park | 2019 | Local Park 2 | 4 | |
11359 | 11359 | 11358 | {"type": "Polygon", "coordinates": [[[-116.94753, 33.77378], [-116.94645, 33.77378], [-116.94643, 33.77353], [-116.94504, 33.7735], [-116.94411, 33.77344], [-116.94409, 33.77242], [-116.94607, 33.7724], [-116.94608, 33.7727], [-116.94639, 33.77271], [-116.94641, 33.77315], [-116.94752, 33.77314], [-116.94753, 33.77378]]]} | Open Access 1 | 22144 | Rancho Park | 24162 | 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.893 | Rancho Park | 0 | Local Park 2 | 4 | |
12142 | 12142 | 12141 | {"type": "MultiPolygon", "coordinates": [[[[-116.97389, 33.8206], [-116.97385, 33.82061], [-116.97383, 33.82076], [-116.97369, 33.82132], [-116.97296, 33.82208], [-116.97298, 33.82244], [-116.97248, 33.82236], [-116.97231, 33.82235], [-116.97213, 33.82237], [-116.97195, 33.82241], [-116.97081, 33.82281], [-116.97085, 33.82284], [-116.97079, 33.82283], [-116.96955, 33.8221], [-116.96917, 33.82185], [-116.96942, 33.82193], [-116.96943, 33.82192], [-116.96882, 33.82151], [-116.96728, 33.82063], [-116.96925, 33.81896], [-116.96925, 33.81895], [-116.96475, 33.81713], [-116.96418, 33.81688], [-116.96355, 33.81655], [-116.96625, 33.81654], [-116.97061, 33.81781], [-116.97216, 33.81651], [-116.97221, 33.81651], [-116.97236, 33.81694], [-116.97251, 33.81729], [-116.97379, 33.82002], [-116.97388, 33.82032], [-116.97389, 33.8206]]], [[[-116.97209, 33.8164], [-116.97063, 33.81762], [-116.9669, 33.81654], [-116.96703, 33.81654], [-116.96704, 33.81653], [-116.96683, 33.81645], [-116.96679, 33.81605], [-116.97207, 33.81627], [-116.97209, 33.8164]]], [[[-116.97454, 33.82302], [-116.97444, 33.82314], [-116.97395, 33.82284], [-116.97396, 33.82281], [-116.97385, 33.82274], [-116.97377, 33.82265], [-116.9737, 33.8225], [-116.97369, 33.82241], [-116.97369, 33.82231], [-116.97398, 33.82117], [-116.97439, 33.82263], [-116.97454, 33.82302]]]]} | Open Access 1 | 25115 | San Jacinto River Park | 24905 | 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 | 88.777 | San Jacinto River Park | 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 | |
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 | |
14073 | 14073 | 14072 | {"type": "Polygon", "coordinates": [[[-117.14326, 33.64858], [-117.1413, 33.64859], [-117.14122, 33.64855], [-117.14121, 33.64736], [-117.14148, 33.64737], [-117.14174, 33.64742], [-117.14201, 33.64743], [-117.14202, 33.64752], [-117.14256, 33.64752], [-117.14271, 33.64761], [-117.14326, 33.64761], [-117.14326, 33.64858]]]} | Open Access 1 | 39110 | Mira Park | 22276 | 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.662 | Mira 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 | |
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 | |
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 | |
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 | |
14078 | 14078 | 14077 | {"type": "MultiPolygon", "coordinates": [[[[-117.15071, 33.71106], [-117.15047, 33.71125], [-117.1483, 33.70945], [-117.14795, 33.70921], [-117.14757, 33.70902], [-117.14736, 33.70894], [-117.14712, 33.70887], [-117.14666, 33.70878], [-117.1463, 33.70876], [-117.14549, 33.70876], [-117.1454, 33.70869], [-117.14539, 33.70708], [-117.14555, 33.70695], [-117.14757, 33.70698], [-117.14756, 33.70842], [-117.14855, 33.70924], [-117.14851, 33.70929], [-117.15071, 33.71106]]], [[[-117.15379, 33.71395], [-117.15075, 33.7115], [-117.15065, 33.71141], [-117.15092, 33.7112], [-117.15111, 33.71138], [-117.15131, 33.71153], [-117.15146, 33.71167], [-117.15149, 33.71168], [-117.15164, 33.71182], [-117.15166, 33.71182], [-117.15182, 33.71196], [-117.15378, 33.71354], [-117.15379, 33.71395]]]]} | Open Access 1 | 39116 | Sunrise Park | 26028 | 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 | 16.289 | Sunrise 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]);