units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where MNG_AGENCY = 348 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
DES_TP 5
- Local Park 63
- Local Recreation Area 2
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 68
MNG_AGENCY 1
- Brentwood, City of · 68 ✖
ACCESS_TYP 1
- Open Access 68
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME ▼ | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2521 | 2521 | 2520 | {"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 | 47922 | Almanor Pocket Park | 32049 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 0.107 | Almanor PP | 0 | Local Park 2 | 4 | |
2513 | 2513 | 2512 | {"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 | 47923 | Almond Park | 32050 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 1.389 | Almond Park | 0 | Local Park 2 | 4 | |
5202 | 5202 | 5201 | {"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 | 47924 | Amber Park | 32051 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 0.281 | Amber Park | 0 | Local Park 2 | 4 | |
9774 | 9774 | 9773 | {"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.96696], [-121.72142, 37.96684], [-121.72142, 37.96679], [-121.72146, 37.96675], [-121.72152, 37.96673], [-121.72169, 37.96677], [-121.72201, 37.96679]]]} | Open Access 1 | 47925 | Anastasia Park | 32052 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 0.774 | Anastasia Park | 0 | Local Park 2 | 4 | |
14791 | 14791 | 14790 | {"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 | 47942 | Appaloosa Park | 32100 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 0.713 | Appaloosa Park | 0 | Local Park 2 | 4 | |
1517 | 1517 | 1516 | {"type": "Polygon", "coordinates": [[[-121.7324, 37.92885], [-121.73174, 37.92982], [-121.73166, 37.92985], [-121.72989, 37.92896], [-121.73018, 37.92863], [-121.73051, 37.92855], [-121.73172, 37.92869], [-121.73214, 37.92876], [-121.7324, 37.92885]]]} | Open Access 1 | 11473 | Apple Hill Park | 15539 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 4.417 | Apple Hill Park | 0 | Local Park 2 | 4 | |
7742 | 7742 | 7741 | {"type": "Polygon", "coordinates": [[[-121.70945, 37.96877], [-121.70815, 37.96876], [-121.70815, 37.96843], [-121.70839, 37.96842], [-121.70841, 37.96827], [-121.70833, 37.96818], [-121.70835, 37.96722], [-121.7093, 37.96723], [-121.7093, 37.96817], [-121.70918, 37.96828], [-121.70922, 37.96839], [-121.70941, 37.96844], [-121.70945, 37.96877]]]} | Open Access 1 | 11342 | Arbor View Park - North | 15560 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 3.749 | Arbor View Park - North | None 642 | |||
11590 | 11590 | 11589 | {"type": "Polygon", "coordinates": [[[-121.70932, 37.96644], [-121.70921, 37.96648], [-121.70921, 37.96707], [-121.70874, 37.96707], [-121.70874, 37.96654], [-121.70871, 37.96636], [-121.70841, 37.96576], [-121.70822, 37.96554], [-121.70795, 37.96518], [-121.70807, 37.96518], [-121.70824, 37.96553], [-121.70838, 37.96553], [-121.70841, 37.96562], [-121.70847, 37.96567], [-121.70853, 37.96568], [-121.70854, 37.96572], [-121.70903, 37.96573], [-121.70904, 37.96569], [-121.70922, 37.96569], [-121.70922, 37.96629], [-121.70931, 37.96633], [-121.7093, 37.96638], [-121.70932, 37.96644]]]} | Open Access 1 | 23693 | Arbor View Park - South | 15561 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 2.02 | Arbor View Park - South | None 1034 | |||
7695 | 7695 | 7694 | {"type": "Polygon", "coordinates": [[[-121.75553, 37.92537], [-121.75553, 37.92537], [-121.75551, 37.92742], [-121.75396, 37.92632], [-121.75395, 37.92535], [-121.75553, 37.92537]]]} | Open Access 1 | 11449 | Balfour Guthrie Park | 15783 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 5.691 | Balfour Guthrie Park | 2002 | Local Park 2 | 4 | |
9807 | 9807 | 9806 | {"type": "Polygon", "coordinates": [[[-121.73882, 37.93382], [-121.7389, 37.93401], [-121.73893, 37.9341], [-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]]]} | Open Access 1 | 47916 | Berkshire Park | 32013 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 0.395 | Berkshire Park | 0 | Local Park 2 | 4 | |
9892 | 9892 | 9891 | {"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 | 47934 | Big Basin Park | 32085 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 1.016 | Big Basin Park | 0 | Local Park 2 | 4 | |
9805 | 9805 | 9804 | {"type": "MultiPolygon", "coordinates": [[[[-121.74781, 37.93934], [-121.74693, 37.93984], [-121.74693, 37.9397], [-121.74681, 37.93944], [-121.74647, 37.93923], [-121.74662, 37.93903], [-121.74649, 37.93872], [-121.74644, 37.93871], [-121.74645, 37.93864], [-121.74641, 37.93858], [-121.74645, 37.93844], [-121.74635, 37.93823], [-121.74569, 37.93842], [-121.74512, 37.93853], [-121.74512, 37.93852], [-121.74516, 37.93848], [-121.74573, 37.93837], [-121.74615, 37.93825], [-121.74648, 37.93812], [-121.74682, 37.93797], [-121.74701, 37.9382], [-121.74707, 37.9383], [-121.74708, 37.93866], [-121.74743, 37.93872], [-121.74743, 37.93883], [-121.74736, 37.93893], [-121.74738, 37.93902], [-121.74744, 37.93907], [-121.74753, 37.93909], [-121.74757, 37.93919], [-121.74781, 37.93934]]], [[[-121.74625, 37.93634], [-121.7461, 37.93645], [-121.74602, 37.93646], [-121.74595, 37.93649], [-121.74591, 37.93655], [-121.7459, 37.93661], [-121.74594, 37.93667], [-121.74603, 37.93673], [-121.74605, 37.93676], [-121.74611, 37.93708], [-121.74622, 37.93737], [-121.74634, 37.93755], [-121.74656, 37.93783], [-121.74657, 37.93787], [-121.74655, 37.93791], [-121.74639, 37.93798], [-121.74606, 37.9381], [-121.74596, 37.93812], [-121.74591, 37.9381], [-121.74578, 37.93783], [-121.74538, 37.93731], [-121.74532, 37.93722], [-121.74527, 37.93704], [-121.74527, 37.93687], [-121.7453, 37.93678], [-121.74528, 37.93671], [-121.74539, 37.93662], [-121.74539, 37.93635], [-121.74625, 37.93634]]]]} | Open Access 1 | 47914 | Black Gold Park | 32010 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 6.244 | Black Gold Park | 0 | Local Park 2 | 4 | |
2318 | 2318 | 2317 | {"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 | 47936 | Blue Goose Park | 32090 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 4.006 | Blue Goose Park | 0 | Local Park 2 | 4 | |
8029 | 8029 | 8028 | {"type": "Polygon", "coordinates": [[[-121.69448, 37.93429], [-121.69377, 37.93468], [-121.69355, 37.93441], [-121.69357, 37.93427], [-121.6932, 37.93423], [-121.69287, 37.93382], [-121.69365, 37.93336], [-121.69448, 37.93429]]]} | Open Access 1 | 11390 | Brentwood Park | 16356 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 2.472 | Brentwood Park | 0 | Local Park 2 | 4 | |
9905 | 9905 | 9904 | {"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 | 47937 | Caboose Park | 32093 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 1.013 | Caboose Park | 0 | Local Park 2 | 4 | |
9913 | 9913 | 9912 | {"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 | 47947 | Carrara Pocket Park | 32107 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 0.103 | Carrara PP | 0 | Local Park 2 | 4 | |
11899 | 11899 | 11898 | {"type": "Polygon", "coordinates": [[[-121.72658, 37.96705], [-121.72658, 37.96714], [-121.72622, 37.96727], [-121.72597, 37.96732], [-121.7258, 37.96704], [-121.72566, 37.96688], [-121.72552, 37.96677], [-121.72606, 37.96652], [-121.72658, 37.96705]]]} | Open Access 1 | 24468 | Celeste Park | 17005 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 1.081 | Celeste Park | 0 | Local Park 2 | 4 | |
2327 | 2327 | 2326 | {"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 | 47945 | Cherry Park | 32103 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 0.435 | Cherry Park | 0 | Local Park 2 | 4 | |
2328 | 2328 | 2327 | {"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.73782, 37.93047], [-121.73787, 37.93046], [-121.73791, 37.93053]]]} | Open Access 1 | 47946 | Cortona Park | 32104 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 0.306 | Cortona Park | 0 | Local Park 2 | 4 | |
9912 | 9912 | 9911 | {"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.92833], [-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 | 47948 | Cortona Trailhead | 32108 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 1.3 | Cortona Trailhead | None 859 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);