superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where MNG_AGENCY = 348
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
12974 | 12974 | 12973 | {"type": "Polygon", "coordinates": [[[-121.71875, 37.96018], [-121.71874, 37.9607], [-121.71874, 37.9607], [-121.71844, 37.96018], [-121.71875, 37.96018]]]} | Open Access 1 | Gann Street Pocket Park | 32080 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.189 | Gann Street PP | ||
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 | ||
13171 | 13171 | 13170 | {"type": "Polygon", "coordinates": [[[-121.73096, 37.96109], [-121.73096, 37.9614], [-121.73047, 37.9614], [-121.73066, 37.9611], [-121.73074, 37.96112], [-121.73086, 37.96109], [-121.73096, 37.96109]]]} | Open Access 1 | Amber Park | 32051 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.281 | Amber Park | ||
13172 | 13172 | 13171 | {"type": "Polygon", "coordinates": [[[-121.72201, 37.96679], [-121.72201, 37.96728], [-121.72153, 37.96728], [-121.72144, 37.96729], [-121.72139, 37.96728], [-121.72136, 37.96725], [-121.72135, 37.96721], [-121.72137, 37.96716], [-121.72138, 37.96697], [-121.72142, 37.96684], [-121.72142, 37.96679], [-121.72146, 37.96675], [-121.72152, 37.96673], [-121.7217, 37.96677], [-121.72201, 37.96679]]]} | Open Access 1 | Anastasia Park | 32052 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.774 | Anastasia Park | ||
13173 | 13173 | 13172 | {"type": "Polygon", "coordinates": [[[-121.71759, 37.96654], [-121.71759, 37.96707], [-121.7171, 37.96707], [-121.71701, 37.96717], [-121.71692, 37.96715], [-121.71683, 37.96717], [-121.71674, 37.96707], [-121.71625, 37.96707], [-121.71625, 37.96654], [-121.71759, 37.96654]]]} | Open Access 1 | Granville Green Park | 32053 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.759 | Granville Green 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 | ||
13184 | 13184 | 13183 | {"type": "Polygon", "coordinates": [[[-121.701, 37.95695], [-121.70039, 37.95695], [-121.70039, 37.95626], [-121.701, 37.95626], [-121.701, 37.95695]]]} | Open Access 1 | Big Basin Park | 32085 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.016 | Big Basin Park | ||
13185 | 13185 | 13184 | {"type": "Polygon", "coordinates": [[[-121.69775, 37.95242], [-121.69746, 37.95249], [-121.69733, 37.95221], [-121.69767, 37.95211], [-121.69775, 37.95242]]]} | Open Access 1 | Marsh Creek Vista Park | 32086 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.245 | Marsh Creek Vista 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]);