units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where ACCESS_TYP = 1 and AGNCY_NAME = 160
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 49
- Local Recreation Area 7
- None 1
MNG_AG_TYP 1
MNG_AGENCY 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
385 | 385 | 384 | {"type": "Polygon", "coordinates": [[[-117.15388, 33.67064], [-117.15386, 33.67362], [-117.15375, 33.67366], [-117.15354, 33.67338], [-117.15342, 33.6733], [-117.15342, 33.67327], [-117.15317, 33.67312], [-117.15276, 33.67299], [-117.15275, 33.67297], [-117.15218, 33.67273], [-117.1521, 33.67268], [-117.15205, 33.67268], [-117.15209, 33.67232], [-117.15206, 33.67228], [-117.15172, 33.67207], [-117.15166, 33.67209], [-117.15161, 33.67209], [-117.15158, 33.67206], [-117.15137, 33.67206], [-117.15114, 33.67216], [-117.15096, 33.67243], [-117.15097, 33.67245], [-117.15093, 33.67262], [-117.15094, 33.67265], [-117.15089, 33.67283], [-117.15091, 33.67286], [-117.15091, 33.67306], [-117.15088, 33.67306], [-117.15083, 33.67326], [-117.15041, 33.67303], [-117.15016, 33.67299], [-117.14999, 33.67287], [-117.14973, 33.67259], [-117.14955, 33.67245], [-117.14936, 33.67232], [-117.14933, 33.67232], [-117.14914, 33.6722], [-117.14911, 33.6722], [-117.14903, 33.67215], [-117.14888, 33.67217], [-117.14849, 33.67226], [-117.1482, 33.67272], [-117.14817, 33.6727], [-117.14817, 33.67261], [-117.14814, 33.67256], [-117.1481, 33.67252], [-117.14802, 33.67247], [-117.14821, 33.67255], [-117.14865, 33.67182], [-117.14797, 33.67065], [-117.14945, 33.67065], [-117.14949, 33.67069], [-117.14974, 33.67069], [-117.14978, 33.67065], [-117.15154, 33.67065], [-117.15159, 33.67069], [-117.15184, 33.67069], [-117.15188, 33.67065], [-117.15388, 33.67064]]]} | Open Access 1 | 48338 | Lago Vista Sports Park | 32901 | 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/lago-vista-sports-park | Riverside 10 | 28.451 | Lago Vista Sports Park | 0 | Local Recreation Area 3 | 4 |
557 | 557 | 556 | {"type": "Polygon", "coordinates": [[[-117.10253, 33.61115], [-117.1013, 33.61115], [-117.10128, 33.60911], [-117.10251, 33.60901], [-117.10253, 33.61115]]]} | Open Access 1 | 48384 | Pourroy Fields | 32948 | 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/pourroy-fields | Riverside 10 | 6.552 | Pourroy Fields | 0 | Local Recreation Area 3 | 4 |
558 | 558 | 557 | {"type": "Polygon", "coordinates": [[[-117.10871, 33.60376], [-117.10807, 33.60376], [-117.10803, 33.6038], [-117.10795, 33.60373], [-117.108, 33.60362], [-117.10791, 33.60312], [-117.10865, 33.60308], [-117.10871, 33.60312], [-117.10871, 33.60376]]]} | Open Access 1 | 48385 | Primrose Park | 32949 | 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/primrose-park | Riverside 10 | 1.259 | Primrose Park | 0 | Local Park 2 | 4 |
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 | |
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 |
4146 | 4146 | 4145 | {"type": "Polygon", "coordinates": [[[-116.89403, 33.75911], [-116.89402, 33.7592], [-116.89372, 33.75945], [-116.89348, 33.75971], [-116.89336, 33.7599], [-116.89326, 33.7601], [-116.89319, 33.76013], [-116.89307, 33.7601], [-116.89305, 33.75874], [-116.8932, 33.75873], [-116.89319, 33.75788], [-116.89322, 33.75789], [-116.89332, 33.75814], [-116.89345, 33.75837], [-116.89366, 33.75869], [-116.89321, 33.75894], [-116.89321, 33.75895], [-116.89355, 33.75931], [-116.89398, 33.75906], [-116.89403, 33.75911]]]} | Open Access 1 | 48275 | Valle Vista | 32830 | 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.045 | Valle Vista | 0 | None 357 | ||
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 | |
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 |
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 | |
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 |
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 |
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 |
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 | |
5633 | 5633 | 5632 | {"type": "Polygon", "coordinates": [[[-117.08924, 33.70343], [-117.08706, 33.70344], [-117.08706, 33.7026], [-117.08923, 33.7026], [-117.08924, 33.70343]]]} | Open Access 1 | 48394 | Winchester Park | 32958 | 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/winchester-park | Riverside 10 | 4.619 | Winchester 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 |
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 |
5999 | 5999 | 5998 | {"type": "Polygon", "coordinates": [[[-117.12996, 33.61098], [-117.12958, 33.61131], [-117.12915, 33.61159], [-117.12869, 33.61184], [-117.12814, 33.61205], [-117.12717, 33.60728], [-117.12708, 33.60616], [-117.12737, 33.60655], [-117.1276, 33.60697], [-117.12776, 33.60736], [-117.12796, 33.60806], [-117.12807, 33.60837], [-117.12822, 33.60871], [-117.1284, 33.60904], [-117.12873, 33.60952], [-117.12905, 33.60992], [-117.12941, 33.61028], [-117.12991, 33.61069], [-117.12996, 33.61098]]]} | Open Access 1 | 48335 | Heroes Park | 32898 | 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/heroes-park | Riverside 10 | 14.343 | Heroes Park | 0 | Local Park 2 | 4 |
6376 | 6376 | 6375 | {"type": "Polygon", "coordinates": [[[-117.14505, 33.7032], [-117.1446, 33.7032], [-117.14454, 33.70316], [-117.14445, 33.70315], [-117.14422, 33.70317], [-117.14302, 33.70317], [-117.14301, 33.70325], [-117.14217, 33.70324], [-117.14155, 33.70321], [-117.14142, 33.70306], [-117.14087, 33.70291], [-117.14087, 33.70237], [-117.14228, 33.7028], [-117.14268, 33.70289], [-117.14308, 33.70294], [-117.1436, 33.70297], [-117.14407, 33.70296], [-117.14459, 33.70289], [-117.14505, 33.70279], [-117.14505, 33.7032]]]} | Open Access 1 | 48376 | Mahogany Creek Park | 32943 | 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/mahogany-creek-park-8d59dd1 | Riverside 10 | 3.939 | Mahogany Creek 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]);