superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where ACCESS_TYP = 1 and MNG_AGENCY = 348 sorted by ACRES descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12563 | 12563 | 12562 | {"type": "Polygon", "coordinates": [[[-121.68727, 37.95453], [-121.68722, 37.958], [-121.68594, 37.95802], [-121.68585, 37.95799], [-121.68575, 37.95789], [-121.6857, 37.95786], [-121.68568, 37.95807], [-121.68225, 37.95812], [-121.6823, 37.95455], [-121.68573, 37.95452], [-121.68575, 37.95455], [-121.68727, 37.95453]]]} | Open Access 1 | Sunset Park Athletic Complex | 32444 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 42.256 | Sunset Park Athletic Complex | ||
10803 | 10803 | 10802 | {"type": "Polygon", "coordinates": [[[-121.70958, 37.92667], [-121.70943, 37.92742], [-121.70767, 37.92741], [-121.70765, 37.92742], [-121.70622, 37.92743], [-121.70621, 37.92742], [-121.70653, 37.92713], [-121.70686, 37.92711], [-121.70703, 37.92706], [-121.70715, 37.92701], [-121.70724, 37.927], [-121.70725, 37.92699], [-121.7072, 37.92693], [-121.70717, 37.92697], [-121.70703, 37.92703], [-121.70685, 37.92709], [-121.70652, 37.92711], [-121.70618, 37.92741], [-121.70575, 37.9271], [-121.7054, 37.92676], [-121.70524, 37.92649], [-121.7051, 37.92615], [-121.70504, 37.92587], [-121.70503, 37.92565], [-121.70515, 37.92561], [-121.70876, 37.9256], [-121.70878, 37.92589], [-121.70958, 37.92667]], [[-121.70697, 37.92638], [-121.70699, 37.92637], [-121.70694, 37.9263], [-121.70691, 37.92631], [-121.70697, 37.92638]], [[-121.70698, 37.9266], [-121.70697, 37.92659], [-121.70695, 37.9266], [-121.70696, 37.92662], [-121.70698, 37.9266]], [[-121.70703, 37.92655], [-121.70702, 37.92654], [-121.70701, 37.92656], [-121.70702, 37.92656], [-121.70703, 37.92655]], [[-121.70734, 37.92716], [-121.70735, 37.92715], [-121.70732, 37.92712], [-121.70731, 37.92714], [-121.70734, 37.92716]], [[-121.70765, 37.92738], [-121.70766, 37.92738], [-121.70766, 37.92736], [-121.70764, 37.92736], [-121.70765, 37.92738]]]} | Open Access 1 | Veteran's Park | http://gis.brentwoodca.gov/parksfinder/ | 27016 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 16.859 | Veteran's Park | |
704 | 704 | 703 | {"type": "Polygon", "coordinates": [[[-121.72415, 37.91698], [-121.72365, 37.91747], [-121.7235, 37.91767], [-121.7234, 37.91777], [-121.72327, 37.91786], [-121.72308, 37.91794], [-121.72297, 37.91789], [-121.723, 37.91701], [-121.72295, 37.91576], [-121.72267, 37.91307], [-121.72262, 37.91281], [-121.72256, 37.9126], [-121.72222, 37.91184], [-121.72214, 37.91162], [-121.72206, 37.91131], [-121.72207, 37.91124], [-121.72237, 37.91122], [-121.7229, 37.91125], [-121.72292, 37.91138], [-121.7229, 37.91172], [-121.72297, 37.91196], [-121.72309, 37.91216], [-121.72331, 37.91239], [-121.72353, 37.91275], [-121.72409, 37.9139], [-121.7241, 37.91405], [-121.72403, 37.9143], [-121.72336, 37.91543], [-121.7233, 37.9156], [-121.72328, 37.91577], [-121.72329, 37.9159], [-121.72333, 37.91603], [-121.72344, 37.91635], [-121.72354, 37.91652], [-121.72362, 37.91661], [-121.72375, 37.91673], [-121.72415, 37.91698]]]} | Open Access 1 | Summerset Commons Park | 32136 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 13.071 | Summerset Commons Park | ||
5082 | 5082 | 5081 | {"type": "Polygon", "coordinates": [[[-121.68708, 37.93859], [-121.68708, 37.93885], [-121.687, 37.9389], [-121.687, 37.9391], [-121.68708, 37.93909], [-121.68708, 37.93924], [-121.687, 37.93929], [-121.687, 37.93949], [-121.68708, 37.93948], [-121.68708, 37.9398], [-121.68705, 37.93986], [-121.68697, 37.93989], [-121.68496, 37.9399], [-121.68473, 37.93992], [-121.68441, 37.93996], [-121.68393, 37.93997], [-121.68394, 37.93831], [-121.6842, 37.93831], [-121.68421, 37.93859], [-121.68669, 37.93859], [-121.68689, 37.93859], [-121.68689, 37.93832], [-121.68694, 37.93832], [-121.68702, 37.93834], [-121.68702, 37.93858], [-121.68708, 37.93859]]]} | Open Access 1 | Heron Park | 19878 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 10.188 | Heron Park | ||
7569 | 7569 | 7568 | {"type": "Polygon", "coordinates": [[[-121.74099, 37.92084], [-121.74088, 37.92104], [-121.73758, 37.92103], [-121.73758, 37.92009], [-121.73789, 37.92015], [-121.7388, 37.91986], [-121.73899, 37.91952], [-121.73934, 37.91955], [-121.73955, 37.91953], [-121.73976, 37.91948], [-121.73999, 37.91936], [-121.74004, 37.91935], [-121.7403, 37.91955], [-121.74008, 37.91976], [-121.74047, 37.92002], [-121.74069, 37.92022], [-121.74085, 37.92045], [-121.74099, 37.92069], [-121.74099, 37.92084]]]} | Open Access 1 | Oak Meadow Park | 22987 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 9.683 | Oak Meadow Park | ||
10059 | 10059 | 10058 | {"type": "Polygon", "coordinates": [[[-121.71757, 37.93894], [-121.71719, 37.9393], [-121.71718, 37.93998], [-121.71723, 37.94015], [-121.71721, 37.94019], [-121.71703, 37.94018], [-121.71584, 37.93936], [-121.71585, 37.93876], [-121.71616, 37.93875], [-121.7162, 37.93712], [-121.71667, 37.93707], [-121.7167, 37.93662], [-121.71649, 37.93661], [-121.71647, 37.93649], [-121.71711, 37.93655], [-121.71714, 37.93833], [-121.71757, 37.93894]]]} | Open Access 1 | Summerwood Park | 25963 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 8.376 | Summerwood Park | ||
7082 | 7082 | 7081 | {"type": "Polygon", "coordinates": [[[-121.72032, 37.95387], [-121.72018, 37.95386], [-121.71935, 37.95216], [-121.71878, 37.95215], [-121.71868, 37.95125], [-121.71883, 37.9506], [-121.7191, 37.95044], [-121.71918, 37.95013], [-121.71908, 37.94982], [-121.71878, 37.94918], [-121.71903, 37.9487], [-121.71921, 37.9488], [-121.71925, 37.94937], [-121.71934, 37.94948], [-121.7194, 37.94964], [-121.7196, 37.94968], [-121.7196, 37.94986], [-121.71979, 37.94989], [-121.71995, 37.95087], [-121.71995, 37.95309], [-121.72015, 37.95329], [-121.72032, 37.95387]]]} | Open Access 1 | Miwok Park and Trail | 22332 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 8.099 | Miwok Park and Trail | ||
6319 | 6319 | 6318 | {"type": "Polygon", "coordinates": [[[-121.73692, 37.94085], [-121.73677, 37.94122], [-121.73616, 37.94185], [-121.73409, 37.94184], [-121.73387, 37.94158], [-121.73356, 37.94143], [-121.7337, 37.94082], [-121.73646, 37.94077], [-121.73648, 37.94084], [-121.73692, 37.94085]]]} | Open Access 1 | Loma Vista Park | 21410 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 7.251 | Loma Vista Park | ||
2615 | 2615 | 2614 | {"type": "Polygon", "coordinates": [[[-121.71465, 37.92218], [-121.71415, 37.9226], [-121.714, 37.92308], [-121.71255, 37.92315], [-121.71247, 37.9229], [-121.71262, 37.92219], [-121.71315, 37.92159], [-121.71359, 37.92124], [-121.71414, 37.92094], [-121.71421, 37.92151], [-121.71441, 37.92186], [-121.71465, 37.92218]]]} | Open Access 1 | Creekside Park | 17771 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 6.922 | Creekside Park | ||
13214 | 13214 | 13213 | {"type": "Polygon", "coordinates": [[[-121.71713, 37.90384], [-121.71711, 37.90397], [-121.71694, 37.90428], [-121.71665, 37.90416], [-121.71633, 37.90462], [-121.71622, 37.90488], [-121.71619, 37.90507], [-121.71619, 37.90528], [-121.71643, 37.90632], [-121.71645, 37.90648], [-121.71643, 37.90664], [-121.71638, 37.90683], [-121.71629, 37.90701], [-121.71618, 37.90715], [-121.71593, 37.90741], [-121.71582, 37.90761], [-121.71578, 37.90774], [-121.71576, 37.90785], [-121.71576, 37.90855], [-121.71555, 37.90902], [-121.71539, 37.90919], [-121.71532, 37.90932], [-121.71529, 37.90942], [-121.71528, 37.90968], [-121.71538, 37.9101], [-121.71538, 37.91036], [-121.71549, 37.91042], [-121.71546, 37.91049], [-121.7154, 37.91049], [-121.71539, 37.91051], [-121.71544, 37.9106], [-121.71554, 37.91065], [-121.71554, 37.91091], [-121.71511, 37.91091], [-121.71509, 37.91064], [-121.7149, 37.90999], [-121.7149, 37.90984], [-121.71491, 37.90969], [-121.71496, 37.90955], [-121.71532, 37.90868], [-121.71537, 37.90849], [-121.71541, 37.90822], [-121.7154, 37.90772], [-121.71544, 37.90754], [-121.71555, 37.90735], [-121.71588, 37.907], [-121.71597, 37.90689], [-121.71605, 37.90674], [-121.71609, 37.90658], [-121.71609, 37.90645], [-121.71608, 37.90634], [-121.71584, 37.90532], [-121.71584, 37.90506], [-121.71589, 37.90481], [-121.71595, 37.90463], [-121.71604, 37.90446], [-121.71651, 37.90379], [-121.7171, 37.90379], [-121.71713, 37.90384]]]} | Open Access 1 | Marsh Creek Trailhead Park | 32140 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 6.784 | Marsh Creek Trailhead Park | ||
4500 | 4500 | 4499 | {"type": "Polygon", "coordinates": [[[-121.6885, 37.93079], [-121.68764, 37.93079], [-121.68768, 37.92743], [-121.68846, 37.92741], [-121.68847, 37.92742], [-121.6885, 37.93079]]]} | Open Access 1 | Garin Park | 19219 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 6.719 | Garin Park | ||
399 | 399 | 398 | {"type": "MultiPolygon", "coordinates": [[[[-121.74781, 37.93934], [-121.74693, 37.93984], [-121.74693, 37.9397], [-121.74681, 37.93944], [-121.74647, 37.93923], [-121.74662, 37.93903], [-121.74649, 37.93872], [-121.74644, 37.93871], [-121.74645, 37.93864], [-121.74641, 37.93858], [-121.74645, 37.93844], [-121.74635, 37.93823], [-121.74569, 37.93842], [-121.74512, 37.93853], [-121.74512, 37.93852], [-121.74516, 37.93848], [-121.74572, 37.93837], [-121.74615, 37.93825], [-121.74648, 37.93812], [-121.74682, 37.93797], [-121.74701, 37.9382], [-121.74707, 37.9383], [-121.74708, 37.93865], [-121.74743, 37.93872], [-121.74743, 37.93883], [-121.74736, 37.93893], [-121.74738, 37.93902], [-121.74744, 37.93907], [-121.74753, 37.93909], [-121.74757, 37.93919], [-121.74781, 37.93934]]], [[[-121.74657, 37.93787], [-121.74655, 37.93791], [-121.74606, 37.9381], [-121.74596, 37.93812], [-121.74591, 37.9381], [-121.74578, 37.93783], [-121.74538, 37.93731], [-121.74532, 37.93722], [-121.74527, 37.93704], [-121.74527, 37.93687], [-121.7453, 37.93678], [-121.74528, 37.93671], [-121.74539, 37.93662], [-121.74539, 37.93635], [-121.74625, 37.93634], [-121.7461, 37.93645], [-121.74602, 37.93646], [-121.74595, 37.93649], [-121.74591, 37.93655], [-121.7459, 37.93661], [-121.74594, 37.93667], [-121.74603, 37.93673], [-121.74605, 37.93676], [-121.74611, 37.93708], [-121.74622, 37.93737], [-121.74634, 37.93756], [-121.74656, 37.93783], [-121.74657, 37.93787]]]]} | Open Access 1 | Black Gold Park | 32010 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 6.247 | Black Gold Park | ||
1282 | 1282 | 1281 | {"type": "Polygon", "coordinates": [[[-121.75553, 37.92537], [-121.75551, 37.92742], [-121.75551, 37.92742], [-121.75396, 37.92632], [-121.75395, 37.92535], [-121.75553, 37.92537]]]} | Open Access 1 | Balfour Guthrie Park | 15783 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 5.689 | Balfour Guthrie Park | 2002 | |
11006 | 11006 | 11005 | {"type": "Polygon", "coordinates": [[[-121.69387, 37.92234], [-121.69316, 37.92234], [-121.69306, 37.92255], [-121.6929, 37.92262], [-121.69292, 37.92275], [-121.69279, 37.92277], [-121.69283, 37.92286], [-121.69282, 37.92307], [-121.69228, 37.92319], [-121.69153, 37.92233], [-121.69354, 37.92131], [-121.69381, 37.9216], [-121.69388, 37.92184], [-121.69387, 37.92234]]]} | Open Access 1 | Walnut Park | 27238 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 5.19 | Walnut Park | ||
7738 | 7738 | 7737 | {"type": "Polygon", "coordinates": [[[-121.70481, 37.91848], [-121.7048, 37.91967], [-121.70475, 37.9197], [-121.70317, 37.9197], [-121.70313, 37.91968], [-121.70311, 37.91965], [-121.70311, 37.91848], [-121.70312, 37.91845], [-121.70317, 37.91843], [-121.70474, 37.91843], [-121.70478, 37.91844], [-121.70481, 37.91848]]]} | Open Access 1 | Orchard Park | 23189 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 5.171 | Orchard Park | ||
1520 | 1520 | 1519 | {"type": "Polygon", "coordinates": [[[-121.7324, 37.92885], [-121.73174, 37.92982], [-121.73166, 37.92985], [-121.72989, 37.92896], [-121.73018, 37.92863], [-121.73051, 37.92855], [-121.73172, 37.92869], [-121.73214, 37.92876], [-121.7324, 37.92885]]]} | Open Access 1 | Apple Hill Park | 15539 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 4.417 | Apple Hill Park | ||
13186 | 13186 | 13185 | {"type": "Polygon", "coordinates": [[[-121.70874, 37.95011], [-121.70776, 37.9515], [-121.70707, 37.95073], [-121.70736, 37.95001], [-121.70749, 37.94978], [-121.70758, 37.94967], [-121.70762, 37.94964], [-121.70771, 37.94965], [-121.70874, 37.95011]]]} | Open Access 1 | Blue Goose Park | 32090 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 4.006 | Blue Goose Park | ||
5740 | 5740 | 5739 | {"type": "Polygon", "coordinates": [[[-121.72108, 37.94512], [-121.72097, 37.94543], [-121.72086, 37.94556], [-121.7208, 37.9457], [-121.72078, 37.9459], [-121.72077, 37.94628], [-121.72073, 37.94643], [-121.72069, 37.94645], [-121.72067, 37.94649], [-121.72069, 37.94652], [-121.72068, 37.94658], [-121.71946, 37.94658], [-121.71946, 37.94628], [-121.71953, 37.94627], [-121.71959, 37.94624], [-121.71962, 37.9462], [-121.71964, 37.94614], [-121.71963, 37.94545], [-121.71958, 37.94537], [-121.71953, 37.94534], [-121.71946, 37.94533], [-121.71946, 37.94531], [-121.71996, 37.94531], [-121.72028, 37.94528], [-121.72066, 37.94522], [-121.72108, 37.94512]]]} | Open Access 1 | King Park | 20656 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 3.946 | King Park | ||
8939 | 8939 | 8938 | {"type": "Polygon", "coordinates": [[[-121.72264, 37.9652], [-121.72261, 37.96561], [-121.7224, 37.96585], [-121.72214, 37.96593], [-121.72184, 37.96594], [-121.72155, 37.96582], [-121.7209, 37.96515], [-121.72205, 37.96446], [-121.72239, 37.96483], [-121.72264, 37.9652]]]} | Open Access 1 | Rose Garden Park | 24608 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 3.817 | Rose Garden Park | ||
1123 | 1123 | 1122 | {"type": "Polygon", "coordinates": [[[-121.70945, 37.96877], [-121.70815, 37.96876], [-121.70815, 37.96843], [-121.70838, 37.96842], [-121.70841, 37.96828], [-121.70833, 37.96818], [-121.70835, 37.96722], [-121.7093, 37.96723], [-121.7093, 37.96817], [-121.70919, 37.96828], [-121.70922, 37.96839], [-121.70941, 37.96844], [-121.70945, 37.96877]]]} | Open Access 1 | Arbor View Park - North | 15560 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 3.751 | Arbor View Park - North |
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]);