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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16345 | 16345 | 16344 | {"type": "Polygon", "coordinates": [[[-116.97842, 33.77656], [-116.97832, 33.77656], [-116.97832, 33.77675], [-116.97407, 33.77677], [-116.97406, 33.77478], [-116.97515, 33.77477], [-116.97514, 33.77305], [-116.97822, 33.77304], [-116.97831, 33.7731], [-116.97831, 33.77395], [-116.97834, 33.7741], [-116.97841, 33.77424], [-116.97842, 33.77656]]]} | Open Access 1 | 14964 | Valley-Wide Regional Park | 26784 | 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 | 35.973 | Valley-Wide RP | 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 |
15723 | 15723 | 15722 | {"type": "Polygon", "coordinates": [[[-116.96711, 33.7251], [-116.96673, 33.72511], [-116.96673, 33.72566], [-116.96295, 33.72571], [-116.96294, 33.7238], [-116.9636, 33.7238], [-116.96476, 33.72315], [-116.96711, 33.72285], [-116.96711, 33.7251]]]} | Restricted Access 2 | 48274 | Echo Hills Golf Course | 32829 | 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 | 25.113 | Echo Hills GC | 0 | Local Recreation Area 3 | 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 |
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 | |
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 | |
14550 | 14550 | 14549 | {"type": "Polygon", "coordinates": [[[-117.10104, 33.61814], [-117.10099, 33.61814], [-117.09946, 33.61994], [-117.09898, 33.61995], [-117.09889, 33.61989], [-117.09899, 33.61985], [-117.09924, 33.6196], [-117.09936, 33.61964], [-117.0994, 33.6196], [-117.09934, 33.61951], [-117.09946, 33.61938], [-117.09904, 33.61905], [-117.09888, 33.61919], [-117.09878, 33.61912], [-117.09873, 33.61915], [-117.09878, 33.61926], [-117.09857, 33.6194], [-117.0983, 33.6194], [-117.09822, 33.61937], [-117.09817, 33.61938], [-117.09814, 33.61941], [-117.09791, 33.61928], [-117.09793, 33.61925], [-117.09829, 33.61916], [-117.09853, 33.61889], [-117.09858, 33.61865], [-117.09868, 33.61843], [-117.09879, 33.61824], [-117.09903, 33.61795], [-117.09915, 33.61771], [-117.0992, 33.61745], [-117.09919, 33.61714], [-117.09914, 33.61694], [-117.09893, 33.61631], [-117.10101, 33.6163], [-117.10104, 33.61814]]]} | Open Access 1 | 48276 | Abelia Sports Park | 32831 | 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 | 15.608 | Abelia Sports Park | 0 | Local Recreation Area 3 | 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 |
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 |
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 |
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 | |
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 | |
14089 | 14089 | 14088 | {"type": "Polygon", "coordinates": [[[-117.13888, 33.74651], [-117.13887, 33.7486], [-117.1367, 33.74859], [-117.13669, 33.74665], [-117.13673, 33.74659], [-117.13697, 33.74659], [-117.13726, 33.74664], [-117.13732, 33.74663], [-117.13738, 33.74659], [-117.13741, 33.7465], [-117.13888, 33.74651]]]} | Open Access 1 | 39121 | Marion V. Ashley Community Center | 21864 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 11.364 | Marion V. Ashley Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
14082 | 14082 | 14081 | {"type": "Polygon", "coordinates": [[[-117.15673, 33.67968], [-117.15672, 33.67997], [-117.15508, 33.67957], [-117.154, 33.67957], [-117.15405, 33.67926], [-117.15418, 33.6788], [-117.15436, 33.67842], [-117.15447, 33.67839], [-117.15473, 33.6785], [-117.15475, 33.67856], [-117.15467, 33.67872], [-117.15467, 33.67873], [-117.15492, 33.67884], [-117.1558, 33.67911], [-117.1559, 33.67912], [-117.15581, 33.6794], [-117.15645, 33.67957], [-117.15646, 33.67968], [-117.15673, 33.67968]]]} | Open Access 1 | 39120 | La Paloma Park | 20782 | 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.355 | La Paloma Park | 0 | Local Park 2 | 4 | |
14081 | 14081 | 14080 | {"type": "Polygon", "coordinates": [[[-117.16386, 33.71398], [-117.16386, 33.71433], [-117.16368, 33.71428], [-117.16356, 33.71428], [-117.16349, 33.71432], [-117.16345, 33.7144], [-117.16348, 33.71448], [-117.16355, 33.71454], [-117.16364, 33.71455], [-117.16375, 33.71452], [-117.16373, 33.71507], [-117.16354, 33.71506], [-117.1633, 33.71503], [-117.16324, 33.71504], [-117.16317, 33.71508], [-117.16267, 33.71498], [-117.1626, 33.71498], [-117.16259, 33.71397], [-117.16386, 33.71398]]]} | Open Access 1 | 39118 | McCall Canyon Park | 21989 | 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.034 | McCall Canyon 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 | |
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 | |
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 | |
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 | |
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 |
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]);