superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where MNG_AGENCY = 348 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
618 | 618 | 617 | {"type": "Polygon", "coordinates": [[[-121.72506, 37.94971], [-121.72502, 37.94983], [-121.72487, 37.94983], [-121.72487, 37.94959], [-121.72504, 37.94968], [-121.72506, 37.94971]]]} | Open Access 1 | Fiorita Pocket Park | 32099 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.083 | Fiorita PP | ||
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 | ||
452 | 452 | 451 | {"type": "Polygon", "coordinates": [[[-121.68782, 37.93181], [-121.68752, 37.93182], [-121.68752, 37.93182], [-121.68753, 37.93177], [-121.68757, 37.93171], [-121.68782, 37.93158], [-121.68782, 37.93181]]]} | Open Access 1 | Almanor Pocket Park | 32049 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.107 | Almanor PP | ||
614 | 614 | 613 | {"type": "Polygon", "coordinates": [[[-121.7242, 37.95297], [-121.72419, 37.95332], [-121.72412, 37.95332], [-121.72407, 37.9533], [-121.72405, 37.95326], [-121.72406, 37.95297], [-121.7242, 37.95297]]]} | Open Access 1 | Giotto Pocket Park | 32097 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.112 | Giotto PP | ||
400 | 400 | 399 | {"type": "Polygon", "coordinates": [[[-121.69761, 37.94167], [-121.69761, 37.94193], [-121.69738, 37.94194], [-121.69738, 37.94174], [-121.69746, 37.94173], [-121.69756, 37.94167], [-121.69761, 37.94167]]]} | Open Access 1 | Curtis Park | 32011 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.127 | Curtis 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 | ||
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 | ||
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 | ||
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 | ||
613 | 613 | 612 | {"type": "Polygon", "coordinates": [[[-121.7244, 37.95094], [-121.72439, 37.95128], [-121.72409, 37.95128], [-121.7241, 37.95099], [-121.72412, 37.95095], [-121.72417, 37.95094], [-121.7244, 37.95094]]]} | Open Access 1 | La Pergola Pocket Park | 32096 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.244 | La Pergola PP | ||
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 | ||
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 | ||
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 | ||
621 | 621 | 620 | {"type": "Polygon", "coordinates": [[[-121.73791, 37.93053], [-121.73775, 37.93058], [-121.7371, 37.93028], [-121.73713, 37.93021], [-121.7373, 37.93016], [-121.73735, 37.93021], [-121.73741, 37.93024], [-121.73749, 37.93025], [-121.73757, 37.93022], [-121.73763, 37.93035], [-121.73776, 37.93046], [-121.73787, 37.93046], [-121.73791, 37.93053]]]} | Open Access 1 | Cortona Park | 32104 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.308 | Cortona 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 | ||
403 | 403 | 402 | {"type": "Polygon", "coordinates": [[[-121.73893, 37.93421], [-121.73889, 37.93425], [-121.73874, 37.93424], [-121.73856, 37.93418], [-121.73841, 37.93409], [-121.73829, 37.93399], [-121.73882, 37.93382], [-121.7389, 37.93401], [-121.73893, 37.93411], [-121.73893, 37.93421]]]} | Open Access 1 | Berkshire Park | 32013 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.395 | Berkshire Park | ||
612 | 612 | 611 | {"type": "Polygon", "coordinates": [[[-121.73119, 37.95185], [-121.73119, 37.95226], [-121.73077, 37.95226], [-121.73077, 37.9519], [-121.73078, 37.95186], [-121.73119, 37.95185]]]} | Open Access 1 | Fruitwood Park | 32098 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.417 | Fruitwood Park | ||
620 | 620 | 619 | {"type": "Polygon", "coordinates": [[[-121.73383, 37.94934], [-121.73383, 37.94951], [-121.73379, 37.94955], [-121.73343, 37.94958], [-121.73313, 37.94958], [-121.73309, 37.94957], [-121.73306, 37.94953], [-121.73306, 37.94933], [-121.73383, 37.94934]]]} | Open Access 1 | Cherry Park | 32103 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.435 | Cherry 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 | ||
374 | 374 | 373 | {"type": "Polygon", "coordinates": [[[-121.7385, 37.95126], [-121.7385, 37.95176], [-121.73807, 37.95175], [-121.73798, 37.95173], [-121.73794, 37.95169], [-121.73791, 37.95162], [-121.73793, 37.95146], [-121.73794, 37.95141], [-121.73799, 37.95136], [-121.73807, 37.95133], [-121.7383, 37.95128], [-121.7385, 37.95126]]]} | Open Access 1 | Palamino Park | 32101 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.608 | Palamino 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]);