units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where DES_TP = 2, MNG_AGENCY = 385 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 20 ✖
MNG_AGENCY 1
- Concord, City of · 20 ✖
DES_TP 1
- Local Park · 20 ✖
ACCESS_TYP 1
- Open Access 20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1599 | 1599 | 1598 | {"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.02244, 37.99269], [-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.02207, 37.98863], [-122.02247, 37.98882], [-122.02351, 37.99321]]]]} | Open Access 1 | 13532 | Willow Pass Community Park | 27586 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 40.392 | Willow Pass Community Park | 0 | Local Park 2 | 4 | |
1600 | 1600 | 1599 | {"type": "MultiPolygon", "coordinates": [[[[-122.03172, 37.98378], [-122.02817, 37.98545], [-122.02703, 37.98392], [-122.02735, 37.98377], [-122.0275, 37.9839], [-122.0277, 37.98399], [-122.02785, 37.98403], [-122.028, 37.98403], [-122.02822, 37.984], [-122.03039, 37.98299], [-122.03056, 37.98287], [-122.03064, 37.98277], [-122.03069, 37.98265], [-122.03071, 37.98247], [-122.03068, 37.98234], [-122.03063, 37.98222], [-122.03098, 37.98206], [-122.03172, 37.98378]]], [[[-122.03053, 37.98227], [-122.0306, 37.98246], [-122.0306, 37.98257], [-122.03058, 37.98267], [-122.03052, 37.98276], [-122.03045, 37.98284], [-122.03028, 37.98295], [-122.02818, 37.98392], [-122.02805, 37.98395], [-122.02792, 37.98395], [-122.0278, 37.98393], [-122.02768, 37.98389], [-122.02757, 37.98384], [-122.02744, 37.98372], [-122.03053, 37.98227]]]]} | Open Access 1 | 13534 | Baldwin Park | 15779 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 17.805 | Baldwin Park | 0 | Local Park 2 | 4 | |
1798 | 1798 | 1797 | {"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 | 13547 | Meadow Homes Park | 22072 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 7.701 | Meadow Homes Park | 0 | Local Park 2 | 4 | |
1799 | 1799 | 1798 | {"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 | 13550 | Concord Community Park | 17575 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 30.162 | Concord Community Park | 0 | Local Park 2 | 4 | |
3628 | 3628 | 3627 | {"type": "Polygon", "coordinates": [[[-122.02596, 38.00835], [-122.02592, 38.00855], [-122.02562, 38.00858], [-122.0253, 38.0085], [-122.02441, 38.00795], [-122.02331, 38.00706], [-122.02336, 38.00691], [-122.02353, 38.00654], [-122.02402, 38.00703], [-122.02433, 38.00684], [-122.02477, 38.0073], [-122.02446, 38.00749], [-122.02483, 38.00787], [-122.02532, 38.00815], [-122.02596, 38.00835]]]} | Open Access 1 | 13525 | Bayview Circle Park | 15900 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 3.32 | Bayview Circle Park | 0 | Local Park 2 | 4 | |
3629 | 3629 | 3628 | {"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.00362], [-122.03447, 38.0033], [-122.03476, 38.00343], [-122.03573, 38.00376]]]} | Open Access 1 | 13528 | Sun Terrace Park | 25978 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 2.594 | Sun Terrace Park | 0 | Local Park 2 | 4 | |
3630 | 3630 | 3629 | {"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.04423, 37.9966], [-122.04444, 37.99633], [-122.0447, 37.99554], [-122.0451, 37.99563], [-122.04584, 37.99596], [-122.04786, 37.99682], [-122.0452, 37.99613], [-122.04504, 37.99652], [-122.04783, 37.99725], [-122.04817, 37.99731]]]} | Open Access 1 | 13530 | Hillcrest Community Park | 19965 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 22.958 | Hillcrest Community Park | 0 | Local Park 2 | 4 | |
3631 | 3631 | 3630 | {"type": "Polygon", "coordinates": [[[-121.98729, 37.97617], [-121.98563, 37.97757], [-121.9843, 37.97657], [-121.98544, 37.97561], [-121.98729, 37.97617]]]} | Open Access 1 | 13539 | Concord Boulevard Park | 17574 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 7.136 | Concord Boulevard Park | 0 | Local Park 2 | 4 | |
3632 | 3632 | 3631 | {"type": "Polygon", "coordinates": [[[-122.03877, 37.97179], [-122.0379, 37.9722], [-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.03692, 37.97088], [-122.0378, 37.97047], [-122.03877, 37.97179]]]} | Open Access 1 | 13541 | Ellis Lake Park | 18592 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 9.392 | Ellis Lake Park | 0 | Local Park 2 | 4 | |
8554 | 8554 | 8553 | {"type": "Polygon", "coordinates": [[[-122.00772, 37.96146], [-122.00602, 37.96186], [-122.00616, 37.96268], [-122.0044, 37.96289], [-122.00424, 37.9621], [-122.0041, 37.96209], [-122.00429, 37.96314], [-122.0027, 37.9627], [-122.00308, 37.96203], [-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.0047, 37.96168], [-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.96149], [-122.0069, 37.96049], [-122.00714, 37.9607], [-122.00725, 37.96082], [-122.00772, 37.96146]]]} | Open Access 1 | 13553 | Markham Nature Park | 21873 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 13.525 | Markham Nature Park | 0 | Local Park 2 | 4 | |
8556 | 8556 | 8555 | {"type": "MultiPolygon", "coordinates": [[[[-121.99479, 37.96098], [-121.99442, 37.96146], [-121.99399, 37.96144], [-121.99404, 37.96088], [-121.99396, 37.96089], [-121.99182, 37.96056], [-121.99172, 37.96132], [-121.99205, 37.96149], [-121.99196, 37.96148], [-121.98214, 37.95919], [-121.981, 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.97491, 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.97398, 37.95204], [-121.97428, 37.95189], [-121.9746, 37.9518], [-121.97494, 37.95177], [-121.97583, 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.98082, 37.95592], [-121.98101, 37.95603], [-121.98123, 37.9561], [-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.98351, 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.98764, 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.98864, 37.95953], [-121.98869, 37.95948], [-121.9887, 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 | 13559 | Newhall Community Park | 22724 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 116.896 | Newhall Community Park | 0 | Local Park 2 | 4 | |
8557 | 8557 | 8556 | {"type": "Polygon", "coordinates": [[[-121.97034, 37.96168], [-121.96971, 37.96159], [-121.96914, 37.96141], [-121.96863, 37.96092], [-121.96855, 37.96075], [-121.96845, 37.9607], [-121.96879, 37.96024], [-121.9691, 37.96038], [-121.96943, 37.96035], [-121.96959, 37.9604], [-121.96963, 37.96034], [-121.96978, 37.96044], [-121.97034, 37.96168]]]} | Open Access 1 | 13562 | Brazil Quarry Park | 16338 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 3.647 | Brazil Quarry Park | 0 | Local Park 2 | 4 | |
8558 | 8558 | 8557 | {"type": "Polygon", "coordinates": [[[-122.04915, 37.95255], [-122.04632, 37.95453], [-122.04611, 37.95441], [-122.04588, 37.95449], [-122.04526, 37.95388], [-122.04525, 37.95361], [-122.04629, 37.95288], [-122.04641, 37.95301], [-122.04675, 37.95283], [-122.04771, 37.95221], [-122.04841, 37.95172], [-122.04915, 37.95255]]]} | Open Access 1 | 13565 | Cambridge Park | 16752 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 10.872 | Cambridge Park | 0 | Local Park 2 | 4 | |
8559 | 8559 | 8558 | {"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 | 13567 | Ygnacio Valley Park | 27771 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 9.462 | Ygnacio Valley Park | 0 | Local Park 2 | 4 | |
8560 | 8560 | 8559 | {"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 | 13570 | Highlands Neighborhood Park | 19941 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 5.734 | Highlands Neighborhood Park | 0 | Local Park 2 | 4 | |
8561 | 8561 | 8560 | {"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 | 13573 | Len Hester Community Park | 21161 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 3.966 | Len Hester Community Park | 0 | Local Park 2 | 4 | |
8565 | 8565 | 8564 | {"type": "MultiPolygon", "coordinates": [[[[-122.03055, 37.99544], [-122.03041, 37.99559], [-122.03036, 37.99557], [-122.02781, 37.99913], [-122.02681, 38.00047], [-122.02634, 38.00104], [-122.02613, 38.0013], [-122.02602, 38.00141], [-122.0253, 38.00225], [-122.02512, 38.00215], [-122.02514, 38.0021], [-122.02511, 38.00189], [-122.02521, 38.00185], [-122.02549, 38.00144], [-122.0256, 38.00144], [-122.02568, 38.0014], [-122.02571, 38.00134], [-122.02572, 38.00127], [-122.02585, 38.00107], [-122.02616, 38.0012], [-122.02793, 37.99875], [-122.02793, 37.99874], [-122.02785, 37.9987], [-122.02795, 37.99856], [-122.02805, 37.9986], [-122.03046, 37.9953], [-122.03051, 37.99535], [-122.03055, 37.99544]]], [[[-122.03362, 37.98983], [-122.0335, 37.98983], [-122.03344, 37.9902], [-122.03335, 37.99065], [-122.03324, 37.99102], [-122.03304, 37.99156], [-122.03285, 37.99199], [-122.03273, 37.99221], [-122.03234, 37.99284], [-122.03069, 37.99515], [-122.03063, 37.99518], [-122.03058, 37.99517], [-122.03056, 37.99516], [-122.03207, 37.99308], [-122.03207, 37.99306], [-122.03203, 37.99305], [-122.03212, 37.99293], [-122.03218, 37.99294], [-122.03251, 37.99243], [-122.03271, 37.99207], [-122.03297, 37.99151], [-122.03311, 37.99113], [-122.03323, 37.99074], [-122.03336, 37.99016], [-122.03343, 37.98956], [-122.03351, 37.98956], [-122.03356, 37.98959], [-122.03356, 37.98973], [-122.03359, 37.98974], [-122.03362, 37.98983]]], [[[-122.03365, 37.98925], [-122.03361, 37.9893], [-122.03355, 37.98933], [-122.03344, 37.98934], [-122.03344, 37.98898], [-122.03342, 37.98864], [-122.03336, 37.98813], [-122.03321, 37.98746], [-122.033, 37.9868], [-122.0325, 37.98563], [-122.03255, 37.98561], [-122.03282, 37.98623], [-122.03302, 37.98653], [-122.03329, 37.9873], [-122.03346, 37.98805], [-122.0335, 37.98836], [-122.03354, 37.98891], [-122.03354, 37.98924], [-122.03365, 37.98925]]]]} | Open Access 1 | 13580 | BART Linear Park | 15838 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 5.267 | BART Linear Park | 0 | Local Park 2 | 4 | |
8566 | 8566 | 8565 | {"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 | 13583 | Iron Horse Park | 20234 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 0.22 | Iron Horse Park | 0 | Local Park 2 | 4 | |
8569 | 8569 | 8568 | {"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.95226], [-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 | 13594 | Rick Sears Park | 24345 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 0.595 | Rick Sears Park | 0 | Local Park 2 | 4 | |
8571 | 8571 | 8570 | {"type": "Polygon", "coordinates": [[[-122.0313, 37.96854], [-122.03098, 37.96932], [-122.03075, 37.96994], [-122.03022, 37.97123], [-122.03008, 37.97119], [-122.03003, 37.97114], [-122.03001, 37.97107], [-122.03109, 37.96873], [-122.03115, 37.96854], [-122.0312, 37.9685], [-122.0313, 37.96854]]]} | Open Access 1 | 13600 | BART Park | 15839 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 1.284 | BART 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]);