units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 204 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12501 | 12501 | 12500 | {"type": "MultiPolygon", "coordinates": [[[[-122.05671, 38.25641], [-122.05649, 38.25652], [-122.05634, 38.25651], [-122.0563, 38.25649], [-122.05666, 38.25634], [-122.05671, 38.25641]]], [[[-122.06112, 38.25383], [-122.06072, 38.254], [-122.06069, 38.25395], [-122.06087, 38.25392], [-122.06096, 38.25387], [-122.06108, 38.25378], [-122.06112, 38.25383]]]]} | Open Access 1 | 28317 | Linear Park Playground | 21306 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 0.116 | Linear Park Playground | 0 | Local Recreation Area 3 | 4 | |
4128 | 4128 | 4127 | {"type": "Polygon", "coordinates": [[[-122.05474, 38.25477], [-122.05436, 38.25478], [-122.05436, 38.25458], [-122.05473, 38.25458], [-122.05474, 38.25477]]]} | Open Access 1 | 28314 | Hayes & Utah Street Tot Lot | 19754 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 0.175 | Hayes & Utah Street Tot Lot | 0 | Local Recreation Area 3 | 4 | |
12500 | 12500 | 12499 | {"type": "Polygon", "coordinates": [[[-122.06016, 38.25216], [-122.05982, 38.25215], [-122.05981, 38.25188], [-122.06016, 38.25187], [-122.06016, 38.25216]]]} | Open Access 1 | 28316 | Kentucky Street Tot Lot | 20622 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 0.235 | Kentucky Street Tot Lot | 0 | Local Recreation Area 3 | 4 | |
12499 | 12499 | 12498 | {"type": "Polygon", "coordinates": [[[-122.05196, 38.28157], [-122.05189, 38.28173], [-122.05184, 38.28197], [-122.0518, 38.28203], [-122.05173, 38.28215], [-122.05151, 38.28236], [-122.05144, 38.28239], [-122.05123, 38.2821], [-122.05113, 38.28209], [-122.05107, 38.28211], [-122.05101, 38.2821], [-122.05098, 38.28206], [-122.05103, 38.2819], [-122.05102, 38.28184], [-122.05096, 38.28181], [-122.05092, 38.28172], [-122.05091, 38.28165], [-122.05092, 38.2816], [-122.05102, 38.28151], [-122.05113, 38.28151], [-122.05134, 38.28146], [-122.05135, 38.28138], [-122.05135, 38.28127], [-122.0514, 38.28116], [-122.05148, 38.28112], [-122.05159, 38.28113], [-122.05169, 38.28118], [-122.05178, 38.28128], [-122.05196, 38.28157]]]} | Open Access 1 | 28315 | Meadow Glen Park | 22071 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 1.894 | Meadow Glen Park | 0 | Local Park 2 | 4 | |
5736 | 5736 | 5735 | {"type": "Polygon", "coordinates": [[[-121.99862, 38.26741], [-121.99801, 38.26763], [-121.9976, 38.26714], [-121.99761, 38.26711], [-121.99757, 38.26706], [-121.99724, 38.26669], [-121.99708, 38.26654], [-121.99709, 38.26593], [-121.99855, 38.26597], [-121.99855, 38.26636], [-121.99851, 38.26651], [-121.99844, 38.26664], [-121.99843, 38.26685], [-121.99855, 38.26715], [-121.99862, 38.26741]]]} | Open Access 1 | 1658 | Tolenas Park | 26391 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 4.428 | Tolenas Park | 0 | Local Park 2 | 4 | |
10207 | 10207 | 10206 | {"type": "Polygon", "coordinates": [[[-122.00251, 38.2696], [-122.00233, 38.26963], [-122.0022, 38.26968], [-122.00115, 38.27042], [-122.001, 38.27046], [-122.00064, 38.27045], [-122.00079, 38.26977], [-122.00083, 38.26941], [-122.00093, 38.269], [-122.00111, 38.26902], [-122.0015, 38.26897], [-122.0016, 38.26894], [-122.00174, 38.26885], [-122.00196, 38.26874], [-122.0021, 38.26877], [-122.00234, 38.26902], [-122.00237, 38.26924], [-122.00236, 38.26929], [-122.0023, 38.26936], [-122.00231, 38.26939], [-122.0023, 38.26945], [-122.00243, 38.2695], [-122.00249, 38.2695], [-122.00251, 38.2696]]]} | Open Access 1 | 17842 | Meadow Glen Park | 22071 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 4.48 | Meadow Glen Park | 0 | Local Park 2 | 4 | |
5875 | 5875 | 5874 | {"type": "Polygon", "coordinates": [[[-122.04432, 38.29059], [-122.04427, 38.29062], [-122.04427, 38.29071], [-122.04431, 38.29077], [-122.04426, 38.29094], [-122.0442, 38.29104], [-122.04393, 38.29127], [-122.04357, 38.29146], [-122.04294, 38.29078], [-122.04292, 38.29074], [-122.04278, 38.29065], [-122.04269, 38.29046], [-122.04269, 38.29014], [-122.04274, 38.28977], [-122.04276, 38.28974], [-122.04304, 38.28972], [-122.04351, 38.28963], [-122.04354, 38.28966], [-122.04358, 38.28966], [-122.04374, 38.28982], [-122.04378, 38.2899], [-122.04384, 38.28997], [-122.04405, 38.29016], [-122.04414, 38.29022], [-122.04426, 38.29032], [-122.04432, 38.29046], [-122.04432, 38.29059]]]} | Open Access 1 | 260 | Rolling Hills Neighborhood Park | 24576 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 4.814 | Rolling Hills Neighborhood Park | 0 | Local Park 2 | 4 | |
564 | 564 | 563 | {"type": "Polygon", "coordinates": [[[-122.04514, 38.26755], [-122.04396, 38.26758], [-122.04393, 38.26754], [-122.04333, 38.26755], [-122.04331, 38.26645], [-122.04405, 38.26643], [-122.04513, 38.26644], [-122.04514, 38.26755]]]} | Open Access 1 | 1883 | Veteran's Memorial Park | 27011 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 4.887 | Veteran's Memorial Park | 0 | Local Park 2 | 4 | |
5729 | 5729 | 5728 | {"type": "Polygon", "coordinates": [[[-122.07467, 38.25809], [-122.07465, 38.25814], [-122.07455, 38.25817], [-122.07325, 38.25841], [-122.07321, 38.25823], [-122.07312, 38.25799], [-122.07303, 38.25758], [-122.07301, 38.25737], [-122.07294, 38.25719], [-122.07284, 38.25702], [-122.0728, 38.25697], [-122.07274, 38.25677], [-122.07369, 38.25642], [-122.07467, 38.25809]]]} | Open Access 1 | 2255 | Woodcreek Park | 27703 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 5.298 | Woodcreek Park | 0 | Local Park 2 | 4 | |
2312 | 2312 | 2311 | {"type": "Polygon", "coordinates": [[[-122.04197, 38.27757], [-122.0416, 38.27758], [-122.04147, 38.27761], [-122.04132, 38.27769], [-122.04097, 38.27776], [-122.04013, 38.27786], [-122.04013, 38.27648], [-122.04191, 38.27649], [-122.04197, 38.27653], [-122.04197, 38.27757]]]} | Open Access 1 | 16959 | Hillview Park | 19993 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 5.466 | Hillview Park | 0 | Local Park 2 | 4 | |
10111 | 10111 | 10110 | {"type": "Polygon", "coordinates": [[[-122.06362, 38.26685], [-122.06308, 38.26853], [-122.06218, 38.26864], [-122.06218, 38.26842], [-122.06216, 38.26832], [-122.06217, 38.26688], [-122.06212, 38.26682], [-122.06224, 38.26646], [-122.06362, 38.26685]]]} | Open Access 1 | 17546 | Mankas Park | 21750 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 5.6 | Mankas Park | 0 | Local Park 2 | 4 | |
3084 | 3084 | 3083 | {"type": "Polygon", "coordinates": [[[-122.14851, 38.21905], [-122.14849, 38.21918], [-122.14819, 38.2197], [-122.14804, 38.21983], [-122.14746, 38.22024], [-122.14718, 38.22007], [-122.14659, 38.21961], [-122.1463, 38.21944], [-122.14613, 38.21936], [-122.14611, 38.21932], [-122.14612, 38.21923], [-122.14714, 38.21825], [-122.14742, 38.21851], [-122.1478, 38.21875], [-122.14819, 38.21892], [-122.14844, 38.21898], [-122.14851, 38.21905]]]} | Open Access 1 | 1908 | Vintage Green Valley Park | 27145 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 6.117 | Vintage Green Valley Park | 0 | Local Park 2 | 4 | |
13807 | 13807 | 13806 | {"type": "Polygon", "coordinates": [[[-122.01497, 38.28933], [-122.01455, 38.28938], [-122.01421, 38.28953], [-122.01412, 38.28954], [-122.01398, 38.2895], [-122.01352, 38.28967], [-122.01353, 38.28977], [-122.0136, 38.28997], [-122.01351, 38.29013], [-122.01313, 38.28976], [-122.01302, 38.28933], [-122.01314, 38.2891], [-122.01337, 38.28884], [-122.01336, 38.28882], [-122.0137, 38.28834], [-122.01375, 38.28784], [-122.01373, 38.28782], [-122.01375, 38.28782], [-122.01406, 38.28783], [-122.01457, 38.28804], [-122.01493, 38.28826], [-122.01503, 38.28868], [-122.01495, 38.28906], [-122.01497, 38.28933]]]} | Open Access 1 | 36384 | Fairfield holding 1 | 18795 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 6.146 | Fairfield holding 1 | 0 | Local Other or Unknown 14 | 4 | |
6280 | 6280 | 6279 | {"type": "Polygon", "coordinates": [[[-122.01429, 38.26531], [-122.01427, 38.26661], [-122.01228, 38.26662], [-122.01227, 38.2653], [-122.01232, 38.26529], [-122.01429, 38.26531]]]} | Open Access 1 | 1402 | Tabor Park | 26162 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 6.355 | Tabor Park | 0 | Local Park 2 | 4 | |
5469 | 5469 | 5468 | {"type": "Polygon", "coordinates": [[[-122.04031, 38.25555], [-122.04029, 38.25817], [-122.03928, 38.25818], [-122.03926, 38.25722], [-122.03922, 38.25721], [-122.03924, 38.25552], [-122.04018, 38.25553], [-122.04031, 38.25555]]]} | Open Access 1 | 17335 | Lee Bell Park | 21131 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 6.668 | Lee Bell Park | 0 | Local Park 2 | 4 | |
6237 | 6237 | 6236 | {"type": "Polygon", "coordinates": [[[-122.03044, 38.28308], [-122.02968, 38.28308], [-122.02967, 38.28305], [-122.02961, 38.28299], [-122.02948, 38.28298], [-122.02941, 38.283], [-122.02935, 38.28306], [-122.0286, 38.28308], [-122.02827, 38.28307], [-122.02828, 38.28276], [-122.02826, 38.28269], [-122.02821, 38.28265], [-122.02821, 38.28258], [-122.02813, 38.28244], [-122.02814, 38.28231], [-122.02813, 38.28227], [-122.02807, 38.28222], [-122.02807, 38.2821], [-122.0281, 38.28207], [-122.0281, 38.28185], [-122.02845, 38.2818], [-122.03041, 38.28169], [-122.03044, 38.28308]]]} | Open Access 1 | 1301 | Sunrise Park | 26021 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 7.09 | Sunrise Park | 0 | Local Park 2 | 4 | |
4127 | 4127 | 4126 | {"type": "Polygon", "coordinates": [[[-121.97912, 38.29715], [-121.97792, 38.29773], [-121.97767, 38.29735], [-121.97673, 38.2962], [-121.97642, 38.29586], [-121.97764, 38.29528], [-121.97775, 38.2953], [-121.97912, 38.29715]]]} | Open Access 1 | 28313 | Gary Falati Park | 19229 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 7.567 | Gary Falati Park | 0 | Local Park 2 | 4 | |
17037 | 17037 | 17036 | {"type": "Polygon", "coordinates": [[[-122.049, 38.2523], [-122.04898, 38.25324], [-122.04829, 38.25323], [-122.04829, 38.25341], [-122.04822, 38.25341], [-122.04799, 38.2534], [-122.04772, 38.25335], [-122.04706, 38.25312], [-122.04688, 38.25309], [-122.04657, 38.25308], [-122.04598, 38.25321], [-122.04557, 38.25337], [-122.04533, 38.25348], [-122.04532, 38.25288], [-122.04554, 38.25289], [-122.04567, 38.25287], [-122.04568, 38.25245], [-122.04566, 38.25234], [-122.04575, 38.25233], [-122.04575, 38.25227], [-122.04584, 38.25215], [-122.04589, 38.25212], [-122.04666, 38.25213], [-122.0467, 38.2522], [-122.0473, 38.25219], [-122.04727, 38.25226], [-122.04764, 38.25227], [-122.04806, 38.25237], [-122.04832, 38.2524], [-122.04853, 38.25236], [-122.04867, 38.2523], [-122.04873, 38.25226], [-122.04875, 38.25228], [-122.049, 38.2523]]]} | Open Access 1 | 28312 | Civic Center Park | 17356 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 8.233 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
7993 | 7993 | 7992 | {"type": "Polygon", "coordinates": [[[-122.14304, 38.19095], [-122.14273, 38.1911], [-122.14244, 38.19273], [-122.1424, 38.19282], [-122.14233, 38.19284], [-122.14197, 38.1927], [-122.14176, 38.19259], [-122.14156, 38.19252], [-122.14126, 38.19248], [-122.1408, 38.19248], [-122.14062, 38.19246], [-122.14051, 38.19243], [-122.14051, 38.19235], [-122.14104, 38.19081], [-122.14151, 38.19087], [-122.14213, 38.19078], [-122.14284, 38.19063], [-122.14304, 38.19095]]]} | Open Access 1 | 10988 | Ridgeview Park | 24359 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 8.277 | Ridgeview Park | 0 | Local Park 2 | 4 | |
9435 | 9435 | 9434 | {"type": "Polygon", "coordinates": [[[-122.02401, 38.26071], [-122.02263, 38.26068], [-122.02261, 38.25964], [-122.02245, 38.25963], [-122.0225, 38.25902], [-122.02244, 38.25828], [-122.02395, 38.2583], [-122.02399, 38.25833], [-122.02401, 38.25835], [-122.02402, 38.2587], [-122.02401, 38.26071]]]} | Open Access 1 | 15775 | Dover Park | 18252 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 8.537 | Dover 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]);