superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where MNG_AGENCY = 348 and MNG_AG_LEV = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
625 | 625 | 624 | {"type": "Polygon", "coordinates": [[[-121.73817, 37.92637], [-121.737, 37.92675], [-121.73669, 37.92711], [-121.73655, 37.92748], [-121.73652, 37.92788], [-121.73674, 37.92832], [-121.73685, 37.92845], [-121.73682, 37.9285], [-121.73652, 37.92854], [-121.73641, 37.92799], [-121.7364, 37.92779], [-121.73641, 37.92759], [-121.7365, 37.9273], [-121.73675, 37.9268], [-121.73678, 37.92658], [-121.73687, 37.92662], [-121.73804, 37.92622], [-121.73817, 37.92637]]]} | Open Access 1 | Cortona Trailhead | 32108 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.301 | Cortona Trailhead | ||
627 | 627 | 626 | {"type": "Polygon", "coordinates": [[[-121.72094, 37.92872], [-121.7209, 37.92878], [-121.72062, 37.92883], [-121.72056, 37.92863], [-121.71954, 37.92735], [-121.71988, 37.92718], [-121.71997, 37.92722], [-121.72007, 37.92724], [-121.72052, 37.92724], [-121.72059, 37.92728], [-121.72061, 37.92733], [-121.72057, 37.928], [-121.72058, 37.92857], [-121.72061, 37.92864], [-121.72068, 37.92868], [-121.72074, 37.9287], [-121.72094, 37.9287], [-121.72094, 37.92872]]]} | Open Access 1 | Sage Glen Park | 32110 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 2.004 | Sage Glen Park | ||
630 | 630 | 629 | {"type": "Polygon", "coordinates": [[[-121.73673, 37.92927], [-121.73653, 37.92935], [-121.73643, 37.92901], [-121.7365, 37.92903], [-121.7366, 37.92915], [-121.73673, 37.92927]]]} | Open Access 1 | Carrara Pocket Park | 32107 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.103 | Carrara PP | ||
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 | ||
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 | ||
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 | |
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 | ||
1540 | 1540 | 1539 | {"type": "Polygon", "coordinates": [[[-121.70932, 37.96644], [-121.70921, 37.96649], [-121.70921, 37.96707], [-121.70874, 37.96707], [-121.70874, 37.96654], [-121.70871, 37.96636], [-121.70841, 37.96576], [-121.70822, 37.96554], [-121.70795, 37.96518], [-121.70807, 37.96518], [-121.70823, 37.96552], [-121.70838, 37.96553], [-121.70841, 37.96562], [-121.70847, 37.96567], [-121.70853, 37.96568], [-121.70854, 37.96572], [-121.70902, 37.96573], [-121.70904, 37.96569], [-121.70922, 37.96569], [-121.70922, 37.96629], [-121.70931, 37.96633], [-121.7093, 37.96638], [-121.70932, 37.96644]]]} | Open Access 1 | Arbor View Park - South | 15561 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 2.024 | Arbor View Park - South | ||
2228 | 2228 | 2227 | {"type": "Polygon", "coordinates": [[[-121.69448, 37.93429], [-121.69377, 37.93468], [-121.69355, 37.93441], [-121.69356, 37.93427], [-121.6932, 37.93423], [-121.69287, 37.93382], [-121.69365, 37.93336], [-121.69448, 37.93429]]]} | Open Access 1 | Brentwood Park | 16356 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 2.473 | Brentwood 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 | ||
2734 | 2734 | 2733 | {"type": "Polygon", "coordinates": [[[-121.72658, 37.96705], [-121.72658, 37.96714], [-121.72622, 37.96727], [-121.72597, 37.96732], [-121.7258, 37.96704], [-121.72567, 37.96688], [-121.72552, 37.96677], [-121.72606, 37.96652], [-121.72658, 37.96705]]]} | Open Access 1 | Celeste Park | 17005 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.081 | Celeste 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 | ||
4534 | 4534 | 4533 | {"type": "Polygon", "coordinates": [[[-121.72277, 37.96245], [-121.72218, 37.96276], [-121.72178, 37.96232], [-121.72187, 37.96225], [-121.72195, 37.96226], [-121.72255, 37.96226], [-121.72277, 37.96245]]]} | Open Access 1 | Gemini Park | 19252 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.705 | Gemini Park | ||
4612 | 4612 | 4611 | {"type": "Polygon", "coordinates": [[[-121.69054, 37.92014], [-121.6899, 37.92051], [-121.68948, 37.92005], [-121.69016, 37.91969], [-121.69054, 37.92014]]]} | Open Access 1 | Glory Park | 19349 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.072 | Glory Park | ||
4861 | 4861 | 4860 | {"type": "Polygon", "coordinates": [[[-121.74367, 37.92592], [-121.74365, 37.92608], [-121.74279, 37.92626], [-121.7424, 37.92624], [-121.74238, 37.92541], [-121.74303, 37.92543], [-121.74304, 37.92568], [-121.74367, 37.92592]]]} | Open Access 1 | Lake Park | 20958 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.795 | Lake 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 | ||
5226 | 5226 | 5225 | {"type": "Polygon", "coordinates": [[[-121.69461, 37.95525], [-121.69461, 37.95525], [-121.69322, 37.95527], [-121.69369, 37.95481], [-121.69394, 37.95494], [-121.6946, 37.95493], [-121.69461, 37.95525]]]} | Open Access 1 | Homecoming Park | 20059 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.004 | Homecoming 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 | ||
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 | ||
6796 | 6796 | 6795 | {"type": "Polygon", "coordinates": [[[-121.69897, 37.92733], [-121.69896, 37.92916], [-121.69801, 37.92915], [-121.69802, 37.92899], [-121.69829, 37.92877], [-121.69827, 37.92732], [-121.69897, 37.92733]]]} | Open Access 1 | McClarren Park | 21997 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 3.187 | McClarren 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]);