units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where AGNCY_LEV = 2, DES_TP = 2 and MNG_AGENCY = 428
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 13
MNG_AGENCY 1
- American Canyon, City of · 13 ✖
DES_TP 1
- Local Park · 13 ✖
ACCESS_TYP 1
- Open Access 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1860 | 1860 | 1859 | {"type": "Polygon", "coordinates": [[[-122.25881, 38.16563], [-122.25708, 38.16557], [-122.25695, 38.16477], [-122.25719, 38.16478], [-122.25771, 38.16491], [-122.25778, 38.16488], [-122.25793, 38.16467], [-122.25798, 38.16468], [-122.25862, 38.16504], [-122.25843, 38.16526], [-122.25881, 38.16563]]]} | Open Access 1 | 14200 | Northampton Park | 22865 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 2.9 | Northampton Park | 0 | Local Park 2 | 4 | |
8535 | 8535 | 8534 | {"type": "MultiPolygon", "coordinates": [[[[-122.26479, 38.15542], [-122.26477, 38.15543], [-122.26472, 38.16056], [-122.26232, 38.16079], [-122.26209, 38.16108], [-122.26201, 38.16106], [-122.26202, 38.16082], [-122.2616, 38.16088], [-122.26148, 38.16121], [-122.26164, 38.16149], [-122.26183, 38.16156], [-122.26204, 38.16188], [-122.26173, 38.16192], [-122.26173, 38.16174], [-122.26152, 38.16152], [-122.26146, 38.16132], [-122.26122, 38.16131], [-122.26114, 38.16137], [-122.26104, 38.16132], [-122.26093, 38.16133], [-122.26087, 38.16122], [-122.26066, 38.16125], [-122.26044, 38.16134], [-122.2605, 38.16165], [-122.26027, 38.16173], [-122.26027, 38.1606], [-122.26068, 38.16062], [-122.26068, 38.15862], [-122.26228, 38.15844], [-122.2636, 38.15841], [-122.2636, 38.15877], [-122.26386, 38.15894], [-122.26447, 38.15892], [-122.26462, 38.15867], [-122.26466, 38.15538], [-122.26479, 38.15538], [-122.26479, 38.15542]]], [[[-122.26005, 38.16085], [-122.26004, 38.16086], [-122.26002, 38.1619], [-122.25998, 38.16193], [-122.25982, 38.16197], [-122.25968, 38.16202], [-122.25949, 38.16215], [-122.25948, 38.16197], [-122.25919, 38.16194], [-122.25919, 38.16188], [-122.25915, 38.16183], [-122.2591, 38.1618], [-122.25903, 38.16178], [-122.25894, 38.1618], [-122.25887, 38.16185], [-122.25872, 38.16178], [-122.25856, 38.16177], [-122.25834, 38.16182], [-122.25821, 38.16189], [-122.25818, 38.16196], [-122.25807, 38.16197], [-122.25798, 38.16202], [-122.25785, 38.16195], [-122.25748, 38.16197], [-122.25615, 38.16194], [-122.25619, 38.16129], [-122.25767, 38.1613], [-122.25861, 38.16121], [-122.2596, 38.16103], [-122.2598, 38.16092], [-122.25989, 38.1608], [-122.26001, 38.1608], [-122.26004, 38.16082], [-122.26005, 38.16085]]], [[[-122.25595, 38.16129], [-122.25592, 38.1614], [-122.25591, 38.16211], [-122.25546, 38.162], [-122.25522, 38.16205], [-122.25514, 38.16217], [-122.25503, 38.16215], [-122.25493, 38.16219], [-122.25489, 38.16225], [-122.25488, 38.1623], [-122.2549, 38.16235], [-122.25496, 38.16243], [-122.25477, 38.16243], [-122.25469, 38.16248], [-122.25446, 38.16273], [-122.25445, 38.16285], [-122.25438, 38.16286], [-122.25432, 38.16289], [-122.25429, 38.16293], [-122.25427, 38.16299], [-122.25415, 38.16299], [-122.25382, 38.16331], [-122.25366, 38.16341], [-122.25366, 38.16359], [-122.25359, 38.16356], [-122.25352, 38.16355], [-122.25345, 38.16357], [-122.25339, 38.16361], [-122.25337, 38.16367], [-122.25337, 38.16372], [-122.2534, 38.16377], [-122.25345, 38.16381], [-122.25343, 38.16408], [-122.25318, 38.16407], [-122.25339, 38.16132], [-122.25397, 38.16134], [-122.25399, 38.16127], [-122.25595, 38.16129]]]]} | Open Access 1 | 13421 | Kimberly Park | 20648 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 39.792 | Kimberly Park | 0 | Local Park 2 | 4 | |
8745 | 8745 | 8744 | {"type": "Polygon", "coordinates": [[[-122.26381, 38.16293], [-122.26252, 38.16345], [-122.26264, 38.16365], [-122.26255, 38.1637], [-122.26252, 38.16376], [-122.26253, 38.16382], [-122.26259, 38.16389], [-122.26266, 38.16391], [-122.26266, 38.1641], [-122.26273, 38.16422], [-122.26319, 38.16423], [-122.26317, 38.16429], [-122.26289, 38.16436], [-122.26289, 38.16451], [-122.26264, 38.16468], [-122.26261, 38.16464], [-122.26264, 38.16454], [-122.26258, 38.1643], [-122.26259, 38.16413], [-122.26236, 38.16404], [-122.26238, 38.164], [-122.26237, 38.16393], [-122.26233, 38.16387], [-122.26228, 38.16385], [-122.26231, 38.16364], [-122.2622, 38.1636], [-122.26122, 38.16399], [-122.26118, 38.16408], [-122.26112, 38.16399], [-122.26094, 38.16407], [-122.26094, 38.16408], [-122.261, 38.16415], [-122.26088, 38.16412], [-122.26026, 38.16437], [-122.26017, 38.16457], [-122.26029, 38.16463], [-122.26027, 38.16469], [-122.26028, 38.16473], [-122.26032, 38.16479], [-122.26024, 38.16484], [-122.26014, 38.16486], [-122.26011, 38.1648], [-122.26, 38.16474], [-122.26004, 38.16457], [-122.25984, 38.1645], [-122.25975, 38.16449], [-122.25901, 38.1648], [-122.25887, 38.16495], [-122.2584, 38.16471], [-122.25929, 38.16434], [-122.25919, 38.16431], [-122.2592, 38.16426], [-122.25912, 38.16413], [-122.25905, 38.1641], [-122.25907, 38.16402], [-122.25905, 38.16398], [-122.25897, 38.16392], [-122.25889, 38.1639], [-122.25871, 38.16368], [-122.2586, 38.1635], [-122.25868, 38.16346], [-122.25887, 38.16359], [-122.25902, 38.16376], [-122.25919, 38.16378], [-122.25919, 38.16383], [-122.25922, 38.16389], [-122.25936, 38.16395], [-122.25936, 38.16412], [-122.25945, 38.1642], [-122.26059, 38.16367], [-122.26063, 38.16358], [-122.26075, 38.16375], [-122.26092, 38.16368], [-122.26083, 38.1635], [-122.26095, 38.16353], [-122.26168, 38.16324], [-122.26202, 38.16317], [-122.26244, 38.163], [-122.26245, 38.16286], [-122.26218, 38.16277], [-122.2622, 38.16271], [-122.26217, 38.16264], [-122.26214, 38.1626], [-122.26203, 38.16257], [-122.26192, 38.1623], [-122.26187, 38.16206], [-122.26198, 38.16204], [-122.26204, 38.16223], [-122.26226, 38.1624], [-122.26245, 38.16248], [-122.26244, 38.16254], [-122.26246, 38.1626], [-122.26251, 38.16265], [-122.2625, 38.16279], [-122.26256, 38.16286], [-122.26269, 38.1629], [-122.26369, 38.16249], [-122.26373, 38.16254], [-122.26373, 38.16272], [-122.26381, 38.16293]]]} | Open Access 1 | 14202 | Elliott Park | 18590 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 8.099 | Elliott Park | 0 | Local Park 2 | 4 | |
8747 | 8747 | 8746 | {"type": "Polygon", "coordinates": [[[-122.25601, 38.17428], [-122.25487, 38.17441], [-122.25486, 38.17432], [-122.25496, 38.17431], [-122.25493, 38.17412], [-122.25596, 38.17401], [-122.25601, 38.17428]]]} | Open Access 1 | 14209 | Melvin Park | 22114 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 0.72 | Melvin Park | 0 | Local Park 2 | 4 | |
8748 | 8748 | 8747 | {"type": "Polygon", "coordinates": [[[-122.23545, 38.1614], [-122.23492, 38.16177], [-122.23451, 38.16159], [-122.23496, 38.16096], [-122.23508, 38.1609], [-122.23525, 38.16116], [-122.23545, 38.1614]]]} | Open Access 1 | 14211 | Via Bellagio Park | 27064 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 0.994 | Via Bellagio Park | 2002 | Local Park 2 | 4 | |
8749 | 8749 | 8748 | {"type": "Polygon", "coordinates": [[[-122.23961, 38.16213], [-122.23949, 38.16217], [-122.23924, 38.16215], [-122.23903, 38.161], [-122.23897, 38.16087], [-122.23885, 38.16084], [-122.2387, 38.1609], [-122.23836, 38.16091], [-122.23805, 38.16085], [-122.23818, 38.16039], [-122.23853, 38.16034], [-122.23912, 38.15992], [-122.23936, 38.16091], [-122.23961, 38.16213]]]} | Open Access 1 | 14213 | Montecarlo Park | 22408 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 2.979 | Montecarlo Park | 2002 | Local Park 2 | 4 | |
9688 | 9688 | 9687 | {"type": "Polygon", "coordinates": [[[-122.25145, 38.17329], [-122.25132, 38.17587], [-122.24971, 38.17597], [-122.24975, 38.17328], [-122.25145, 38.17329]]]} | Open Access 1 | 16361 | Main Street Park | 21690 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 10.509 | Main Street Park | 2006 | Local Park 2 | 4 | |
9689 | 9689 | 9688 | {"type": "Polygon", "coordinates": [[[-122.23537, 38.15763], [-122.23535, 38.15768], [-122.23501, 38.15794], [-122.23444, 38.15748], [-122.23484, 38.15717], [-122.23501, 38.15708], [-122.23509, 38.1571], [-122.23537, 38.15763]]]} | Open Access 1 | 16362 | Pelleria Park | 23569 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 1.052 | Pelleria Park | 2004 | Local Park 2 | 4 | |
10121 | 10121 | 10120 | {"type": "Polygon", "coordinates": [[[-122.25007, 38.16579], [-122.25006, 38.16611], [-122.24926, 38.16618], [-122.24901, 38.16619], [-122.24855, 38.16624], [-122.24795, 38.16628], [-122.24767, 38.16632], [-122.24714, 38.16636], [-122.24707, 38.16634], [-122.24676, 38.16635], [-122.24673, 38.16638], [-122.24666, 38.16636], [-122.2466, 38.16636], [-122.24648, 38.16624], [-122.24617, 38.16623], [-122.24613, 38.16637], [-122.2461, 38.16692], [-122.24607, 38.16705], [-122.24567, 38.16833], [-122.24481, 38.16833], [-122.24437, 38.16835], [-122.24436, 38.16612], [-122.24297, 38.1657], [-122.24259, 38.16565], [-122.2424, 38.16566], [-122.24223, 38.16562], [-122.24167, 38.16545], [-122.24143, 38.16543], [-122.24137, 38.16545], [-122.24127, 38.16537], [-122.24113, 38.16538], [-122.24109, 38.16533], [-122.24066, 38.16533], [-122.24065, 38.16534], [-122.24096, 38.16671], [-122.24044, 38.16609], [-122.24015, 38.16562], [-122.24004, 38.16511], [-122.24004, 38.16489], [-122.24005, 38.16481], [-122.24015, 38.16476], [-122.24066, 38.16488], [-122.24128, 38.16496], [-122.24386, 38.16536], [-122.24448, 38.16579], [-122.24464, 38.16579], [-122.2447, 38.16598], [-122.24471, 38.16623], [-122.24684, 38.16591], [-122.2472, 38.16605], [-122.24759, 38.16583], [-122.24809, 38.16587], [-122.24906, 38.16569], [-122.24923, 38.16559], [-122.24923, 38.16557], [-122.24991, 38.16564], [-122.25007, 38.16579]]]} | Open Access 1 | 17590 | Silver Oak Park | 25492 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 19.202 | Silver Oak Park | 2006 | Local Park 2 | 4 | |
10122 | 10122 | 10121 | {"type": "Polygon", "coordinates": [[[-122.24673, 38.1727], [-122.24652, 38.17245], [-122.24632, 38.17212], [-122.24572, 38.17098], [-122.24564, 38.171], [-122.24564, 38.17095], [-122.24509, 38.1698], [-122.24504, 38.16965], [-122.24502, 38.16951], [-122.24501, 38.16921], [-122.24495, 38.16856], [-122.24502, 38.16856], [-122.24511, 38.16849], [-122.24562, 38.1685], [-122.24562, 38.16866], [-122.24567, 38.16893], [-122.24569, 38.16921], [-122.24593, 38.16921], [-122.24604, 38.16925], [-122.24617, 38.16922], [-122.24652, 38.16923], [-122.24659, 38.16931], [-122.24659, 38.17036], [-122.2467, 38.17036], [-122.2467, 38.1719], [-122.24663, 38.17192], [-122.24673, 38.1727]]]} | Open Access 1 | 17591 | Shenandoah Park | 25389 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 9.048 | Shenandoah Park | 2008 | Local Park 2 | 4 | |
10123 | 10123 | 10122 | {"type": "Polygon", "coordinates": [[[-122.25278, 38.15531], [-122.2528, 38.15702], [-122.25268, 38.15846], [-122.25237, 38.163], [-122.25231, 38.16505], [-122.25224, 38.16546], [-122.25214, 38.16545], [-122.25221, 38.16497], [-122.2521, 38.16423], [-122.25216, 38.16415], [-122.2522, 38.16406], [-122.25222, 38.16397], [-122.25221, 38.16386], [-122.25211, 38.16342], [-122.25154, 38.15991], [-122.25208, 38.15779], [-122.25215, 38.15755], [-122.25227, 38.15533], [-122.25278, 38.15531]]]} | Open Access 1 | 17592 | Veterans Memorial Park | 27024 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 13.899 | Veterans Memorial Park | 2008 | Local Park 2 | 4 | |
10126 | 10126 | 10125 | {"type": "Polygon", "coordinates": [[[-122.25487, 38.17441], [-122.25417, 38.17448], [-122.25406, 38.17387], [-122.2547, 38.1738], [-122.25475, 38.17413], [-122.25483, 38.17413], [-122.25487, 38.17441]]]} | Open Access 1 | 17596 | Melvin Park | 22114 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 1.001 | Melvin Park | 0 | Local Park 2 | 4 | |
10128 | 10128 | 10127 | {"type": "Polygon", "coordinates": [[[-122.26963, 38.18034], [-122.26953, 38.18042], [-122.26821, 38.18041], [-122.26821, 38.18035], [-122.26832, 38.18031], [-122.26835, 38.18027], [-122.26837, 38.18022], [-122.26833, 38.18013], [-122.26822, 38.18005], [-122.2687, 38.18], [-122.26866, 38.17971], [-122.26953, 38.17962], [-122.26963, 38.18022], [-122.26963, 38.18034]]]} | Open Access 1 | 17598 | Gadwell Park | 19168 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 2.013 | Gadwell Park | 2004 | 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]);