superunits_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)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
182 | 182 | 181 | {"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 | 8th Street Reservoir Park | 15221 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 9.707 | 8th Street Reservoir Park | ||
1297 | 1297 | 1296 | {"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 | Baldy View Park | 15781 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 4.945 | Baldy View Park | ||
1385 | 1385 | 1384 | {"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 | 13th Street Reservoir Park | 15171 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 2.128 | 13th Street Reservoir Park | ||
2463 | 2463 | 2462 | {"type": "Polygon", "coordinates": [[[-117.67801, 34.10508], [-117.67693, 34.10509], [-117.67693, 34.10582], [-117.67475, 34.10583], [-117.67474, 34.10511], [-117.6744, 34.1051], [-117.67439, 34.10337], [-117.67801, 34.10336], [-117.67801, 34.10508]]]} | Open Access 1 | Cabrillo Park | 16642 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 19.827 | Cabrillo Park | ||
2909 | 2909 | 2908 | {"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 | Citrus Park | 17284 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 5.839 | Citrus Park | ||
4192 | 4192 | 4191 | {"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 | Fern Reservoir Park | 18875 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 0.888 | Fern Reservoir Park | ||
4734 | 4734 | 4733 | {"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 | Greenbelt Park | 19473 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 9.51 | Greenbelt Park | ||
6531 | 6531 | 6530 | {"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 | Magnolia Park | 21683 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 9.938 | Magnolia Park | ||
6777 | 6777 | 6776 | {"type": "Polygon", "coordinates": [[[-117.66084, 34.13712], [-117.6608, 34.13713], [-117.6608, 34.13734], [-117.66023, 34.13735], [-117.66023, 34.13785], [-117.65944, 34.13785], [-117.65943, 34.13613], [-117.66083, 34.13612], [-117.66084, 34.13712]]]} | Open Access 1 | McCarthy Park | 21994 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 5.324 | McCarthy Park | ||
6926 | 6926 | 6925 | {"type": "Polygon", "coordinates": [[[-117.63644, 34.10513], [-117.63632, 34.10514], [-117.63631, 34.10521], [-117.63512, 34.10523], [-117.63512, 34.1056], [-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.63572, 34.1035], [-117.63605, 34.10351], [-117.63627, 34.10395], [-117.6364, 34.10438], [-117.63644, 34.10471], [-117.63644, 34.10513]]]} | Open Access 1 | Memorial Park | 22136 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 34.807 | Memorial Park | ||
7680 | 7680 | 7679 | {"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 | Olivedale Park | 23130 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 6.344 | Olivedale Park | ||
9155 | 9155 | 9154 | {"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 | San Antonio Park | 24834 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 14.317 | San Antonio Park | ||
9639 | 9639 | 9638 | {"type": "Polygon", "coordinates": [[[-117.64859, 34.11782], [-117.6463, 34.11782], [-117.64629, 34.11663], [-117.64803, 34.11662], [-117.64805, 34.11672], [-117.64859, 34.11672], [-117.64859, 34.11782]]]} | Open Access 1 | Sierra Vista Park | 25471 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 6.812 | Sierra Vista Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);