units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where MNG_AGENCY = 167 and MNG_AG_TYP = 2 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 7
- Local Park 37
- Local Recreation Area 23
- Local Conservation Area 1
- Local Other or Unknown 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 65 ✖
MNG_AGENCY 1
- Davis, City of · 65 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10948 | 10948 | 10947 | {"type": "Polygon", "coordinates": [[[-121.79276, 38.55281], [-121.79186, 38.55291], [-121.7918, 38.55291], [-121.79176, 38.55286], [-121.79166, 38.55227], [-121.79266, 38.55227], [-121.79276, 38.55281]]]} | Open Access 1 | 20986 | Whaleback Park | 27447 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 1.432 | Whaleback Park | 0 | Local Park 2 | 4 | |
3055 | 3055 | 3054 | {"type": "Polygon", "coordinates": [[[-121.78648, 38.54919], [-121.78648, 38.55007], [-121.78525, 38.55004], [-121.78525, 38.54902], [-121.78605, 38.54902], [-121.78606, 38.54919], [-121.78648, 38.54919]]]} | Open Access 1 | 20984 | West Manor Park | 27367 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 2.883 | West Manor Park | 0 | Local Park 2 | 4 | |
15720 | 15720 | 15719 | {"type": "Polygon", "coordinates": [[[-121.78192, 38.58316], [-121.7819, 38.58498], [-121.77782, 38.58494], [-121.77757, 38.58543], [-121.77653, 38.58543], [-121.77641, 38.59019], [-121.77351, 38.59018], [-121.77377, 38.58982], [-121.77414, 38.58934], [-121.77443, 38.58886], [-121.77478, 38.58821], [-121.77493, 38.58764], [-121.77499, 38.58733], [-121.77501, 38.58716], [-121.77501, 38.58649], [-121.77494, 38.5859], [-121.77483, 38.58458], [-121.77476, 38.58417], [-121.7724, 38.58485], [-121.77241, 38.58459], [-121.77222, 38.58458], [-121.77139, 38.58485], [-121.77148, 38.58517], [-121.7713, 38.5857], [-121.77016, 38.58608], [-121.7696, 38.58629], [-121.76877, 38.58668], [-121.769, 38.58699], [-121.76926, 38.58707], [-121.77016, 38.58729], [-121.77066, 38.58738], [-121.77094, 38.58749], [-121.77105, 38.58755], [-121.77148, 38.58782], [-121.77204, 38.58828], [-121.77228, 38.58854], [-121.77233, 38.5887], [-121.77233, 38.58884], [-121.77192, 38.58894], [-121.77101, 38.58876], [-121.76934, 38.58902], [-121.76875, 38.58875], [-121.76853, 38.58862], [-121.76833, 38.58848], [-121.76824, 38.5884], [-121.76808, 38.58823], [-121.76794, 38.58804], [-121.76783, 38.58785], [-121.76772, 38.5876], [-121.7677, 38.58744], [-121.76761, 38.58499], [-121.76762, 38.58292], [-121.76904, 38.58293], [-121.76904, 38.58251], [-121.76765, 38.5825], [-121.76803, 38.57833], [-121.76812, 38.57619], [-121.76813, 38.57567], [-121.77666, 38.57575], [-121.7766, 38.5831], [-121.78192, 38.58316]]]} | Restricted Access 2 | 47226 | Davis Municipal Golf Course | 33121 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 264.528 | Davis Municipal GC | 0 | Local Recreation Area 3 | 4 | |
4098 | 4098 | 4097 | {"type": "Polygon", "coordinates": [[[-121.78125, 38.55388], [-121.78121, 38.55395], [-121.77637, 38.55395], [-121.77637, 38.55388], [-121.78125, 38.55388]]]} | Open Access 1 | 47210 | Arroyo Greenbelt | 30916 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.808 | Arroyo Greenbelt | 0 | Local Recreation Area 3 | 4 | |
10958 | 10958 | 10957 | {"type": "Polygon", "coordinates": [[[-121.77799, 38.55534], [-121.77775, 38.55534], [-121.77774, 38.55503], [-121.77687, 38.55503], [-121.77686, 38.55534], [-121.77574, 38.55534], [-121.77573, 38.55531], [-121.77329, 38.55532], [-121.77308, 38.55532], [-121.77276, 38.55536], [-121.7727, 38.55533], [-121.77255, 38.55504], [-121.77236, 38.55479], [-121.77216, 38.55461], [-121.77188, 38.55442], [-121.77241, 38.55385], [-121.77637, 38.55388], [-121.77637, 38.55495], [-121.77781, 38.55495], [-121.77799, 38.55509], [-121.77799, 38.55534]]]} | Open Access 1 | 21017 | Arroyo Park | 15614 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 15.084 | Arroyo Park | 0 | Local Park 2 | 4 | |
14545 | 14545 | 14544 | {"type": "Polygon", "coordinates": [[[-121.77383, 38.5573], [-121.77383, 38.5575], [-121.77378, 38.55751], [-121.77378, 38.55777], [-121.77381, 38.5578], [-121.77377, 38.55785], [-121.77376, 38.5579], [-121.77378, 38.55798], [-121.77378, 38.55834], [-121.77376, 38.55843], [-121.77378, 38.55849], [-121.77383, 38.55853], [-121.77381, 38.55855], [-121.77381, 38.55887], [-121.77283, 38.55887], [-121.77251, 38.55901], [-121.77232, 38.5588], [-121.77195, 38.55846], [-121.77355, 38.55846], [-121.77355, 38.55826], [-121.77347, 38.55821], [-121.77349, 38.55818], [-121.77349, 38.55809], [-121.77344, 38.55804], [-121.77348, 38.558], [-121.77348, 38.55781], [-121.77352, 38.5578], [-121.77352, 38.55758], [-121.77346, 38.55755], [-121.77347, 38.55744], [-121.77345, 38.5574], [-121.7735, 38.55737], [-121.7735, 38.55689], [-121.77342, 38.55684], [-121.77345, 38.55677], [-121.77343, 38.55668], [-121.77344, 38.55607], [-121.77346, 38.55599], [-121.77343, 38.55592], [-121.77335, 38.55587], [-121.77338, 38.55582], [-121.77336, 38.55558], [-121.77376, 38.55558], [-121.77376, 38.55582], [-121.77378, 38.55584], [-121.77376, 38.55588], [-121.77376, 38.55597], [-121.7738, 38.55602], [-121.77378, 38.55604], [-121.77378, 38.55646], [-121.77381, 38.55649], [-121.77378, 38.55653], [-121.77378, 38.55663], [-121.77381, 38.55667], [-121.77378, 38.55669], [-121.77378, 38.55689], [-121.7738, 38.5569], [-121.7738, 38.55709], [-121.77383, 38.55712], [-121.77381, 38.55715], [-121.7738, 38.55725], [-121.77383, 38.5573]]]} | Open Access 1 | 47214 | Evergreen Greenbelt | 30920 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 3.898 | Evergreen Greenbelt | 0 | Local Recreation Area 3 | 4 | |
10952 | 10952 | 10951 | {"type": "Polygon", "coordinates": [[[-121.77368, 38.55052], [-121.77361, 38.5506], [-121.77359, 38.55067], [-121.77363, 38.55084], [-121.77361, 38.55168], [-121.77198, 38.55166], [-121.77196, 38.55161], [-121.77198, 38.55014], [-121.77364, 38.55016], [-121.77363, 38.55048], [-121.77368, 38.55052]]]} | Open Access 1 | 21020 | Westwood Park | 27440 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 6.003 | Westwood Park | 0 | Local Park 2 | 4 | |
10957 | 10957 | 10956 | {"type": "Polygon", "coordinates": [[[-121.76742, 38.55516], [-121.76738, 38.55617], [-121.76502, 38.55612], [-121.76505, 38.55511], [-121.76742, 38.55516]]]} | Open Access 1 | 21016 | Sycamore Park | 26133 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 5.732 | Sycamore Park | 0 | Local Park 2 | 4 | |
12272 | 12272 | 12271 | {"type": "Polygon", "coordinates": [[[-121.76712, 38.56828], [-121.76373, 38.56824], [-121.7627, 38.56837], [-121.76249, 38.56843], [-121.76224, 38.56857], [-121.76212, 38.56869], [-121.762, 38.56886], [-121.76195, 38.569], [-121.76192, 38.5692], [-121.76188, 38.56934], [-121.76181, 38.56948], [-121.76174, 38.56959], [-121.7616, 38.56974], [-121.7615, 38.56982], [-121.76121, 38.57002], [-121.76112, 38.57012], [-121.76101, 38.57027], [-121.76095, 38.57055], [-121.76092, 38.57094], [-121.76084, 38.57115], [-121.76074, 38.57134], [-121.76052, 38.57157], [-121.76031, 38.57171], [-121.75997, 38.57184], [-121.75982, 38.57187], [-121.7594, 38.57191], [-121.75829, 38.57191], [-121.75817, 38.57561], [-121.74807, 38.57546], [-121.74796, 38.57511], [-121.74857, 38.57513], [-121.74862, 38.5751], [-121.74876, 38.57483], [-121.74876, 38.57478], [-121.74887, 38.57483], [-121.74882, 38.57486], [-121.7487, 38.5751], [-121.74874, 38.57513], [-121.75685, 38.5752], [-121.757, 38.57519], [-121.75716, 38.57516], [-121.75735, 38.57508], [-121.75746, 38.57501], [-121.75744, 38.57494], [-121.75751, 38.5749], [-121.75752, 38.57483], [-121.75764, 38.57483], [-121.75767, 38.5748], [-121.75773, 38.57467], [-121.75776, 38.57454], [-121.75776, 38.57413], [-121.75766, 38.57409], [-121.75766, 38.57401], [-121.75777, 38.57397], [-121.75778, 38.57337], [-121.75775, 38.57334], [-121.75761, 38.57334], [-121.75761, 38.57331], [-121.75775, 38.57331], [-121.75779, 38.57328], [-121.7578, 38.57263], [-121.75771, 38.5726], [-121.75771, 38.57251], [-121.7578, 38.57248], [-121.75781, 38.57176], [-121.7578, 38.5717], [-121.75738, 38.5714], [-121.75753, 38.57137], [-121.7578, 38.57122], [-121.75795, 38.57111], [-121.75799, 38.57105], [-121.75812, 38.57093], [-121.75821, 38.57131], [-121.75832, 38.57148], [-121.75966, 38.57149], [-121.75995, 38.57142], [-121.76018, 38.57129], [-121.76019, 38.57116], [-121.76023, 38.57115], [-121.76027, 38.57112], [-121.76028, 38.57101], [-121.76041, 38.57101], [-121.76046, 38.57087], [-121.76048, 38.57042], [-121.76032, 38.57037], [-121.76032, 38.57029], [-121.76051, 38.57025], [-121.76058, 38.57011], [-121.76066, 38.56997], [-121.76077, 38.56984], [-121.76089, 38.56973], [-121.76089, 38.56964], [-121.76098, 38.56964], [-121.76103, 38.56963], [-121.76106, 38.5696], [-121.76107, 38.56953], [-121.76119, 38.56953], [-121.7613, 38.56941], [-121.76139, 38.56928], [-121.76142, 38.56919], [-121.76148, 38.5689], [-121.76133, 38.56886], [-121.76133, 38.56877], [-121.76155, 38.56873], [-121.76163, 38.5686], [-121.76173, 38.56847], [-121.76184, 38.56836], [-121.762, 38.56824], [-121.76199, 38.56822], [-121.7613, 38.56822], [-121.76131, 38.56779], [-121.76136, 38.56779], [-121.76137, 38.56727], [-121.76131, 38.56718], [-121.76143, 38.56718], [-121.76143, 38.56724], [-121.76149, 38.56724], [-121.76148, 38.56811], [-121.76157, 38.56818], [-121.76209, 38.56818], [-121.76241, 38.56805], [-121.76278, 38.56797], [-121.76288, 38.5679], [-121.76311, 38.56724], [-121.76266, 38.5658], [-121.76247, 38.56572], [-121.76247, 38.56494], [-121.76199, 38.5648], [-121.7616, 38.5648], [-121.76152, 38.56487], [-121.76151, 38.56562], [-121.76133, 38.56564], [-121.76134, 38.56519], [-121.76139, 38.56519], [-121.76139, 38.56475], [-121.76134, 38.56474], [-121.76134, 38.56452], [-121.76152, 38.56452], [-121.76152, 38.56431], [-121.76135, 38.5643], [-121.76135, 38.56364], [-121.76167, 38.56365], [-121.76171, 38.56433], [-121.76189, 38.56457], [-121.76219, 38.56471], [-121.76304, 38.56484], [-121.76317, 38.56479], [-121.76332, 38.56443], [-121.76342, 38.56445], [-121.7633, 38.56488], [-121.7633, 38.56526], [-121.76331, 38.56531], [-121.76336, 38.56535], [-121.76341, 38.56538], [-121.76371, 38.56538], [-121.76411, 38.56547], [-121.7642, 38.56579], [-121.76367, 38.56574], [-121.76337, 38.56578], [-121.7633, 38.56585], [-121.7636, 38.5671], [-121.76363, 38.56713], [-121.76369, 38.56714], [-121.7646, 38.56699], [-121.76465, 38.56709], [-121.76364, 38.56726], [-121.76361, 38.56728], [-121.76359, 38.56731], [-121.76358, 38.56734], [-121.76372, 38.56784], [-121.76374, 38.56786], [-121.76381, 38.56789], [-121.7643, 38.56785], [-121.76479, 38.56789], [-121.76602, 38.56792], [-121.76627, 38.56787], [-121.76661, 38.56773], [-121.76671, 38.56767], [-121.76677, 38.5676], [-121.7669, 38.56772], [-121.76702, 38.5679], [-121.76709, 38.56807], [-121.76712, 38.56828]]]} | Open Access 1 | 25887 | Northstar Perimeter Greenbelt | 30911 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 33.425 | Northstar Perimeter Greenbelt | 0 | Local Recreation Area 3 | 4 | |
10942 | 10942 | 10941 | {"type": "Polygon", "coordinates": [[[-121.76656, 38.5479], [-121.76567, 38.54789], [-121.76516, 38.54781], [-121.76502, 38.54815], [-121.76448, 38.54798], [-121.76444, 38.54796], [-121.76443, 38.54793], [-121.76461, 38.54748], [-121.76465, 38.54747], [-121.76489, 38.54747], [-121.76495, 38.54745], [-121.765, 38.54741], [-121.76503, 38.54735], [-121.76504, 38.54722], [-121.76503, 38.54718], [-121.7657, 38.54695], [-121.7657, 38.54714], [-121.76625, 38.54714], [-121.76652, 38.54765], [-121.76645, 38.54771], [-121.76644, 38.54779], [-121.76646, 38.54782], [-121.76654, 38.54786], [-121.76656, 38.5479]]]} | Open Access 1 | 20974 | Oxford Circle Park | 23280 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 3.34 | Oxford Circle Park | 0 | Local Park 2 | 4 | |
14741 | 14741 | 14740 | {"type": "Polygon", "coordinates": [[[-121.76135, 38.56357], [-121.76135, 38.56364], [-121.76102, 38.56364], [-121.76096, 38.56373], [-121.7609, 38.56372], [-121.76083, 38.56373], [-121.76077, 38.56363], [-121.76045, 38.56363], [-121.76043, 38.56417], [-121.7601, 38.56417], [-121.76004, 38.56426], [-121.75998, 38.56425], [-121.75991, 38.56426], [-121.75985, 38.56417], [-121.75952, 38.56417], [-121.7595, 38.56461], [-121.75855, 38.56462], [-121.75855, 38.56425], [-121.75915, 38.56425], [-121.75925, 38.56421], [-121.7594, 38.5641], [-121.75953, 38.56406], [-121.76017, 38.56407], [-121.76021, 38.56405], [-121.76023, 38.56401], [-121.76024, 38.56333], [-121.76023, 38.5633], [-121.7602, 38.56328], [-121.76021, 38.56327], [-121.76021, 38.56317], [-121.76047, 38.56317], [-121.76047, 38.56356], [-121.76135, 38.56357]]]} | Open Access 1 | 47221 | Seville Greenbelt | 30928 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 1.852 | Seville Greenbelt | 0 | Local Recreation Area 3 | 4 | |
10959 | 10959 | 10958 | {"type": "Polygon", "coordinates": [[[-121.76107, 38.55363], [-121.75876, 38.55359], [-121.75878, 38.55228], [-121.75911, 38.5523], [-121.75908, 38.55291], [-121.75992, 38.55317], [-121.76087, 38.55311], [-121.76107, 38.55363]]]} | Open Access 1 | 21018 | Redwood Park | 24248 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 3.333 | Redwood Park | 0 | Local Park 2 | 4 | |
439 | 439 | 438 | {"type": "Polygon", "coordinates": [[[-121.7605, 38.56573], [-121.7605, 38.56632], [-121.75984, 38.56631], [-121.75985, 38.56573], [-121.7605, 38.56573]]]} | Open Access 1 | 21013 | Hacienda Park | 19586 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.923 | Hacienda Park | 0 | Local Park 2 | 4 | |
10940 | 10940 | 10939 | {"type": "Polygon", "coordinates": [[[-121.75437, 38.57126], [-121.75434, 38.57201], [-121.75417, 38.57211], [-121.75416, 38.57206], [-121.75411, 38.572], [-121.75405, 38.57196], [-121.75397, 38.57194], [-121.75099, 38.57192], [-121.75088, 38.572], [-121.75088, 38.57225], [-121.75078, 38.57229], [-121.75072, 38.57235], [-121.75037, 38.57235], [-121.75027, 38.57243], [-121.75027, 38.57253], [-121.74977, 38.57253], [-121.74938, 38.57259], [-121.74924, 38.57303], [-121.74858, 38.57314], [-121.74857, 38.57315], [-121.74759, 38.5733], [-121.74751, 38.57329], [-121.74751, 38.57327], [-121.74742, 38.57323], [-121.74736, 38.57317], [-121.74733, 38.57311], [-121.74697, 38.57196], [-121.74677, 38.57078], [-121.74671, 38.57055], [-121.74978, 38.56995], [-121.75015, 38.57109], [-121.75437, 38.57126]]]} | Open Access 1 | 20970 | Northstar Park | 22893 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 29.24 | Northstar Park | 0 | Local Park 2 | 4 | |
10891 | 10891 | 10890 | {"type": "Polygon", "coordinates": [[[-121.75127, 38.54762], [-121.75021, 38.54761], [-121.75021, 38.54761], [-121.75024, 38.54751], [-121.75032, 38.54742], [-121.7507, 38.5472], [-121.75085, 38.54718], [-121.75111, 38.54725], [-121.75118, 38.5473], [-121.75124, 38.54744], [-121.75127, 38.54762]]]} | Open Access 1 | 21022 | College Park | 17507 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.816 | College Park | 0 | Local Park 2 | 4 | |
17066 | 17066 | 17065 | {"type": "Polygon", "coordinates": [[[-121.75072, 38.57381], [-121.75068, 38.57385], [-121.75067, 38.57395], [-121.75049, 38.57408], [-121.75035, 38.57409], [-121.75035, 38.57399], [-121.7503, 38.57395], [-121.75016, 38.57394], [-121.75011, 38.57395], [-121.75011, 38.57366], [-121.75016, 38.57367], [-121.75028, 38.57367], [-121.75032, 38.57366], [-121.75035, 38.57362], [-121.75065, 38.57367], [-121.75065, 38.57373], [-121.75072, 38.57381]]]} | Open Access 1 | 20971 | Northstar Pocket Park | 22894 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.474 | Northstar PP | 0 | Local Park 2 | 4 | |
10932 | 10932 | 10931 | {"type": "Polygon", "coordinates": [[[-121.7502, 38.56635], [-121.74882, 38.56689], [-121.74845, 38.56575], [-121.74862, 38.56571], [-121.74873, 38.56563], [-121.7488, 38.56567], [-121.74882, 38.56566], [-121.74864, 38.56511], [-121.74926, 38.56487], [-121.7502, 38.56635]]]} | Open Access 1 | 20957 | Covell Park | 17723 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 4.726 | Covell Park | 0 | Local Park 2 | 4 | |
13770 | 13770 | 13769 | {"type": "Polygon", "coordinates": [[[-121.74826, 38.55606], [-121.74817, 38.56059], [-121.74496, 38.56056], [-121.74498, 38.56001], [-121.74496, 38.55976], [-121.74492, 38.55951], [-121.74484, 38.55926], [-121.74473, 38.55902], [-121.74464, 38.55887], [-121.74379, 38.55764], [-121.74366, 38.55735], [-121.74354, 38.55702], [-121.74445, 38.55683], [-121.74457, 38.55718], [-121.74466, 38.55735], [-121.74535, 38.55842], [-121.74712, 38.55844], [-121.74716, 38.55673], [-121.74702, 38.55631], [-121.74826, 38.55606]]]} | Open Access 1 | 36310 | Community Park | 30904 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://cityofdavis.org/Home/Components/FacilityDirectory/FacilityDirectory/26/2926?npage=2 | Yolo 33 | 26.954 | Community Park | 0 | Local Park 2 | 4 |
16980 | 16980 | 16979 | {"type": "Polygon", "coordinates": [[[-121.74766, 38.54637], [-121.74766, 38.54705], [-121.74714, 38.54705], [-121.74712, 38.54786], [-121.74715, 38.54787], [-121.74714, 38.54863], [-121.74764, 38.54864], [-121.74764, 38.54923], [-121.74653, 38.54925], [-121.74642, 38.54856], [-121.74605, 38.54859], [-121.74588, 38.54762], [-121.74559, 38.54661], [-121.7456, 38.54661], [-121.74561, 38.54647], [-121.74565, 38.54641], [-121.74597, 38.54636], [-121.74766, 38.54637]]]} | Open Access 1 | 21021 | Civic Center Park | 17355 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 9.582 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
5113 | 5113 | 5112 | {"type": "Polygon", "coordinates": [[[-121.74523, 38.54626], [-121.74471, 38.54656], [-121.74447, 38.5466], [-121.7438, 38.54423], [-121.74462, 38.54409], [-121.74523, 38.54626]]]} | Open Access 1 | 21023 | Central Park | 17052 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 4.734 | Central 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]);