units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where AGNCY_NAME = 167 and MNG_AGENCY = 163
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
416 | 416 | 415 | {"type": "Polygon", "coordinates": [[[-117.31368, 34.12421], [-117.31368, 34.12495], [-117.31262, 34.12495], [-117.31262, 34.1242], [-117.31368, 34.12421]]]} | Open Access 1 | 1286 | Gutierrez Field | 19573 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 1.988 | Gutierrez Field | 0 | Local Recreation Area 3 | 4 | |
652 | 652 | 651 | {"type": "Polygon", "coordinates": [[[-117.31369, 34.11112], [-117.31368, 34.11194], [-117.31272, 34.11194], [-117.31272, 34.11112], [-117.31369, 34.11112]]]} | Open Access 1 | 3196 | La Plaza Park | 20794 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 2.026 | La Plaza Park | 0 | Local Park 2 | 4 | |
716 | 716 | 715 | {"type": "Polygon", "coordinates": [[[-117.27592, 34.08551], [-117.27587, 34.08551], [-117.27587, 34.08575], [-117.27585, 34.08578], [-117.27582, 34.0858], [-117.27321, 34.0858], [-117.2732, 34.0828], [-117.27456, 34.08281], [-117.27456, 34.08462], [-117.27592, 34.08464], [-117.27592, 34.08551]]]} | Open Access 1 | 5364 | Mill Park | 22229 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 14.282 | Mill Park | 0 | Local Park 2 | 4 | |
805 | 805 | 804 | {"type": "Polygon", "coordinates": [[[-117.32007, 34.15316], [-117.31993, 34.15321], [-117.31979, 34.15329], [-117.31965, 34.15339], [-117.31954, 34.15352], [-117.31942, 34.15373], [-117.31939, 34.15388], [-117.31937, 34.154], [-117.31897, 34.15399], [-117.31873, 34.15401], [-117.3181, 34.1541], [-117.31786, 34.15409], [-117.31762, 34.15403], [-117.31747, 34.15396], [-117.31733, 34.15387], [-117.31717, 34.15371], [-117.31652, 34.15403], [-117.31592, 34.1532], [-117.31556, 34.15241], [-117.31557, 34.15019], [-117.31656, 34.15019], [-117.31656, 34.14974], [-117.31821, 34.14974], [-117.31822, 34.15004], [-117.31825, 34.1503], [-117.31854, 34.15205], [-117.31961, 34.15189], [-117.31972, 34.15233], [-117.31988, 34.15275], [-117.32007, 34.15316]]]} | Open Access 1 | 5222 | Blair Park | 16150 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 34.037 | Blair Park | 0 | Local Park 2 | 4 | |
1196 | 1196 | 1195 | {"type": "Polygon", "coordinates": [[[-117.32637, 34.1687], [-117.32627, 34.16927], [-117.3262, 34.16948], [-117.32609, 34.16972], [-117.32595, 34.16995], [-117.32515, 34.17112], [-117.32512, 34.17114], [-117.32507, 34.17114], [-117.32396, 34.17061], [-117.32494, 34.16918], [-117.32494, 34.16916], [-117.32485, 34.16912], [-117.32504, 34.16884], [-117.32461, 34.16863], [-117.32461, 34.16848], [-117.32545, 34.16848], [-117.32568, 34.1685], [-117.32588, 34.16854], [-117.32632, 34.16865], [-117.32637, 34.1687]]]} | Open Access 1 | 5671 | Hudson Park | 20135 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 8.976 | Hudson Park | 0 | Local Park 2 | 4 | |
1341 | 1341 | 1340 | {"type": "Polygon", "coordinates": [[[-117.26959, 34.11193], [-117.26877, 34.11194], [-117.26876, 34.11031], [-117.26959, 34.11031], [-117.26959, 34.11193]]]} | Open Access 1 | 7519 | Palm Field Park | 23337 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 3.376 | Palm Field Park | 0 | Local Recreation Area 3 | 4 | |
1470 | 1470 | 1469 | {"type": "Polygon", "coordinates": [[[-117.33099, 34.12506], [-117.32908, 34.12505], [-117.32908, 34.12249], [-117.32957, 34.12249], [-117.32958, 34.12235], [-117.33099, 34.12235], [-117.33099, 34.12506]]]} | Open Access 1 | 10046 | Anne Shirrells Park | 15504 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 12.915 | Anne Shirrells Park | 0 | Local Park 2 | 4 | |
1510 | 1510 | 1509 | {"type": "Polygon", "coordinates": [[[-117.31851, 34.11384], [-117.31737, 34.11384], [-117.31737, 34.11306], [-117.31851, 34.11305], [-117.31851, 34.11384]]]} | Open Access 1 | 10705 | Guadalupe Field Park | 19543 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 2.257 | Guadalupe Field Park | 0 | Local Recreation Area 3 | 4 | |
1544 | 1544 | 1543 | {"type": "Polygon", "coordinates": [[[-117.35071, 34.10496], [-117.34863, 34.10496], [-117.34863, 34.1032], [-117.34904, 34.1032], [-117.34906, 34.10322], [-117.35071, 34.10322], [-117.35071, 34.10496]]]} | Open Access 1 | 11343 | Nicholson Park | 22750 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 9.194 | Nicholson Park | 0 | Local Park 2 | 4 | |
1740 | 1740 | 1739 | {"type": "Polygon", "coordinates": [[[-117.28608, 34.16159], [-117.28607, 34.16208], [-117.28517, 34.16208], [-117.28517, 34.16159], [-117.28608, 34.16159]]]} | Open Access 1 | 12949 | Sierra Park | 25463 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 1.126 | Sierra Park | 0 | Local Park 2 | 4 | |
1742 | 1742 | 1741 | {"type": "Polygon", "coordinates": [[[-117.28878, 34.16535], [-117.28738, 34.16536], [-117.28738, 34.16502], [-117.28797, 34.16502], [-117.28822, 34.16498], [-117.28848, 34.16492], [-117.28871, 34.16492], [-117.28878, 34.16535]]]} | Open Access 1 | 12953 | Tom Gould Memorial Park | 26392 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 1.286 | Tom Gould Memorial Park | 0 | Local Park 2 | 4 | |
2776 | 2776 | 2775 | {"type": "Polygon", "coordinates": [[[-117.32965, 34.14366], [-117.32965, 34.14531], [-117.326, 34.1453], [-117.32535, 34.14463], [-117.32565, 34.14443], [-117.32553, 34.14429], [-117.32565, 34.14421], [-117.32564, 34.14418], [-117.32594, 34.14397], [-117.32512, 34.14311], [-117.32512, 34.14283], [-117.32607, 34.14283], [-117.32686, 34.14366], [-117.32965, 34.14366]]]} | Open Access 1 | 18537 | Delmann Heights Park | 18067 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 18.956 | Delmann Heights Park | 0 | Local Park 2 | 4 | |
2975 | 2975 | 2974 | {"type": "Polygon", "coordinates": [[[-117.29626, 34.11007], [-117.29428, 34.11007], [-117.29428, 34.10905], [-117.29576, 34.10905], [-117.29576, 34.10929], [-117.29625, 34.10929], [-117.29626, 34.11007]]]} | Open Access 1 | 20541 | Pioneer Park | 23730 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 4.828 | Pioneer Park | 0 | Local Park 2 | 4 | |
2985 | 2985 | 2984 | {"type": "Polygon", "coordinates": [[[-117.31073, 34.09496], [-117.31072, 34.09661], [-117.3106, 34.0966], [-117.31006, 34.09647], [-117.30965, 34.0964], [-117.30818, 34.09625], [-117.30776, 34.09617], [-117.30776, 34.09408], [-117.31063, 34.09407], [-117.31063, 34.09495], [-117.31073, 34.09496]]]} | Open Access 1 | 20539 | Lytle Creek Park | 21617 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 17.044 | Lytle Creek Park | 0 | Local Park 2 | 4 | |
3657 | 3657 | 3656 | {"type": "Polygon", "coordinates": [[[-117.31247, 34.11591], [-117.31247, 34.11755], [-117.3102, 34.11754], [-117.3102, 34.1159], [-117.31247, 34.11591]]]} | Open Access 1 | 29601 | Encanto Park | 18637 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 9.417 | Encanto Park | 0 | Local Park 2 | 4 | |
4282 | 4282 | 4281 | {"type": "Polygon", "coordinates": [[[-117.29023, 34.16234], [-117.28847, 34.16236], [-117.28852, 34.16031], [-117.28985, 34.16146], [-117.29023, 34.16204], [-117.29023, 34.16234]]]} | Open Access 1 | 47429 | Newmark Field | 31146 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 5.636 | Newmark Field | 0 | Local Recreation Area 3 | 4 | |
6079 | 6079 | 6078 | {"type": "MultiPolygon", "coordinates": [[[[-117.32855, 34.10797], [-117.3283, 34.10805], [-117.32803, 34.10812], [-117.32762, 34.10819], [-117.32737, 34.10819], [-117.32736, 34.10822], [-117.32217, 34.10821], [-117.32216, 34.10657], [-117.32632, 34.10657], [-117.32641, 34.10665], [-117.32677, 34.10686], [-117.32704, 34.10709], [-117.32737, 34.10731], [-117.32772, 34.10751], [-117.32821, 34.10774], [-117.32855, 34.10797]]], [[[-117.33095, 34.10656], [-117.33069, 34.10665], [-117.33043, 34.10676], [-117.33019, 34.10689], [-117.32996, 34.10703], [-117.32975, 34.10719], [-117.32935, 34.10751], [-117.32883, 34.10749], [-117.3282, 34.10728], [-117.32788, 34.10711], [-117.32762, 34.10693], [-117.32725, 34.10657], [-117.33095, 34.10656]]]]} | Open Access 1 | 878 | Nunez Park | 22939 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 27.263 | Nunez Park | 0 | Local Park 2 | 4 | |
6217 | 6217 | 6216 | {"type": "MultiPolygon", "coordinates": [[[[-117.37077, 34.20075], [-117.37071, 34.20084], [-117.36684, 34.19915], [-117.36835, 34.19679], [-117.37094, 34.1988], [-117.37102, 34.19888], [-117.37109, 34.19897], [-117.37114, 34.19909], [-117.37116, 34.19919], [-117.37115, 34.19932], [-117.37112, 34.19942], [-117.37053, 34.20032], [-117.37049, 34.20041], [-117.37049, 34.20052], [-117.37054, 34.20061], [-117.37063, 34.20068], [-117.37077, 34.20075]]], [[[-117.37161, 34.19909], [-117.37082, 34.20058], [-117.37074, 34.20055], [-117.37068, 34.20048], [-117.37069, 34.20041], [-117.37125, 34.19958], [-117.37131, 34.19946], [-117.37135, 34.19932], [-117.37135, 34.19914], [-117.3713, 34.19896], [-117.3712, 34.1988], [-117.37106, 34.19866], [-117.37161, 34.19909]]]]} | Open Access 1 | 1274 | Al Guhin Park | 15308 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 22.904 | Al Guhin Park | 0 | Local Park 2 | 4 | |
6304 | 6304 | 6303 | {"type": "MultiPolygon", "coordinates": [[[[-117.26387, 34.16253], [-117.26387, 34.16266], [-117.26384, 34.1627], [-117.26311, 34.16295], [-117.26287, 34.16304], [-117.26256, 34.16321], [-117.26233, 34.1634], [-117.26205, 34.16371], [-117.26188, 34.164], [-117.26183, 34.16419], [-117.26178, 34.1644], [-117.26178, 34.16485], [-117.26172, 34.16489], [-117.26142, 34.16488], [-117.26146, 34.16442], [-117.26146, 34.16414], [-117.26129, 34.1641], [-117.2623, 34.16295], [-117.2623, 34.16279], [-117.26182, 34.16278], [-117.26181, 34.16142], [-117.26348, 34.16143], [-117.26349, 34.16252], [-117.26387, 34.16253]]], [[[-117.26388, 34.16332], [-117.26369, 34.16332], [-117.2632, 34.16341], [-117.26301, 34.1635], [-117.26284, 34.16362], [-117.26269, 34.16375], [-117.26255, 34.16392], [-117.26242, 34.16424], [-117.26242, 34.16442], [-117.26233, 34.16442], [-117.2624, 34.16488], [-117.26207, 34.16488], [-117.26202, 34.16486], [-117.26201, 34.16483], [-117.26201, 34.16458], [-117.26203, 34.1644], [-117.26202, 34.16436], [-117.26208, 34.1641], [-117.26222, 34.16383], [-117.2624, 34.16362], [-117.26256, 34.16347], [-117.26275, 34.16332], [-117.26297, 34.1632], [-117.2638, 34.16292], [-117.26385, 34.16293], [-117.26387, 34.16296], [-117.26388, 34.16332]]]]} | Open Access 1 | 1456 | Harrison Canyon Park | 19697 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 10.834 | Harrison Canyon Park | 0 | Local Park 2 | 4 | |
6327 | 6327 | 6326 | {"type": "Polygon", "coordinates": [[[-117.30749, 34.09498], [-117.30538, 34.09499], [-117.30538, 34.09434], [-117.30548, 34.09433], [-117.30548, 34.09403], [-117.30749, 34.09403], [-117.30749, 34.09498]]]} | Restricted Access 2 | 47431 | Richardson School Field | 31149 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 5.028 | Richardson School Field | 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]);