units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where COUNTY = 22, MNG_AGENCY = 103 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- City Agency · 10 ✖
MNG_AGENCY 1
- Rialto, City of · 10 ✖
ACCESS_TYP 1
- Open Access 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
259 | 259 | 258 | {"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.36063, 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 | 716 | Frisbie Park | 19125 | 1273 | Rialto, City of 106 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | San Bernardino 22 | 24.7 | Frisbie Park | 0 | Local Park 2 | 4 | |
482 | 482 | 481 | {"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 | 1930 | Margaret Todd Park | 21803 | 1273 | Rialto, City of 106 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | San Bernardino 22 | 4.33 | Margaret Todd Park | 0 | Local Park 2 | 4 | |
668 | 668 | 667 | {"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.42115, 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 | 3675 | Alec Fergusson Park | 15352 | 1273 | Rialto, City of 106 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | San Bernardino 22 | 8.284 | Alec Fergusson Park | 0 | Local Park 2 | 4 | |
683 | 683 | 682 | {"type": "Polygon", "coordinates": [[[-117.39137, 34.11506], [-117.39122, 34.11519], [-117.39119, 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.11437], [-117.39136, 34.1144], [-117.39137, 34.11506]]]} | Open Access 1 | 3673 | Flores Park | 18962 | 1273 | Rialto, City of 106 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | San Bernardino 22 | 3.483 | Flores Park | 0 | Local Park 2 | 4 | |
694 | 694 | 693 | {"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 | 3686 | Jerry Eaves Park | 20400 | 1273 | Rialto, City of 106 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | San Bernardino 22 | 21.633 | Jerry Eaves Park | 0 | Local Park 2 | 4 | |
845 | 845 | 844 | {"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 | 5484 | Anderson Park | 15478 | 1273 | Rialto, City of 106 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | San Bernardino 22 | 4.786 | Anderson Park | 0 | Local Park 2 | 4 | |
1453 | 1453 | 1452 | {"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 | 12579 | Rialto Park Cemetery | 24316 | 1273 | Rialto, City of 106 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | San Bernardino 22 | 8.305 | Rialto Park Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
4966 | 4966 | 4965 | {"type": "Polygon", "coordinates": [[[-117.40091, 34.14811], [-117.39884, 34.14812], [-117.39884, 34.14676], [-117.40084, 34.14675], [-117.40084, 34.14765], [-117.40091, 34.14766], [-117.40091, 34.14811]]]} | Open Access 1 | 3674 | Birdsall Park | 16123 | 1273 | Rialto, City of 106 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | San Bernardino 22 | 6.957 | Birdsall Park | 0 | Local Park 2 | 4 | |
7883 | 7883 | 7882 | {"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 | 9867 | Rialto City Park | 24315 | 1273 | Rialto, City of 106 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | San Bernardino 22 | 18.217 | Rialto City Park | 0 | Local Park 2 | 4 | |
8106 | 8106 | 8105 | {"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 | 12198 | Bud Bender Park | 16478 | 1273 | Rialto, City of 106 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | San Bernardino 22 | 8.329 | Bud Bender 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]);