superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 204 sorted by ACRES
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6231 | 6231 | 6230 | {"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 | Linear Park Playground | 21306 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 0.116 | Linear Park Playground | ||
4978 | 4978 | 4977 | {"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 | Hayes & Utah Street Tot Lot | 19754 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 0.174 | Hayes & Utah Street Tot Lot | ||
4594 | 4594 | 4593 | {"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 | Kentucky Street Tot Lot | 20622 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 0.235 | Kentucky Street Tot Lot | ||
8894 | 8894 | 8893 | {"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 | Tolenas Park | 26391 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 4.428 | Tolenas Park | ||
8913 | 8913 | 8912 | {"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.04291, 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 | Rolling Hills Neighborhood Park | 24576 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 4.814 | Rolling Hills Neighborhood Park | ||
10798 | 10798 | 10797 | {"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 | Veteran's Memorial Park | 27011 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 4.887 | Veteran's Memorial Park | ||
11370 | 11370 | 11369 | {"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.07285, 38.25702], [-122.0728, 38.25697], [-122.07274, 38.25677], [-122.07369, 38.25642], [-122.07467, 38.25809]]]} | Open Access 1 | Woodcreek Park | 27703 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 5.298 | Woodcreek Park | ||
4149 | 4149 | 4148 | {"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.27654], [-122.04197, 38.27757]]]} | Open Access 1 | Hillview Park | 19993 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 5.465 | Hillview Park | ||
5560 | 5560 | 5559 | {"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 | Mankas Park | 21750 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 5.599 | Mankas Park | ||
10923 | 10923 | 10922 | {"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.21852], [-122.14779, 38.21875], [-122.14819, 38.21892], [-122.14844, 38.21898], [-122.14851, 38.21905]]]} | Open Access 1 | Vintage Green Valley Park | 27145 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 6.117 | Vintage Green Valley Park | ||
3259 | 3259 | 3258 | {"type": "Polygon", "coordinates": [[[-122.01497, 38.28933], [-122.01455, 38.28938], [-122.01421, 38.28953], [-122.01412, 38.28954], [-122.01398, 38.2895], [-122.01353, 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.28785], [-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 | Fairfield holding 1 | 18795 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 6.147 | Fairfield holding 1 | ||
8680 | 8680 | 8679 | {"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 | Tabor Park | 26162 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 6.354 | Tabor Park | ||
6861 | 6861 | 6860 | {"type": "MultiPolygon", "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]]], [[[-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.28189], [-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.05133, 38.28146], [-122.05135, 38.28137], [-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 | Meadow Glen Park | 22071 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 6.376 | Meadow Glen Park | ||
6075 | 6075 | 6074 | {"type": "Polygon", "coordinates": [[[-122.04031, 38.25555], [-122.04029, 38.25817], [-122.03928, 38.25818], [-122.03926, 38.25723], [-122.03922, 38.25721], [-122.03924, 38.25552], [-122.04018, 38.25553], [-122.04031, 38.25555]]]} | Open Access 1 | Lee Bell Park | 21131 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 6.668 | Lee Bell Park | ||
10104 | 10104 | 10103 | {"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 | Sunrise Park | 26021 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 7.09 | Sunrise Park | ||
4508 | 4508 | 4507 | {"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 | Gary Falati Park | 19229 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 7.566 | Gary Falati Park | ||
15543 | 15543 | 15542 | {"type": "Polygon", "coordinates": [[[-122.049, 38.2523], [-122.04898, 38.25324], [-122.0483, 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.04553, 38.25289], [-122.04567, 38.25287], [-122.04568, 38.25245], [-122.04566, 38.25234], [-122.04574, 38.25233], [-122.04575, 38.25227], [-122.04584, 38.25215], [-122.04589, 38.25212], [-122.04666, 38.25213], [-122.04671, 38.2522], [-122.0473, 38.25219], [-122.04728, 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 | Civic Center Park | 17356 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 8.238 | Civic Ctr. Park | ||
8700 | 8700 | 8699 | {"type": "Polygon", "coordinates": [[[-122.14304, 38.19095], [-122.14273, 38.19111], [-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 | Ridgeview Park | 24359 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 8.278 | Ridgeview Park | ||
3692 | 3692 | 3691 | {"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 | Dover Park | 18252 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 8.537 | Dover Park | ||
1475 | 1475 | 1474 | {"type": "Polygon", "coordinates": [[[-122.1469, 38.19688], [-122.14679, 38.19694], [-122.14671, 38.19692], [-122.14621, 38.19672], [-122.14624, 38.1965], [-122.1459, 38.19623], [-122.14581, 38.19597], [-122.14579, 38.19566], [-122.14573, 38.19545], [-122.14544, 38.19539], [-122.14553, 38.19513], [-122.14552, 38.19504], [-122.14545, 38.19499], [-122.14532, 38.19496], [-122.14574, 38.19453], [-122.1455, 38.19433], [-122.14546, 38.19427], [-122.14541, 38.19423], [-122.14534, 38.1942], [-122.14531, 38.19416], [-122.1453, 38.19409], [-122.14489, 38.19382], [-122.14492, 38.19377], [-122.14492, 38.1937], [-122.14487, 38.19364], [-122.14479, 38.19361], [-122.14468, 38.19361], [-122.14444, 38.19344], [-122.14405, 38.19339], [-122.14384, 38.19325], [-122.14385, 38.19318], [-122.14372, 38.19311], [-122.1436, 38.19309], [-122.14314, 38.19344], [-122.14294, 38.19334], [-122.14252, 38.19319], [-122.14221, 38.19312], [-122.14152, 38.19309], [-122.14144, 38.19283], [-122.14127, 38.19279], [-122.14114, 38.1928], [-122.14081, 38.19294], [-122.14064, 38.19275], [-122.14051, 38.19264], [-122.14031, 38.19254], [-122.14016, 38.19252], [-122.14001, 38.19253], [-122.13988, 38.19248], [-122.13976, 38.19257], [-122.13948, 38.19244], [-122.13938, 38.19244], [-122.13927, 38.19234], [-122.13914, 38.19232], [-122.13848, 38.19213], [-122.13845, 38.19112], [-122.13856, 38.19112], [-122.1388, 38.19118], [-122.13893, 38.19125], [-122.13912, 38.19151], [-122.13921, 38.19149], [-122.13953, 38.19165], [-122.13969, 38.19189], [-122.13979, 38.19188], [-122.14007, 38.19193], [-122.14057, 38.19205], [-122.14059, 38.19207], [-122.1405, 38.19235], [-122.14049, 38.19242], [-122.14051, 38.19245], [-122.14081, 38.19249], [-122.14125, 38.19249], [-122.14155, 38.19253], [-122.14171, 38.19259], [-122.14197, 38.19271], [-122.14234, 38.19284], [-122.14243, 38.19282], [-122.14247, 38.19269], [-122.14294, 38.19268], [-122.14345, 38.19263], [-122.14356, 38.19253], [-122.14415, 38.19254], [-122.14424, 38.19266], [-122.1446, 38.1929], [-122.14492, 38.19301], [-122.14502, 38.19299], [-122.14505, 38.19304], [-122.14514, 38.19306], [-122.14522, 38.19305], [-122.14527, 38.19301], [-122.14551, 38.19328], [-122.14586, 38.19305], [-122.14623, 38.19418], [-122.14675, 38.1959], [-122.14689, 38.19633], [-122.14695, 38.19642], [-122.14698, 38.19666], [-122.1469, 38.19688]]]} | Open Access 1 | American Canyon Creek Park | 15447 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 17.953 | American Canyon Creek Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);