superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where MNG_AGENCY = 385 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13731 | 13731 | 13730 | {"type": "Polygon", "coordinates": [[[-122.02649, 38.01854], [-122.02529, 38.01892], [-122.02508, 38.01872], [-122.02404, 38.01933], [-122.01786, 38.01685], [-122.01615, 38.01606], [-122.01379, 38.01187], [-122.01827, 38.01106], [-122.02232, 38.01073], [-122.02266, 38.01085], [-122.02298, 38.01167], [-122.0232, 38.01212], [-122.02344, 38.01272], [-122.0237, 38.01327], [-122.0239, 38.01321], [-122.02459, 38.01463], [-122.0243, 38.01473], [-122.02585, 38.01792], [-122.02616, 38.01785], [-122.02649, 38.01854]]]} | Restricted Access 2 | Diablo Creek Golf Course | 33034 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 150.585 | Diablo Creek GC | ||
11699 | 11699 | 11698 | {"type": "Polygon", "coordinates": [[[-121.94894, 37.95659], [-121.94812, 37.95676], [-121.94769, 37.95718], [-121.94595, 37.95732], [-121.94556, 37.95747], [-121.94522, 37.95733], [-121.94478, 37.95735], [-121.94426, 37.95733], [-121.94353, 37.95711], [-121.94302, 37.957], [-121.94253, 37.95683], [-121.94236, 37.95692], [-121.94229, 37.95689], [-121.94223, 37.9569], [-121.94208, 37.95672], [-121.94172, 37.95664], [-121.94141, 37.95649], [-121.94116, 37.95642], [-121.94053, 37.95602], [-121.9399, 37.9559], [-121.94005, 37.95573], [-121.94022, 37.9556], [-121.94045, 37.95581], [-121.94064, 37.95573], [-121.9428, 37.95516], [-121.94301, 37.95513], [-121.94349, 37.95516], [-121.94377, 37.95516], [-121.94406, 37.95513], [-121.94503, 37.95483], [-121.94529, 37.95473], [-121.94551, 37.95461], [-121.94551, 37.95459], [-121.9453, 37.95439], [-121.94545, 37.95428], [-121.94565, 37.95443], [-121.94581, 37.95462], [-121.94617, 37.9549], [-121.94641, 37.95496], [-121.94663, 37.95505], [-121.94703, 37.95524], [-121.94707, 37.9552], [-121.94792, 37.95578], [-121.9482, 37.95594], [-121.94845, 37.95617], [-121.9486, 37.95614], [-121.94868, 37.95609], [-121.9488, 37.9563], [-121.94894, 37.95659]]]} | Open Access 1 | Unnamed site - Concord, City of | 30380 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 35.165 | |||
11425 | 11425 | 11424 | {"type": "Polygon", "coordinates": [[[-122.03014, 37.94438], [-122.02767, 37.94589], [-122.02678, 37.94493], [-122.02722, 37.94455], [-122.02771, 37.94422], [-122.02807, 37.94401], [-122.02924, 37.94341], [-122.03014, 37.94438]]]} | Open Access 1 | Ygnacio Valley Park | 27771 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 9.461 | Ygnacio Valley Park | ||
11283 | 11283 | 11282 | {"type": "MultiPolygon", "coordinates": [[[[-122.02054, 37.98502], [-122.01997, 37.98528], [-122.01976, 37.9854], [-122.01948, 37.98561], [-122.01903, 37.98604], [-122.01742, 37.98529], [-122.01715, 37.98514], [-122.01703, 37.98505], [-122.01682, 37.98483], [-122.01587, 37.98356], [-122.01718, 37.98295], [-122.0186, 37.98485], [-122.01994, 37.98422], [-122.02054, 37.98502]]], [[[-122.02351, 37.99321], [-122.0232, 37.99333], [-122.02241, 37.99272], [-122.02243, 37.99268], [-122.02224, 37.99248], [-122.02216, 37.99237], [-122.0221, 37.99225], [-122.02204, 37.99207], [-122.02132, 37.98904], [-122.02126, 37.98885], [-122.02119, 37.9887], [-122.02109, 37.98856], [-122.01954, 37.98648], [-122.01938, 37.9863], [-122.01924, 37.98618], [-122.01969, 37.98576], [-122.01993, 37.98557], [-122.02068, 37.98522], [-122.02264, 37.98785], [-122.02208, 37.98863], [-122.02247, 37.98882], [-122.02351, 37.99321]]]]} | Open Access 1 | Willow Pass Community Park | 27586 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 40.406 | Willow Pass Community Park | ||
10382 | 10382 | 10381 | {"type": "Polygon", "coordinates": [[[-122.03452, 37.97743], [-122.03363, 37.97784], [-122.0331, 37.97714], [-122.03399, 37.97672], [-122.03452, 37.97743]]]} | Open Access 1 | Todos Santos | 26388 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 2.043 | Todos Santos | ||
10068 | 10068 | 10067 | {"type": "Polygon", "coordinates": [[[-122.03573, 38.00376], [-122.0353, 38.00455], [-122.03501, 38.00407], [-122.03474, 38.00393], [-122.03454, 38.00418], [-122.03377, 38.00383], [-122.03373, 38.00378], [-122.03394, 38.00348], [-122.03424, 38.00361], [-122.03447, 38.0033], [-122.03476, 38.00343], [-122.03573, 38.00376]]]} | Open Access 1 | Sun Terrace Park | 25978 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 2.6 | Sun Terrace Park | ||
8686 | 8686 | 8685 | {"type": "Polygon", "coordinates": [[[-122.03362, 37.95355], [-122.03337, 37.95375], [-122.03326, 37.95323], [-122.03322, 37.9531], [-122.03317, 37.95297], [-122.03305, 37.95277], [-122.03291, 37.9526], [-122.03275, 37.95245], [-122.03249, 37.95228], [-122.03218, 37.95214], [-122.03236, 37.95203], [-122.03242, 37.9521], [-122.03262, 37.95225], [-122.03282, 37.95234], [-122.03284, 37.95242], [-122.03302, 37.95259], [-122.03321, 37.95285], [-122.03333, 37.95319], [-122.0334, 37.95331], [-122.03354, 37.95344], [-122.03362, 37.95355]]]} | Open Access 1 | Rick Sears Park | 24345 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 0.596 | Rick Sears Park | ||
8146 | 8146 | 8145 | {"type": "Polygon", "coordinates": [[[-121.96645, 37.94232], [-121.96608, 37.94253], [-121.96599, 37.94254], [-121.96473, 37.94158], [-121.96454, 37.94147], [-121.96421, 37.94134], [-121.96412, 37.94126], [-121.96395, 37.94126], [-121.96335, 37.94117], [-121.96308, 37.94116], [-121.96301, 37.94113], [-121.963, 37.9411], [-121.96298, 37.94078], [-121.96303, 37.94049], [-121.96311, 37.94021], [-121.96344, 37.93939], [-121.96352, 37.93926], [-121.96384, 37.93885], [-121.9639, 37.93884], [-121.96393, 37.93885], [-121.96362, 37.93926], [-121.96346, 37.93958], [-121.96341, 37.93975], [-121.96337, 37.94009], [-121.96339, 37.94027], [-121.96373, 37.94024], [-121.96375, 37.94031], [-121.96381, 37.94046], [-121.96397, 37.94065], [-121.96371, 37.94086], [-121.96387, 37.94097], [-121.96406, 37.94107], [-121.96435, 37.94116], [-121.96463, 37.94119], [-121.96487, 37.94118], [-121.96505, 37.94114], [-121.96512, 37.94122], [-121.96494, 37.94169], [-121.96542, 37.94207], [-121.96561, 37.94216], [-121.96575, 37.9422], [-121.96645, 37.94232]]]} | Open Access 1 | Pine Hollow Estates | 23680 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 3.624 | Pine Hollow Estates | ||
7358 | 7358 | 7357 | {"type": "MultiPolygon", "coordinates": [[[[-121.99479, 37.96098], [-121.99442, 37.96146], [-121.99399, 37.96144], [-121.99403, 37.96088], [-121.99396, 37.96089], [-121.99183, 37.96056], [-121.99172, 37.96131], [-121.99205, 37.96149], [-121.99196, 37.96148], [-121.98214, 37.95919], [-121.98101, 37.95825], [-121.98095, 37.95832], [-121.98086, 37.95824], [-121.98071, 37.95815], [-121.97998, 37.95788], [-121.98003, 37.95778], [-121.9799, 37.95772], [-121.97958, 37.95739], [-121.97949, 37.95719], [-121.97934, 37.95713], [-121.97922, 37.95697], [-121.97906, 37.95686], [-121.97912, 37.95673], [-121.97732, 37.9551], [-121.97713, 37.95541], [-121.97633, 37.95481], [-121.97615, 37.9551], [-121.97479, 37.95388], [-121.97489, 37.9537], [-121.97495, 37.95323], [-121.9749, 37.95287], [-121.97476, 37.95274], [-121.9745, 37.95284], [-121.97436, 37.95267], [-121.97421, 37.95257], [-121.97392, 37.95245], [-121.97357, 37.9524], [-121.97354, 37.95235], [-121.97369, 37.95218], [-121.97391, 37.95198], [-121.97399, 37.95204], [-121.97428, 37.95189], [-121.9746, 37.9518], [-121.97494, 37.95177], [-121.97582, 37.95177], [-121.9762, 37.9517], [-121.97642, 37.95164], [-121.97649, 37.95166], [-121.97652, 37.95165], [-121.97747, 37.953], [-121.97842, 37.95399], [-121.97859, 37.95411], [-121.97896, 37.95432], [-121.97948, 37.95457], [-121.97963, 37.95468], [-121.97991, 37.95492], [-121.98074, 37.95585], [-121.98083, 37.95592], [-121.98101, 37.95603], [-121.98123, 37.95611], [-121.98146, 37.95614], [-121.98169, 37.95615], [-121.98192, 37.95611], [-121.98223, 37.95599], [-121.98294, 37.95557], [-121.98323, 37.95543], [-121.98337, 37.95575], [-121.98352, 37.9559], [-121.98373, 37.95599], [-121.98404, 37.95607], [-121.98443, 37.95627], [-121.98547, 37.95672], [-121.98586, 37.9568], [-121.98622, 37.95681], [-121.98672, 37.95699], [-121.98698, 37.95704], [-121.98722, 37.95706], [-121.98763, 37.95721], [-121.98795, 37.95742], [-121.98819, 37.95767], [-121.98833, 37.95779], [-121.98847, 37.95797], [-121.98886, 37.95827], [-121.9891, 37.95835], [-121.98911, 37.95883], [-121.98865, 37.95901], [-121.98865, 37.9593], [-121.98851, 37.95931], [-121.98847, 37.95932], [-121.98843, 37.95935], [-121.9884, 37.95941], [-121.98842, 37.95949], [-121.98851, 37.95954], [-121.98856, 37.95955], [-121.98863, 37.95953], [-121.98869, 37.95948], [-121.98871, 37.95968], [-121.99005, 37.95967], [-121.99025, 37.9597], [-121.9905, 37.95977], [-121.99072, 37.9598], [-121.99079, 37.95956], [-121.99101, 37.95957], [-121.99117, 37.95954], [-121.99138, 37.95947], [-121.99155, 37.95939], [-121.9918, 37.95952], [-121.99202, 37.9596], [-121.99236, 37.95965], [-121.99242, 37.95985], [-121.99256, 37.96009], [-121.99288, 37.96023], [-121.99367, 37.96017], [-121.99372, 37.96025], [-121.99382, 37.96033], [-121.99407, 37.96016], [-121.99418, 37.96025], [-121.99396, 37.96045], [-121.99409, 37.96056], [-121.99418, 37.96069], [-121.99436, 37.96084], [-121.99479, 37.96098]]], [[[-121.98862, 37.96075], [-121.9885, 37.96096], [-121.98795, 37.96077], [-121.988, 37.96068], [-121.98799, 37.96066], [-121.98784, 37.96061], [-121.9878, 37.96067], [-121.98744, 37.96049], [-121.98862, 37.96075]]]]} | Open Access 1 | Newhall Community Park | 22724 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 116.939 | Newhall Community Park | ||
6863 | 6863 | 6862 | {"type": "Polygon", "coordinates": [[[-122.04156, 37.96284], [-122.04157, 37.96319], [-122.04143, 37.9635], [-122.03856, 37.96546], [-122.03816, 37.965], [-122.03816, 37.96496], [-122.03837, 37.96482], [-122.03852, 37.96467], [-122.03862, 37.9645], [-122.0387, 37.96422], [-122.03877, 37.96408], [-122.03887, 37.96394], [-122.039, 37.96383], [-122.03921, 37.96401], [-122.04137, 37.96256], [-122.04156, 37.96284]]]} | Open Access 1 | Meadow Homes Park | 22072 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 7.702 | Meadow Homes Park | ||
6694 | 6694 | 6693 | {"type": "Polygon", "coordinates": [[[-122.00772, 37.96146], [-122.00602, 37.96186], [-122.00616, 37.96268], [-122.0044, 37.96289], [-122.00424, 37.96211], [-122.00411, 37.96209], [-122.00429, 37.96314], [-122.0027, 37.9627], [-122.00307, 37.96204], [-122.00233, 37.96198], [-122.0034, 37.96113], [-122.00375, 37.96132], [-122.00441, 37.96154], [-122.00459, 37.96152], [-122.0048, 37.96143], [-122.00488, 37.96147], [-122.00471, 37.96167], [-122.00471, 37.96169], [-122.00528, 37.96161], [-122.00536, 37.96166], [-122.00544, 37.96166], [-122.00552, 37.96162], [-122.00554, 37.96153], [-122.00557, 37.96149], [-122.00588, 37.96164], [-122.00602, 37.96148], [-122.00606, 37.96148], [-122.0069, 37.96049], [-122.00714, 37.9607], [-122.00725, 37.96082], [-122.00772, 37.96146]]]} | Open Access 1 | Markham Nature Park | 21873 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 13.553 | Markham Nature Park | ||
6101 | 6101 | 6100 | {"type": "Polygon", "coordinates": [[[-122.05177, 37.94056], [-122.05138, 37.94277], [-122.05069, 37.94269], [-122.05106, 37.94041], [-122.05165, 37.94042], [-122.05164, 37.94055], [-122.05177, 37.94056]]]} | Open Access 1 | Len Hester Community Park | 21161 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 3.966 | Len Hester Community Park | ||
5784 | 5784 | 5783 | {"type": "Polygon", "coordinates": [[[-122.02943, 37.96792], [-122.02914, 37.96856], [-122.02736, 37.96808], [-122.02717, 37.96843], [-122.02586, 37.96806], [-122.02578, 37.96822], [-122.02543, 37.96811], [-122.02545, 37.96798], [-122.02509, 37.96787], [-122.02557, 37.96682], [-122.02602, 37.96697], [-122.02634, 37.96703], [-122.02943, 37.96792]]]} | Open Access 1 | Krueger Play Fields | 20726 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 9.193 | Krueger Play Fields | ||
5371 | 5371 | 5370 | {"type": "Polygon", "coordinates": [[[-122.05286, 37.99505], [-122.05278, 37.99508], [-122.05232, 37.99461], [-122.0525, 37.99451], [-122.05286, 37.99505]]]} | Open Access 1 | Iron Horse Park | 20234 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 0.22 | Iron Horse Park | ||
5152 | 5152 | 5151 | {"type": "Polygon", "coordinates": [[[-122.04817, 37.99731], [-122.04801, 37.9984], [-122.04768, 37.99848], [-122.04746, 37.9985], [-122.04723, 37.99848], [-122.043, 37.99784], [-122.0428, 37.9978], [-122.04243, 37.99767], [-122.04226, 37.99757], [-122.04223, 37.99751], [-122.04249, 37.99665], [-122.04246, 37.99627], [-122.04422, 37.9966], [-122.04444, 37.99633], [-122.0447, 37.99554], [-122.0451, 37.99563], [-122.04584, 37.99596], [-122.04786, 37.99682], [-122.04521, 37.99613], [-122.04505, 37.99652], [-122.04783, 37.99725], [-122.04817, 37.99731]]]} | Open Access 1 | Hillcrest Community Park | 19965 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 22.97 | Hillcrest Community Park | ||
4932 | 4932 | 4931 | {"type": "Polygon", "coordinates": [[[-121.95868, 37.94342], [-121.95855, 37.94356], [-121.95849, 37.94365], [-121.95821, 37.94415], [-121.95553, 37.94318], [-121.95594, 37.94246], [-121.95868, 37.94342]]]} | Open Access 1 | Highlands Neighborhood Park | 19941 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 5.733 | Highlands Neighborhood Park | ||
3961 | 3961 | 3960 | {"type": "Polygon", "coordinates": [[[-122.03877, 37.97179], [-122.03791, 37.97219], [-122.03832, 37.97276], [-122.03765, 37.97301], [-122.03649, 37.97161], [-122.03544, 37.97045], [-122.03573, 37.97031], [-122.03609, 37.9707], [-122.03617, 37.97065], [-122.03661, 37.97047], [-122.03693, 37.97087], [-122.0378, 37.97047], [-122.03877, 37.97179]]]} | Open Access 1 | Ellis Lake Park | 18592 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 9.405 | Ellis Lake Park | ||
3890 | 3890 | 3889 | {"type": "Polygon", "coordinates": [[[-121.99146, 37.97453], [-121.99058, 37.97532], [-121.99037, 37.97521], [-121.98999, 37.97556], [-121.98999, 37.97558], [-121.99037, 37.97587], [-121.98946, 37.97664], [-121.9878, 37.97615], [-121.9878, 37.97611], [-121.98775, 37.97606], [-121.98775, 37.97602], [-121.98778, 37.97599], [-121.98847, 37.97539], [-121.98856, 37.97527], [-121.98861, 37.97514], [-121.99058, 37.97349], [-121.99064, 37.97351], [-121.99041, 37.97374], [-121.99146, 37.97453]]]} | Open Access 1 | El Dorado Fields | 18499 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 11.725 | El Dorado Fields | ||
3139 | 3139 | 3138 | {"type": "Polygon", "coordinates": [[[-122.03097, 37.96818], [-122.0305, 37.96804], [-122.0304, 37.96765], [-122.03042, 37.96763], [-122.03041, 37.96759], [-122.03061, 37.96755], [-122.03072, 37.96749], [-122.03085, 37.96758], [-122.0309, 37.96779], [-122.03088, 37.96778], [-122.03087, 37.9678], [-122.03097, 37.96818]]]} | Open Access 1 | Concord Skate Park | 17576 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 0.597 | Concord Skate Park | ||
3138 | 3138 | 3137 | {"type": "Polygon", "coordinates": [[[-122.01628, 37.96415], [-122.01473, 37.96759], [-122.0115, 37.96667], [-122.01305, 37.96324], [-122.01628, 37.96415]]]} | Open Access 1 | Concord Community Park | 17575 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 30.16 | Concord Community 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]);