superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where ACCESS_TYP = 1 and MNG_AGENCY = 103
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1067 | 1067 | 1066 | {"type": "Polygon", "coordinates": [[[-117.42271, 34.16041], [-117.42182, 34.15997], [-117.42155, 34.15987], [-117.42129, 34.15982], [-117.42094, 34.15978], [-117.41877, 34.15978], [-117.41874, 34.15977], [-117.41872, 34.15973], [-117.41872, 34.15913], [-117.42114, 34.15907], [-117.42116, 34.15881], [-117.42165, 34.15881], [-117.42166, 34.15911], [-117.4227, 34.1591], [-117.42271, 34.16041]]]} | Open Access 1 | Alec Fergusson Park | 15352 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 8.289 | Alec Fergusson Park | ||
1178 | 1178 | 1177 | {"type": "Polygon", "coordinates": [[[-117.38123, 34.08863], [-117.37915, 34.08864], [-117.37914, 34.08773], [-117.38122, 34.08773], [-117.38123, 34.08863]]]} | Open Access 1 | Anderson Park | 15478 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 4.784 | Anderson Park | ||
2032 | 2032 | 2031 | {"type": "Polygon", "coordinates": [[[-117.40091, 34.14811], [-117.39884, 34.14812], [-117.39884, 34.14676], [-117.40084, 34.14675], [-117.40084, 34.14764], [-117.40091, 34.14766], [-117.40091, 34.14811]]]} | Open Access 1 | Birdsall Park | 16123 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 6.956 | Birdsall Park | ||
2331 | 2331 | 2330 | {"type": "Polygon", "coordinates": [[[-117.379, 34.10313], [-117.37692, 34.10313], [-117.37692, 34.10156], [-117.379, 34.10155], [-117.379, 34.10313]]]} | Open Access 1 | Bud Bender Park | 16478 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 8.327 | Bud Bender Park | ||
4275 | 4275 | 4274 | {"type": "Polygon", "coordinates": [[[-117.39137, 34.11506], [-117.39122, 34.11519], [-117.39118, 34.11519], [-117.39112, 34.11521], [-117.39035, 34.11521], [-117.39005, 34.11512], [-117.39004, 34.11413], [-117.39124, 34.11413], [-117.39124, 34.11436], [-117.39136, 34.1144], [-117.39137, 34.11506]]]} | Open Access 1 | Flores Park | 18962 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 3.483 | Flores Park | ||
4431 | 4431 | 4430 | {"type": "MultiPolygon", "coordinates": [[[[-117.36134, 34.13414], [-117.36044, 34.13413], [-117.35976, 34.13403], [-117.35946, 34.134], [-117.35748, 34.134], [-117.35744, 34.13395], [-117.35744, 34.13232], [-117.35952, 34.13231], [-117.35953, 34.1325], [-117.36134, 34.13414]]], [[[-117.36159, 34.13433], [-117.36161, 34.13552], [-117.36157, 34.13564], [-117.36064, 34.13558], [-117.36062, 34.13562], [-117.36025, 34.1356], [-117.35802, 34.13514], [-117.35779, 34.13507], [-117.35765, 34.13499], [-117.35753, 34.13488], [-117.35745, 34.13473], [-117.35745, 34.13419], [-117.35943, 34.13418], [-117.35973, 34.1342], [-117.36018, 34.13429], [-117.36044, 34.13431], [-117.36062, 34.13432], [-117.36064, 34.13431], [-117.36159, 34.13433]]]]} | Open Access 1 | Frisbie Park | 19125 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 24.7 | Frisbie Park | ||
5521 | 5521 | 5520 | {"type": "Polygon", "coordinates": [[[-117.39227, 34.12865], [-117.39146, 34.12865], [-117.39024, 34.12701], [-117.38904, 34.12385], [-117.39061, 34.12445], [-117.391, 34.12466], [-117.39135, 34.12493], [-117.39226, 34.12493], [-117.39227, 34.12865]]]} | Open Access 1 | Jerry Eaves Park | 20400 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 21.632 | Jerry Eaves Park | ||
6627 | 6627 | 6626 | {"type": "Polygon", "coordinates": [[[-117.37464, 34.10245], [-117.37387, 34.10245], [-117.37386, 34.10284], [-117.37293, 34.10284], [-117.37293, 34.10166], [-117.37464, 34.10166], [-117.37464, 34.10245]]]} | Open Access 1 | Margaret Todd Park | 21803 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 4.332 | Margaret Todd Park | ||
8656 | 8656 | 8655 | {"type": "Polygon", "coordinates": [[[-117.37017, 34.07956], [-117.36602, 34.07956], [-117.36601, 34.07783], [-117.37016, 34.07783], [-117.37017, 34.07956]]]} | Open Access 1 | Rialto City Park | 24315 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 18.213 | Rialto City Park | ||
8658 | 8658 | 8657 | {"type": "Polygon", "coordinates": [[[-117.37692, 34.10313], [-117.37483, 34.10313], [-117.37483, 34.10156], [-117.37691, 34.10156], [-117.37692, 34.10313]]]} | Open Access 1 | Rialto Park Cemetery | 24316 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 8.303 | Rialto Park Cemetery |
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]);