superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where MNG_AGENCY = 348 sorted by PARK_NAME 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11426 | 11426 | 11425 | {"type": "Polygon", "coordinates": [[[-121.72839, 37.95212], [-121.72745, 37.9521], [-121.72746, 37.95152], [-121.72839, 37.9515], [-121.72839, 37.95212]]]} | Open Access 1 | Yokut Park | 27773 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.362 | Yokut Park | ||
448 | 448 | 447 | {"type": "Polygon", "coordinates": [[[-121.69153, 37.94118], [-121.69124, 37.94131], [-121.69115, 37.94124], [-121.69108, 37.94124], [-121.69101, 37.94125], [-121.69085, 37.94096], [-121.69115, 37.94096], [-121.69136, 37.94101], [-121.69153, 37.94118]]]} | Open Access 1 | Windsor Park | 32048 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.349 | Windsor Park | ||
483 | 483 | 482 | {"type": "Polygon", "coordinates": [[[-121.718, 37.95923], [-121.71694, 37.95922], [-121.71692, 37.95889], [-121.71693, 37.95864], [-121.71698, 37.95861], [-121.71732, 37.95861], [-121.71748, 37.95864], [-121.71769, 37.95873], [-121.71781, 37.95881], [-121.71793, 37.95897], [-121.71798, 37.95909], [-121.718, 37.95923]]]} | Open Access 1 | Wheatfield Pocket Park | 32082 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.328 | Wheatfield PP | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
540 | 540 | 539 | {"type": "Polygon", "coordinates": [[[-121.72041, 37.93322], [-121.72041, 37.93341], [-121.72006, 37.93341], [-121.72011, 37.93326], [-121.72014, 37.93323], [-121.72041, 37.93322]]]} | Open Access 1 | Stonehaven Park | 32114 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.141 | Stonehaven Park | ||
478 | 478 | 477 | {"type": "Polygon", "coordinates": [[[-121.71487, 37.96473], [-121.71469, 37.96499], [-121.71459, 37.96524], [-121.71411, 37.96524], [-121.71413, 37.96451], [-121.71416, 37.96449], [-121.7144, 37.96449], [-121.71463, 37.96446], [-121.71475, 37.96461], [-121.71486, 37.96469], [-121.71487, 37.96473]]]} | Open Access 1 | Steeplechase Park | 32061 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.12 | Steeplechase Park | ||
9857 | 9857 | 9856 | {"type": "Polygon", "coordinates": [[[-121.69418, 37.91989], [-121.69378, 37.92012], [-121.69347, 37.91978], [-121.69389, 37.91954], [-121.69418, 37.91989]]]} | Open Access 1 | Spirit Park | 25725 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.522 | Spirit Park | ||
13135 | 13135 | 13134 | {"type": "Polygon", "coordinates": [[[-121.71331, 37.95542], [-121.7133, 37.95605], [-121.71238, 37.95604], [-121.71238, 37.95541], [-121.71331, 37.95542]]]} | Open Access 1 | Seedling Pocket Park | 32083 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.405 | Seedling PP | ||
13203 | 13203 | 13202 | {"type": "Polygon", "coordinates": [[[-121.6856, 37.93691], [-121.6856, 37.93746], [-121.68543, 37.93746], [-121.68543, 37.93691], [-121.6856, 37.93691]]]} | Open Access 1 | Sawyer Pocket Park | 32123 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.225 | Sawyer PP | ||
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 | ||
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 | ||
8914 | 8914 | 8913 | {"type": "Polygon", "coordinates": [[[-121.75463, 37.93253], [-121.75397, 37.93253], [-121.75318, 37.93094], [-121.75369, 37.93096], [-121.75381, 37.93109], [-121.75385, 37.93149], [-121.75395, 37.93166], [-121.7541, 37.93184], [-121.75449, 37.93215], [-121.75463, 37.93253]]]} | Open Access 1 | Rolling Hills Park | 24577 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 2.082 | Rolling Hills Park | 2002 | |
536 | 536 | 535 | {"type": "Polygon", "coordinates": [[[-121.68502, 37.93332], [-121.68478, 37.93333], [-121.68477, 37.93286], [-121.68501, 37.93286], [-121.68502, 37.93332]]]} | Open Access 1 | Rice Pocket Park | 32117 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.271 | Rice PP | ||
8475 | 8475 | 8474 | {"type": "Polygon", "coordinates": [[[-121.72449, 37.96555], [-121.72407, 37.9658], [-121.7237, 37.96535], [-121.72408, 37.96507], [-121.72449, 37.96555]]]} | Open Access 1 | Rainbows End Park | 24093 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.71 | Rainbows End Park | ||
13174 | 13174 | 13173 | {"type": "Polygon", "coordinates": [[[-121.7172, 37.96308], [-121.71719, 37.96372], [-121.71649, 37.96372], [-121.71651, 37.96308], [-121.7172, 37.96308]]]} | Open Access 1 | Pistachio Park | 32056 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.074 | Pistachio Park | ||
13206 | 13206 | 13205 | {"type": "Polygon", "coordinates": [[[-121.68867, 37.94427], [-121.68866, 37.94482], [-121.68793, 37.94481], [-121.68787, 37.94478], [-121.68787, 37.94432], [-121.6879, 37.94427], [-121.68794, 37.94426], [-121.68867, 37.94427]]]} | Open Access 1 | Pelican Park | 32127 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.051 | Pelican 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]);