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_TYP = 2 sorted by rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
13207 | 13207 | 13206 | {"type": "Polygon", "coordinates": [[[-121.69024, 37.95121], [-121.69023, 37.95177], [-121.69021, 37.95181], [-121.69016, 37.95182], [-121.6894, 37.95182], [-121.68941, 37.95131], [-121.68938, 37.95125], [-121.68945, 37.95122], [-121.6895, 37.95117], [-121.68955, 37.95121], [-121.69024, 37.95121]]]} | Open Access 1 | Daytona Park | 32129 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.222 | Daytona 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 | ||
13205 | 13205 | 13204 | {"type": "Polygon", "coordinates": [[[-121.68551, 37.94267], [-121.68464, 37.94266], [-121.68454, 37.94269], [-121.68446, 37.94275], [-121.68445, 37.942], [-121.68453, 37.94206], [-121.68463, 37.94208], [-121.68551, 37.94206], [-121.68551, 37.94267]]]} | Open Access 1 | Mallard Park | 32126 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.527 | Mallard Park | ||
13204 | 13204 | 13203 | {"type": "Polygon", "coordinates": [[[-121.68994, 37.94182], [-121.68992, 37.94186], [-121.68987, 37.94187], [-121.68889, 37.94188], [-121.68888, 37.94128], [-121.68987, 37.94127], [-121.68992, 37.94128], [-121.68994, 37.94132], [-121.68994, 37.94182]]]} | Open Access 1 | Egret Park | 32125 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.538 | Egret Park | ||
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 | ||
13202 | 13202 | 13201 | {"type": "Polygon", "coordinates": [[[-121.68684, 37.93578], [-121.68654, 37.93578], [-121.68655, 37.9355], [-121.68663, 37.93552], [-121.68674, 37.93557], [-121.68678, 37.93562], [-121.68684, 37.93578]]]} | Open Access 1 | Crocket Pocket Park | 32122 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.147 | Crocket PP | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);