units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where AGNCY_NAME = 792, DES_TP = 2 and MNG_AGENCY = 770
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- City Agency 10
MNG_AGENCY 1
- Suisun City, City of · 10 ✖
DES_TP 1
- Local Park · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7726 | 7726 | 7725 | {"type": "Polygon", "coordinates": [[[-122.01041, 38.24782], [-122.01031, 38.24929], [-122.00925, 38.24921], [-122.00837, 38.24903], [-122.0091, 38.24769], [-122.00994, 38.24782], [-122.01041, 38.24782]]]} | Open Access 1 | 7982 | Carl E. Hall Park | 16851 | 1344 | Suisun City, City of 792 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | Solano 26 | 5.771 | Carl E. Hall Park | 0 | Local Park 2 | 4 | |
9015 | 9015 | 9014 | {"type": "Polygon", "coordinates": [[[-122.03876, 38.24014], [-122.03742, 38.24014], [-122.03696, 38.23916], [-122.03734, 38.23912], [-122.03739, 38.23929], [-122.03763, 38.2393], [-122.03774, 38.23909], [-122.03799, 38.23898], [-122.03824, 38.23908], [-122.0384, 38.2393], [-122.03866, 38.23937], [-122.03875, 38.23956], [-122.03879, 38.23979], [-122.03876, 38.24014]]]} | Open Access 1 | 14920 | Day Park | 17961 | 1344 | Suisun City, City of 792 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | Solano 26 | 3.596 | Day Park | 0 | Local Park 2 | 4 | |
9016 | 9016 | 9015 | {"type": "Polygon", "coordinates": [[[-122.03655, 38.23857], [-122.03592, 38.23857], [-122.0359, 38.23861], [-122.03591, 38.23879], [-122.03587, 38.2388], [-122.03588, 38.23862], [-122.03582, 38.23857], [-122.0353, 38.23857], [-122.03522, 38.23863], [-122.03521, 38.23914], [-122.03525, 38.2392], [-122.0351, 38.23917], [-122.03515, 38.23913], [-122.03515, 38.23862], [-122.03509, 38.23857], [-122.03481, 38.23856], [-122.03481, 38.23828], [-122.03545, 38.23829], [-122.03549, 38.23824], [-122.03549, 38.23806], [-122.03556, 38.23806], [-122.03556, 38.23824], [-122.0356, 38.23829], [-122.03623, 38.23829], [-122.03629, 38.23822], [-122.03634, 38.23828], [-122.03645, 38.23833], [-122.03655, 38.23857]]]} | Open Access 1 | 14922 | Todd Park | 26385 | 1344 | Suisun City, City of 792 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | Solano 26 | 1.321 | Todd Park | 0 | Local Park 2 | 4 | |
9017 | 9017 | 9016 | {"type": "Polygon", "coordinates": [[[-122.01193, 38.24089], [-122.01193, 38.24114], [-122.01187, 38.24135], [-122.01158, 38.2412], [-122.01138, 38.24113], [-122.01093, 38.2411], [-122.01067, 38.24104], [-122.01042, 38.24094], [-122.01056, 38.24088], [-122.01089, 38.24087], [-122.01193, 38.24089]]]} | Open Access 1 | 14925 | McCoy Creek Park | 22010 | 1344 | Suisun City, City of 792 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | Solano 26 | 0.899 | McCoy Creek Park | 0 | Local Park 2 | 4 | |
9018 | 9018 | 9017 | {"type": "Polygon", "coordinates": [[[-122.00675, 38.23792], [-122.00667, 38.24075], [-122.00645, 38.24053], [-122.00646, 38.24046], [-122.00635, 38.24039], [-122.00626, 38.24045], [-122.00609, 38.24053], [-122.00543, 38.24065], [-122.00539, 38.24063], [-122.00536, 38.2406], [-122.00535, 38.24054], [-122.00528, 38.2404], [-122.00513, 38.23984], [-122.00499, 38.23958], [-122.00484, 38.23936], [-122.00468, 38.23919], [-122.00449, 38.23906], [-122.00422, 38.2389], [-122.00392, 38.23876], [-122.00612, 38.23807], [-122.00675, 38.23792]]]} | Open Access 1 | 14927 | Lawler Ranch Park | 31000 | 1344 | Suisun City, City of 792 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | Solano 26 | 10.688 | Lawler Ranch Park | 0 | Local Park 2 | 4 | |
9019 | 9019 | 9018 | {"type": "Polygon", "coordinates": [[[-121.99949, 38.23699], [-121.99899, 38.23756], [-121.999, 38.2376], [-121.99895, 38.23768], [-121.99894, 38.23777], [-121.99902, 38.23782], [-121.99908, 38.23783], [-121.99898, 38.23816], [-121.99911, 38.23825], [-121.99918, 38.23839], [-121.9992, 38.23854], [-121.99921, 38.23877], [-121.99894, 38.23877], [-121.99881, 38.23862], [-121.99864, 38.2385], [-121.99843, 38.23841], [-121.99818, 38.23836], [-121.99784, 38.23838], [-121.99759, 38.23816], [-121.9976, 38.23802], [-121.9977, 38.23781], [-121.99784, 38.23776], [-121.99839, 38.23785], [-121.99857, 38.23754], [-121.99868, 38.23748], [-121.99873, 38.23741], [-121.99883, 38.23742], [-121.9993, 38.23687], [-121.99949, 38.23699]]]} | Open Access 1 | 14929 | Lawler Falls Park | 21113 | 1344 | Suisun City, City of 792 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | Solano 26 | 3.14 | Lawler Falls Park | 0 | Local Park 2 | 4 | |
9020 | 9020 | 9019 | {"type": "Polygon", "coordinates": [[[-121.98443, 38.24864], [-121.98241, 38.2497], [-121.98174, 38.24893], [-121.98363, 38.24788], [-121.98443, 38.24864]]]} | Open Access 1 | 14931 | Montebello Vista Park | 22407 | 1344 | Suisun City, City of 792 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | Solano 26 | 5.462 | Montebello Vista Park | 0 | Local Park 2 | 4 | |
9021 | 9021 | 9020 | {"type": "Polygon", "coordinates": [[[-121.99686, 38.2494], [-121.9951, 38.24948], [-121.99479, 38.24852], [-121.99642, 38.24811], [-121.99686, 38.2494]]]} | Open Access 1 | 14934 | Samuel W. Geopp Park | 24822 | 1344 | Suisun City, City of 792 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | Solano 26 | 4.82 | Samuel W. Geopp Park | 0 | Local Park 2 | 4 | |
9871 | 9871 | 9870 | {"type": "Polygon", "coordinates": [[[-122.02496, 38.24674], [-122.02492, 38.24958], [-122.02414, 38.2496], [-122.0235, 38.24955], [-122.02346, 38.24783], [-122.02373, 38.24776], [-122.02372, 38.2467], [-122.02496, 38.24674]]]} | Open Access 1 | 16933 | Heritage Park | 19856 | 1344 | Suisun City, City of 792 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | Solano 26 | 9.412 | Heritage Park | 2000 | Local Park 2 | 4 | |
14256 | 14256 | 14255 | {"type": "Polygon", "coordinates": [[[-121.98527, 38.2566], [-121.98393, 38.25659], [-121.98382, 38.25657], [-121.98374, 38.25661], [-121.98369, 38.25668], [-121.9835, 38.25668], [-121.9835, 38.2565], [-121.98321, 38.25555], [-121.98368, 38.25555], [-121.98369, 38.2556], [-121.98373, 38.25564], [-121.98382, 38.25567], [-121.98401, 38.25565], [-121.98562, 38.25566], [-121.98565, 38.2557], [-121.98565, 38.25587], [-121.98548, 38.25602], [-121.98546, 38.25608], [-121.98545, 38.25614], [-121.9855, 38.25626], [-121.98562, 38.25635], [-121.98565, 38.2564], [-121.98564, 38.25658], [-121.98559, 38.25661], [-121.98527, 38.2566]]]} | Open Access 1 | 44175 | Patriot Park | 23515 | 1344 | Suisun City, City of 792 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | Solano 26 | 5.112 | Patriot 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]);