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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4534 | 4534 | 4533 | {"type": "Polygon", "coordinates": [[[-121.72277, 37.96245], [-121.72218, 37.96276], [-121.72178, 37.96232], [-121.72187, 37.96225], [-121.72195, 37.96226], [-121.72255, 37.96226], [-121.72277, 37.96245]]]} | Open Access 1 | Gemini Park | 19252 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.705 | Gemini 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 | ||
619 | 619 | 618 | {"type": "Polygon", "coordinates": [[[-121.74031, 37.95246], [-121.74031, 37.95295], [-121.73971, 37.95295], [-121.73971, 37.95246], [-121.74031, 37.95246]]]} | Open Access 1 | Appaloosa Park | 32100 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 0.713 | Appaloosa 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 | ||
5226 | 5226 | 5225 | {"type": "Polygon", "coordinates": [[[-121.69461, 37.95525], [-121.69461, 37.95525], [-121.69322, 37.95527], [-121.69369, 37.95481], [-121.69394, 37.95494], [-121.6946, 37.95493], [-121.69461, 37.95525]]]} | Open Access 1 | Homecoming Park | 20059 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.004 | Homecoming Park | ||
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 | ||
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 | ||
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 | ||
4612 | 4612 | 4611 | {"type": "Polygon", "coordinates": [[[-121.69054, 37.92014], [-121.6899, 37.92051], [-121.68948, 37.92005], [-121.69016, 37.91969], [-121.69054, 37.92014]]]} | Open Access 1 | Glory Park | 19349 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.072 | Glory 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 | ||
2734 | 2734 | 2733 | {"type": "Polygon", "coordinates": [[[-121.72658, 37.96705], [-121.72658, 37.96714], [-121.72622, 37.96727], [-121.72597, 37.96732], [-121.7258, 37.96704], [-121.72567, 37.96688], [-121.72552, 37.96677], [-121.72606, 37.96652], [-121.72658, 37.96705]]]} | Open Access 1 | Celeste Park | 17005 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.081 | Celeste 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 | ||
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 | ||
625 | 625 | 624 | {"type": "Polygon", "coordinates": [[[-121.73817, 37.92637], [-121.737, 37.92675], [-121.73669, 37.92711], [-121.73655, 37.92748], [-121.73652, 37.92788], [-121.73674, 37.92832], [-121.73685, 37.92845], [-121.73682, 37.9285], [-121.73652, 37.92854], [-121.73641, 37.92799], [-121.7364, 37.92779], [-121.73641, 37.92759], [-121.7365, 37.9273], [-121.73675, 37.9268], [-121.73678, 37.92658], [-121.73687, 37.92662], [-121.73804, 37.92622], [-121.73817, 37.92637]]]} | Open Access 1 | Cortona Trailhead | 32108 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.301 | Cortona Trailhead | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);