units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where ACCESS_TYP = 1 and MNG_AGENCY = 141
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
353 | 353 | 352 | {"type": "Polygon", "coordinates": [[[-117.66787, 34.10512], [-117.66674, 34.10513], [-117.66674, 34.1034], [-117.66787, 34.1034], [-117.66787, 34.10512]]]} | Open Access 1 | 975 | Baldy View Park | 15781 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 4.946 | Baldy View Park | 0 | Local Park 2 | 4 | |
399 | 399 | 398 | {"type": "Polygon", "coordinates": [[[-117.67941, 34.11771], [-117.67723, 34.11772], [-117.67722, 34.116], [-117.6794, 34.11599], [-117.67941, 34.11771]]]} | Open Access 1 | 1203 | Greenbelt Park | 19473 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 9.512 | Greenbelt Park | 0 | Local Park 2 | 4 | |
534 | 534 | 533 | {"type": "Polygon", "coordinates": [[[-117.63644, 34.10514], [-117.63631, 34.10514], [-117.63631, 34.10521], [-117.63512, 34.10522], [-117.63512, 34.10561], [-117.63519, 34.10561], [-117.63519, 34.10572], [-117.63522, 34.10582], [-117.63536, 34.10606], [-117.6354, 34.10616], [-117.63542, 34.10628], [-117.63542, 34.10671], [-117.63555, 34.10676], [-117.63555, 34.10693], [-117.63327, 34.10694], [-117.63267, 34.10692], [-117.63274, 34.10671], [-117.63274, 34.10637], [-117.63265, 34.10308], [-117.63508, 34.10198], [-117.63515, 34.10211], [-117.63511, 34.10213], [-117.63514, 34.1022], [-117.63525, 34.10227], [-117.63537, 34.10238], [-117.63577, 34.10306], [-117.6358, 34.10326], [-117.63587, 34.10327], [-117.63588, 34.10332], [-117.63571, 34.10333], [-117.63571, 34.1035], [-117.63605, 34.10351], [-117.63627, 34.10395], [-117.6364, 34.10438], [-117.63644, 34.10471], [-117.63644, 34.10514]]]} | Open Access 1 | 2499 | Memorial Park | 22136 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 34.792 | Memorial Park | 0 | Local Park 2 | 4 | |
633 | 633 | 632 | {"type": "Polygon", "coordinates": [[[-117.66073, 34.11968], [-117.65845, 34.11969], [-117.65844, 34.11797], [-117.66066, 34.11796], [-117.6607, 34.11798], [-117.66072, 34.11801], [-117.66073, 34.11968]]]} | Open Access 1 | 2515 | Magnolia Park | 21683 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 9.94 | Magnolia Park | 0 | Local Park 2 | 4 | |
905 | 905 | 904 | {"type": "Polygon", "coordinates": [[[-117.64859, 34.11782], [-117.6463, 34.11782], [-117.64629, 34.11663], [-117.64803, 34.11662], [-117.64804, 34.11672], [-117.64859, 34.11672], [-117.64859, 34.11782]]]} | Open Access 1 | 5797 | Sierra Vista Park | 25471 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 6.813 | Sierra Vista Park | 0 | Local Park 2 | 4 | |
1073 | 1073 | 1072 | {"type": "Polygon", "coordinates": [[[-117.64541, 34.09239], [-117.64388, 34.09239], [-117.64387, 34.09076], [-117.64541, 34.09075], [-117.64541, 34.09239]]]} | Open Access 1 | 6436 | Olivedale Park | 23130 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 6.346 | Olivedale Park | 0 | Local Park 2 | 4 | |
1323 | 1323 | 1322 | {"type": "Polygon", "coordinates": [[[-117.67388, 34.15232], [-117.67059, 34.15233], [-117.67058, 34.15061], [-117.67387, 34.1506], [-117.67388, 34.15232]]]} | Open Access 1 | 10791 | San Antonio Park | 24834 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 14.32 | San Antonio Park | 0 | Local Park 2 | 4 | |
5858 | 5858 | 5857 | {"type": "Polygon", "coordinates": [[[-117.67801, 34.10508], [-117.67693, 34.10509], [-117.67693, 34.10582], [-117.67475, 34.10583], [-117.67474, 34.1051], [-117.6744, 34.1051], [-117.67439, 34.10337], [-117.67801, 34.10336], [-117.67801, 34.10508]]]} | Open Access 1 | 201 | Cabrillo Park | 16642 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 19.819 | Cabrillo Park | 0 | Local Park 2 | 4 | |
5949 | 5949 | 5948 | {"type": "Polygon", "coordinates": [[[-117.65718, 34.09286], [-117.65611, 34.09286], [-117.65611, 34.09254], [-117.65718, 34.09253], [-117.65718, 34.09286]]]} | Open Access 1 | 514 | Fern Reservoir Park | 18875 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 0.889 | Fern Reservoir Park | 0 | Local Park 2 | 4 | |
5957 | 5957 | 5956 | {"type": "Polygon", "coordinates": [[[-117.66084, 34.13712], [-117.6608, 34.13713], [-117.6608, 34.13734], [-117.66023, 34.13734], [-117.66023, 34.13785], [-117.65944, 34.13785], [-117.65943, 34.13613], [-117.66083, 34.13612], [-117.66084, 34.13712]]]} | Open Access 1 | 531 | McCarthy Park | 21994 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 5.321 | McCarthy Park | 0 | Local Park 2 | 4 | |
6511 | 6511 | 6510 | {"type": "Polygon", "coordinates": [[[-117.64341, 34.11057], [-117.64175, 34.11057], [-117.6417, 34.11053], [-117.6417, 34.11008], [-117.64338, 34.11007], [-117.64341, 34.11011], [-117.64341, 34.11057]]]} | Open Access 1 | 2522 | 13th Street Reservoir Park | 15171 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 2.129 | 13th Street Reservoir Park | 0 | Local Park 2 | 4 | |
6811 | 6811 | 6810 | {"type": "Polygon", "coordinates": [[[-117.66546, 34.09233], [-117.66412, 34.09233], [-117.66411, 34.09061], [-117.66545, 34.0906], [-117.66546, 34.09233]]]} | Open Access 1 | 15876 | Citrus Park | 17284 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 5.841 | Citrus Park | 0 | Local Park 2 | 4 | |
9128 | 9128 | 9127 | {"type": "Polygon", "coordinates": [[[-117.64137, 34.0943], [-117.64005, 34.09426], [-117.63908, 34.09417], [-117.63907, 34.09258], [-117.64136, 34.09258], [-117.64137, 34.0943]]]} | Open Access 1 | 15167 | 8th Street Reservoir Park | 15221 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 9.709 | 8th Street Reservoir 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]);