units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17 rows where AGNCY_NAME = 331 and MNG_AGENCY = 328
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 15
- Local Recreation Area 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 17
MNG_AGENCY 1
- Windsor, Town of · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1197 | 1197 | 1196 | {"type": "Polygon", "coordinates": [[[-122.81481, 38.55745], [-122.81465, 38.5576], [-122.81458, 38.55768], [-122.81453, 38.55775], [-122.81445, 38.55793], [-122.81443, 38.55808], [-122.81444, 38.55849], [-122.81388, 38.55853], [-122.81385, 38.55851], [-122.81316, 38.55853], [-122.81316, 38.55701], [-122.81349, 38.55699], [-122.81356, 38.55671], [-122.8138, 38.55675], [-122.81406, 38.55685], [-122.8148, 38.55737], [-122.81481, 38.55745]]]} | Open Access 1 | 8248 | Michael Hall Park | 22197 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 5.308 | Michael Hall Park | 0 | Local Park 2 | 4 | |
1376 | 1376 | 1375 | {"type": "Polygon", "coordinates": [[[-122.80515, 38.53149], [-122.80495, 38.53148], [-122.80486, 38.53145], [-122.80479, 38.5314], [-122.80435, 38.53092], [-122.80437, 38.53082], [-122.80476, 38.53061], [-122.80485, 38.53063], [-122.80513, 38.53096], [-122.80514, 38.53102], [-122.80515, 38.53149]]]} | Open Access 1 | 8364 | Mitchell Park | 22326 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 1.061 | Mitchell Park | 0 | Local Park 2 | 4 | |
1486 | 1486 | 1485 | {"type": "Polygon", "coordinates": [[[-122.78075, 38.52807], [-122.78074, 38.52818], [-122.77867, 38.52818], [-122.77863, 38.52784], [-122.77852, 38.52761], [-122.77843, 38.52724], [-122.77784, 38.52649], [-122.77772, 38.52605], [-122.77774, 38.52577], [-122.77918, 38.52581], [-122.78075, 38.52807]]]} | Open Access 1 | 10390 | Esposti Park | 18717 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 10.323 | Esposti Park | 0 | Local Park 2 | 4 | |
2834 | 2834 | 2833 | {"type": "Polygon", "coordinates": [[[-122.83007, 38.55231], [-122.83006, 38.55266], [-122.82913, 38.55265], [-122.8291, 38.55237], [-122.82898, 38.55231], [-122.82906, 38.55227], [-122.82899, 38.55218], [-122.82891, 38.55212], [-122.82894, 38.55204], [-122.82893, 38.55172], [-122.82995, 38.55172], [-122.82993, 38.55229], [-122.83007, 38.55231]]]} | Open Access 1 | 22050 | Sutton Park | 26089 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 2.175 | Sutton Park | 0 | Local Park 2 | 4 | |
7505 | 7505 | 7504 | {"type": "Polygon", "coordinates": [[[-122.82423, 38.54607], [-122.82365, 38.5464], [-122.82264, 38.5464], [-122.82264, 38.54723], [-122.82072, 38.54721], [-122.82075, 38.54536], [-122.81977, 38.54534], [-122.81982, 38.54364], [-122.82367, 38.54368], [-122.82367, 38.54448], [-122.82369, 38.54549], [-122.82423, 38.54551], [-122.82423, 38.54607]]]} | Open Access 1 | 8859 | Keiser Park | 20573 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 27.767 | Keiser Park | 0 | Local Park 2 | 4 | |
7734 | 7734 | 7733 | {"type": "Polygon", "coordinates": [[[-122.80729, 38.55981], [-122.80707, 38.55988], [-122.80687, 38.5601], [-122.80697, 38.56037], [-122.80698, 38.56058], [-122.80666, 38.5609], [-122.80653, 38.56112], [-122.80652, 38.56137], [-122.80659, 38.56154], [-122.80638, 38.56175], [-122.80628, 38.56204], [-122.80609, 38.56204], [-122.80594, 38.56202], [-122.80611, 38.56176], [-122.80616, 38.56148], [-122.80608, 38.56129], [-122.80616, 38.56112], [-122.80627, 38.56099], [-122.80643, 38.56053], [-122.80457, 38.56053], [-122.80455, 38.55917], [-122.80408, 38.55861], [-122.80392, 38.55865], [-122.80379, 38.55881], [-122.80361, 38.55874], [-122.80379, 38.55839], [-122.80489, 38.55835], [-122.80726, 38.55833], [-122.80726, 38.55965], [-122.80729, 38.55981]]]} | Open Access 1 | 8239 | Hiram Lewis Park | 20005 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 15.95 | Hiram Lewis Park | 0 | Local Park 2 | 4 | |
7738 | 7738 | 7737 | {"type": "Polygon", "coordinates": [[[-122.824, 38.55689], [-122.82372, 38.55705], [-122.82394, 38.5573], [-122.82382, 38.55735], [-122.8237, 38.55721], [-122.82287, 38.55753], [-122.8223, 38.55684], [-122.82355, 38.55639], [-122.824, 38.55689]]]} | Open Access 1 | 8264 | Los Robles Park | 21535 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 2.589 | Los Robles Park | 0 | Local Park 2 | 4 | |
7739 | 7739 | 7738 | {"type": "Polygon", "coordinates": [[[-122.80727, 38.55233], [-122.80727, 38.55348], [-122.80579, 38.55349], [-122.8058, 38.55329], [-122.80586, 38.5532], [-122.80588, 38.55314], [-122.80585, 38.55307], [-122.80579, 38.55302], [-122.80584, 38.55225], [-122.80718, 38.55225], [-122.80727, 38.55233]]]} | Open Access 1 | 8281 | Lakewood Meadows Park | 20988 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 4.252 | Lakewood Meadows Park | 0 | Local Park 2 | 4 | |
7740 | 7740 | 7739 | {"type": "Polygon", "coordinates": [[[-122.80491, 38.54627], [-122.80468, 38.54662], [-122.8044, 38.5465], [-122.80463, 38.54616], [-122.80491, 38.54627]]]} | Open Access 1 | 8290 | Pueblo Viejo Park | 24028 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 0.301 | Pueblo Viejo Park | 0 | Local Park 2 | 4 | |
7746 | 7746 | 7745 | {"type": "Polygon", "coordinates": [[[-122.79529, 38.541], [-122.79495, 38.54143], [-122.79496, 38.54144], [-122.79502, 38.54144], [-122.7948, 38.5418], [-122.7947, 38.54184], [-122.79427, 38.54178], [-122.79407, 38.54178], [-122.79388, 38.54181], [-122.79373, 38.54186], [-122.79343, 38.542], [-122.79286, 38.54232], [-122.79278, 38.54227], [-122.79266, 38.54226], [-122.79257, 38.54228], [-122.79229, 38.54223], [-122.79217, 38.54212], [-122.79182, 38.54209], [-122.79185, 38.54141], [-122.79208, 38.54132], [-122.79235, 38.54126], [-122.79256, 38.5411], [-122.79259, 38.54096], [-122.7926, 38.54043], [-122.79382, 38.54041], [-122.79509, 38.54079], [-122.79526, 38.54087], [-122.79529, 38.541]]]} | Open Access 1 | 8299 | Pleasant Oak Park | 23797 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 10.192 | Pleasant Oak Park | 0 | Local Park 2 | 4 | |
7747 | 7747 | 7746 | {"type": "Polygon", "coordinates": [[[-122.82204, 38.53824], [-122.82203, 38.53827], [-122.82055, 38.53944], [-122.82049, 38.53944], [-122.81975, 38.53885], [-122.81976, 38.53882], [-122.82124, 38.53765], [-122.82128, 38.53765], [-122.82204, 38.53824]]]} | Open Access 1 | 8307 | Old Vineyard Park | 23110 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 4.57 | Old Vineyard Park | 0 | Local Park 2 | 4 | |
7750 | 7750 | 7749 | {"type": "Polygon", "coordinates": [[[-122.80942, 38.53367], [-122.8094, 38.53372], [-122.80833, 38.53374], [-122.80795, 38.53365], [-122.80777, 38.53364], [-122.80724, 38.53367], [-122.8072, 38.53363], [-122.80718, 38.53295], [-122.80724, 38.53293], [-122.80882, 38.53294], [-122.80911, 38.53287], [-122.80916, 38.53291], [-122.80916, 38.53314], [-122.80921, 38.53333], [-122.80924, 38.5334], [-122.8094, 38.5336], [-122.80942, 38.53367]]]} | Open Access 1 | 8317 | Vintage Oaks Park | 27147 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 3.753 | Vintage Oaks Park | 0 | Local Park 2 | 4 | |
7752 | 7752 | 7751 | {"type": "Polygon", "coordinates": [[[-122.80614, 38.53533], [-122.80383, 38.53537], [-122.80381, 38.53476], [-122.80379, 38.53466], [-122.80367, 38.53444], [-122.80294, 38.53361], [-122.80285, 38.53341], [-122.80282, 38.53316], [-122.80287, 38.5331], [-122.80298, 38.53308], [-122.80418, 38.53305], [-122.80593, 38.53511], [-122.80614, 38.53533]]]} | Open Access 1 | 8327 | Wilson Ranch Soccer Park | 27614 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 9.673 | Wilson Ranch Soccer Park | 0 | Local Recreation Area 3 | 4 | |
7754 | 7754 | 7753 | {"type": "Polygon", "coordinates": [[[-122.79367, 38.5363], [-122.79318, 38.53631], [-122.79316, 38.53601], [-122.79083, 38.53599], [-122.79073, 38.53627], [-122.79065, 38.53593], [-122.79063, 38.53533], [-122.79073, 38.53526], [-122.79184, 38.53523], [-122.79194, 38.53521], [-122.79226, 38.53512], [-122.79263, 38.53493], [-122.79278, 38.53489], [-122.79295, 38.53488], [-122.79296, 38.53555], [-122.79367, 38.5363]]]} | Open Access 1 | 8338 | Robbins Park | 24480 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 5.238 | Robbins Park | 0 | Local Park 2 | 4 | |
7759 | 7759 | 7758 | {"type": "Polygon", "coordinates": [[[-122.80397, 38.5309], [-122.80379, 38.531], [-122.80348, 38.53064], [-122.80366, 38.53054], [-122.80397, 38.5309]]]} | Open Access 1 | 8349 | Acorn Park | 15250 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 0.226 | Acorn Park | 0 | Local Park 2 | 4 | |
13932 | 13932 | 13931 | {"type": "Polygon", "coordinates": [[[-122.76046, 38.53375], [-122.76045, 38.53441], [-122.75994, 38.5344], [-122.75976, 38.53431], [-122.75967, 38.53424], [-122.75961, 38.53416], [-122.75956, 38.53408], [-122.75954, 38.53399], [-122.75955, 38.53386], [-122.75969, 38.53357], [-122.7597, 38.53375], [-122.76046, 38.53375]]]} | No Public Access 3 | 36538 | Town of Windsor Holding | 28170 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 1.314 | Town of Windsor Holding | None 1190 | |||
14280 | 14280 | 14279 | {"type": "Polygon", "coordinates": [[[-122.81604, 38.54911], [-122.81593, 38.54911], [-122.81527, 38.54925], [-122.81454, 38.54942], [-122.8145, 38.54932], [-122.81387, 38.54901], [-122.81388, 38.54885], [-122.81386, 38.54842], [-122.81542, 38.54838], [-122.81549, 38.54831], [-122.81564, 38.54828], [-122.81583, 38.54827], [-122.81586, 38.54832], [-122.81581, 38.54838], [-122.8159, 38.54889], [-122.81598, 38.54894], [-122.81604, 38.54911]]]} | Open Access 1 | 44207 | Windsor Town Green | 27640 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 4.176 | Windsor Town Green | 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]);