superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where MNG_AGENCY = 348 sorted by SUID_NMA 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
608 | 608 | 607 | {"type": "Polygon", "coordinates": [[[-121.71387, 37.95128], [-121.71372, 37.95122], [-121.71357, 37.95117], [-121.7134, 37.95115], [-121.71292, 37.95113], [-121.71277, 37.95109], [-121.71258, 37.95102], [-121.71276, 37.95077], [-121.71319, 37.95053], [-121.71387, 37.95128]]]} | Open Access 1 | Caboose Park | 32093 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.013 | Caboose Park | ||
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 | ||
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 | ||
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 | ||
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 | ||
498 | 498 | 497 | {"type": "Polygon", "coordinates": [[[-121.71934, 37.96296], [-121.71931, 37.96301], [-121.71905, 37.96319], [-121.71887, 37.96326], [-121.71868, 37.96331], [-121.71867, 37.96328], [-121.7183, 37.96328], [-121.71827, 37.96326], [-121.71828, 37.96276], [-121.71867, 37.96275], [-121.71867, 37.96227], [-121.71878, 37.96245], [-121.71891, 37.96261], [-121.71909, 37.96276], [-121.71931, 37.9629], [-121.71934, 37.96296]]]} | Open Access 1 | Medallion Park | 32079 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.349 | Medallion 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 | ||
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 | ||
456 | 456 | 455 | {"type": "Polygon", "coordinates": [[[-121.73593, 37.94812], [-121.73565, 37.94812], [-121.73554, 37.94817], [-121.73546, 37.94809], [-121.73534, 37.94805], [-121.73409, 37.94804], [-121.73404, 37.948], [-121.73403, 37.94789], [-121.73398, 37.94779], [-121.73391, 37.94774], [-121.73378, 37.94771], [-121.73545, 37.94772], [-121.73593, 37.94812]]]} | Open Access 1 | Almond Park | 32050 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.389 | Almond Park | ||
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 | ||
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 | ||
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 |
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]);