units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where ACCESS_TYP = 1, AGNCY_NAME = 83 and DES_TP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
204 | 204 | 203 | {"type": "Polygon", "coordinates": [[[-117.02997, 34.03356], [-117.02997, 34.03377], [-117.02941, 34.03377], [-117.02914, 34.03394], [-117.02885, 34.03399], [-117.02788, 34.03405], [-117.02754, 34.03409], [-117.02722, 34.03415], [-117.0269, 34.03424], [-117.02635, 34.03442], [-117.02582, 34.03455], [-117.02582, 34.03393], [-117.02624, 34.03374], [-117.02655, 34.03364], [-117.02714, 34.03341], [-117.02743, 34.03333], [-117.02775, 34.03332], [-117.02809, 34.03329], [-117.02842, 34.03316], [-117.02872, 34.03302], [-117.02896, 34.033], [-117.02925, 34.03307], [-117.02953, 34.03319], [-117.02978, 34.03334], [-117.02997, 34.03356]]]} | Open Access 1 | 549 | Flag Hill Veterans Memorial Park | 18934 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 7.782 | Flag Hill Veterans Memorial Park | 0 | Local Park 2 | 4 | |
1605 | 1605 | 1604 | {"type": "Polygon", "coordinates": [[[-117.0606, 34.00857], [-117.06059, 34.00958], [-117.05997, 34.00973], [-117.05876, 34.01027], [-117.05774, 34.01012], [-117.05774, 34.00862], [-117.05777, 34.00858], [-117.0606, 34.00857]]]} | Open Access 1 | 13579 | Avenue I Park | 15725 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 10.261 | Avenue I Park | 0 | Local Park 2 | 4 | |
2736 | 2736 | 2735 | {"type": "Polygon", "coordinates": [[[-117.06482, 34.02935], [-117.06276, 34.02935], [-117.06276, 34.02844], [-117.06105, 34.02844], [-117.06104, 34.02824], [-117.06068, 34.02824], [-117.06068, 34.028], [-117.06226, 34.02701], [-117.06227, 34.02671], [-117.06276, 34.02671], [-117.06277, 34.02675], [-117.06478, 34.02675], [-117.06482, 34.0268], [-117.06482, 34.02935]]]} | Open Access 1 | 18387 | 7th Street Park | 15216 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 19.264 | 7th Street Park | 0 | Local Park 2 | 4 | |
3805 | 3805 | 3804 | {"type": "Polygon", "coordinates": [[[-116.9995, 34.04903], [-116.99943, 34.06273], [-116.99495, 34.06294], [-116.99063, 34.06317], [-116.98635, 34.06342], [-116.98636, 34.05627], [-116.99075, 34.05601], [-116.99075, 34.05284], [-116.99567, 34.0507], [-116.99568, 34.05225], [-116.99773, 34.05246], [-116.99774, 34.0498], [-116.9995, 34.04903]]]} | Open Access 1 | 35153 | El Dorado Ranch Park | 15122 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 333.114 | El Dorado Ranch Park | 0 | Local Park 2 | 4 | |
4214 | 4214 | 4213 | {"type": "Polygon", "coordinates": [[[-117.08475, 34.02397], [-117.08434, 34.02442], [-117.0841, 34.02475], [-117.084, 34.02492], [-117.08364, 34.02579], [-117.08322, 34.02575], [-117.08315, 34.0258], [-117.08211, 34.02545], [-117.08205, 34.0254], [-117.08204, 34.02536], [-117.08205, 34.02532], [-117.08221, 34.02516], [-117.08255, 34.02491], [-117.08274, 34.0248], [-117.08314, 34.02462], [-117.08405, 34.02429], [-117.08427, 34.02418], [-117.08468, 34.02392], [-117.08475, 34.02397]]]} | Open Access 1 | 44965 | Dunlap Neighborhood Park | 27997 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 4.959 | Dunlap Neighborhood Park | 0 | Local Park 2 | 4 | |
6650 | 6650 | 6649 | {"type": "MultiPolygon", "coordinates": [[[[-117.00876, 34.01403], [-117.00847, 34.01408], [-117.00827, 34.01415], [-117.00803, 34.01428], [-117.00786, 34.01441], [-117.00773, 34.01456], [-117.00763, 34.01473], [-117.00757, 34.01491], [-117.00755, 34.01512], [-117.00748, 34.01517], [-117.00748, 34.01529], [-117.0042, 34.01527], [-117.00417, 34.01412], [-117.00484, 34.01389], [-117.00517, 34.01359], [-117.0064, 34.01388], [-117.008, 34.01403], [-117.00876, 34.01403]]], [[[-117.01091, 34.01525], [-117.00967, 34.01531], [-117.0079, 34.0153], [-117.00791, 34.01517], [-117.00785, 34.01513], [-117.00784, 34.01506], [-117.00786, 34.01493], [-117.0079, 34.01482], [-117.00798, 34.01467], [-117.00806, 34.01456], [-117.00817, 34.01445], [-117.00827, 34.01438], [-117.00852, 34.01428], [-117.00956, 34.01406], [-117.01027, 34.01412], [-117.0109, 34.01408], [-117.01091, 34.01525]]]]} | Open Access 1 | 4666 | Wildwood Park | 27524 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 21.306 | Wildwood Park | 0 | Local Park 2 | 4 | |
12570 | 12570 | 12569 | {"type": "Polygon", "coordinates": [[[-117.05757, 34.03438], [-117.05717, 34.03439], [-117.05715, 34.03446], [-117.05706, 34.03448], [-117.05706, 34.03408], [-117.05716, 34.03403], [-117.05731, 34.03403], [-117.05732, 34.03408], [-117.0575, 34.03408], [-117.05757, 34.03438]]]} | Open Access 1 | 29081 | Lillian Eaton Park | 21235 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 0.417 | Lillian Eaton Park | 0 | Local Park 2 | 4 | |
12903 | 12903 | 12902 | {"type": "Polygon", "coordinates": [[[-117.04088, 34.03129], [-117.04088, 34.0317], [-117.04024, 34.0317], [-117.04024, 34.03129], [-117.04088, 34.03129]]]} | Open Access 1 | 30385 | Center Park | 17038 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 0.67 | Ctr. Park | 0 | Local Park 2 | 4 | |
12929 | 12929 | 12928 | {"type": "Polygon", "coordinates": [[[-117.0605, 34.03403], [-117.06048, 34.03454], [-117.06042, 34.03459], [-117.06031, 34.03462], [-117.05978, 34.03468], [-117.05958, 34.03467], [-117.05926, 34.03461], [-117.05886, 34.03462], [-117.05837, 34.03461], [-117.05816, 34.03462], [-117.05804, 34.03464], [-117.05766, 34.03465], [-117.05764, 34.0344], [-117.05758, 34.03439], [-117.0575, 34.03408], [-117.05732, 34.03407], [-117.05731, 34.03403], [-117.0605, 34.03403]]]} | Open Access 1 | 30384 | John Tooker Civic Park | 20469 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 4.462 | John Tooker Civic Park | 0 | Local Park 2 | 4 | |
12930 | 12930 | 12929 | {"type": "Polygon", "coordinates": [[[-117.03793, 34.0329], [-117.03793, 34.0333], [-117.03774, 34.0333], [-117.03773, 34.03305], [-117.03753, 34.03312], [-117.03753, 34.0329], [-117.03793, 34.0329]]]} | Open Access 1 | 30386 | Avenue A Park | 15724 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 0.29 | Avenue A 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]);