units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
63 rows where DES_TP = 2 and MNG_AGENCY = 348 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- City Agency 63
MNG_AGENCY 1
- Brentwood, City of · 63 ✖
DES_TP 1
- Local Park · 63 ✖
ACCESS_TYP 1
- Open Access 63
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
14790 | 14790 | 14789 | {"type": "Polygon", "coordinates": [[[-121.68502, 37.93333], [-121.68478, 37.93333], [-121.68477, 37.93286], [-121.68501, 37.93286], [-121.68502, 37.93333]]]} | Open Access 1 | 47951 | Rice Pocket Park | 32117 | 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.271 | Rice PP | 0 | Local Park 2 | 4 | |
2330 | 2330 | 2329 | {"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 | 47955 | Mallard Park | 32126 | 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.528 | Mallard Park | 0 | Local Park 2 | 4 | |
5191 | 5191 | 5190 | {"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 | 47953 | Sawyer Pocket Park | 32123 | 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.225 | Sawyer PP | 0 | Local Park 2 | 4 | |
9907 | 9907 | 9906 | {"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 | 47952 | Crocket Pocket Park | 32122 | 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.147 | Crocket PP | 0 | Local Park 2 | 4 | |
11595 | 11595 | 11594 | {"type": "Polygon", "coordinates": [[[-121.68708, 37.93859], [-121.68708, 37.93885], [-121.687, 37.93889], [-121.687, 37.93911], [-121.68708, 37.93908], [-121.68708, 37.93924], [-121.687, 37.93929], [-121.687, 37.9395], [-121.68708, 37.93947], [-121.68708, 37.93981], [-121.68705, 37.93986], [-121.68697, 37.93989], [-121.68496, 37.9399], [-121.68473, 37.93992], [-121.68441, 37.93996], [-121.68393, 37.93997], [-121.68394, 37.93831], [-121.6842, 37.93831], [-121.68421, 37.93859], [-121.68669, 37.93859], [-121.68689, 37.93859], [-121.68689, 37.93832], [-121.68694, 37.93832], [-121.68702, 37.93834], [-121.68702, 37.93858], [-121.68708, 37.93859]]]} | Open Access 1 | 23697 | Heron Park | 19878 | 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 | 10.18 | Heron Park | 0 | Local Park 2 | 4 | |
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 | |
2389 | 2389 | 2388 | {"type": "Polygon", "coordinates": [[[-121.6885, 37.93079], [-121.68764, 37.93079], [-121.68768, 37.92743], [-121.68846, 37.92741], [-121.68847, 37.92742], [-121.6885, 37.93079]]]} | Open Access 1 | 11489 | Garin Park | 19219 | 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.72 | Garin Park | 0 | Local Park 2 | 4 | |
2332 | 2332 | 2331 | {"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 | 47956 | Pelican Park | 32127 | 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.051 | Pelican Park | 0 | Local Park 2 | 4 | |
9914 | 9914 | 9913 | {"type": "Polygon", "coordinates": [[[-121.68987, 37.94127], [-121.68992, 37.94128], [-121.68994, 37.94132], [-121.68994, 37.94182], [-121.68992, 37.94186], [-121.68987, 37.94187], [-121.68889, 37.94188], [-121.68888, 37.94128], [-121.68987, 37.94127]]]} | Open Access 1 | 47954 | Egret Park | 32125 | 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.538 | Egret Park | 0 | Local Park 2 | 4 | |
9936 | 9936 | 9935 | {"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 | 47957 | Daytona Park | 32129 | 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.222 | Daytona Park | 0 | Local Park 2 | 4 | |
1352 | 1352 | 1351 | {"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 | 11501 | Glory Park | 19349 | 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.072 | Glory Park | 0 | Local Park 2 | 4 | |
9699 | 9699 | 9698 | {"type": "Polygon", "coordinates": [[[-121.69153, 37.94118], [-121.69124, 37.94131], [-121.69115, 37.94124], [-121.69108, 37.94123], [-121.69101, 37.94125], [-121.69085, 37.94096], [-121.69115, 37.94096], [-121.69136, 37.94101], [-121.69153, 37.94118]]]} | Open Access 1 | 47921 | Windsor Park | 32048 | 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.349 | Windsor Park | 0 | Local Park 2 | 4 | |
7693 | 7693 | 7692 | {"type": "Polygon", "coordinates": [[[-121.69387, 37.92234], [-121.69316, 37.92234], [-121.69306, 37.92255], [-121.6929, 37.92262], [-121.69292, 37.92275], [-121.69278, 37.92276], [-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 | 11426 | Walnut Park | 27238 | 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.188 | Walnut Park | 0 | Local Park 2 | 4 | |
2392 | 2392 | 2391 | {"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 | 11512 | Spirit Park | 25725 | 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.522 | Spirit 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 | |
7121 | 7121 | 7120 | {"type": "Polygon", "coordinates": [[[-121.69461, 37.95525], [-121.69461, 37.95525], [-121.69322, 37.95527], [-121.69369, 37.95481], [-121.69393, 37.95494], [-121.6946, 37.95493], [-121.69461, 37.95525]]]} | Open Access 1 | 11352 | Homecoming Park | 20059 | 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.004 | Homecoming Park | 0 | Local Park 2 | 4 | |
9806 | 9806 | 9805 | {"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 | 47915 | Curtis Park | 32011 | 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.127 | Curtis Park | 0 | Local Park 2 | 4 | |
9897 | 9897 | 9896 | {"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 | 47935 | Marsh Creek Vista Park | 32086 | 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.245 | Marsh Creek Vista Park | 0 | Local Park 2 | 4 | |
1351 | 1351 | 1350 | {"type": "Polygon", "coordinates": [[[-121.69897, 37.92733], [-121.69896, 37.92916], [-121.69801, 37.92915], [-121.69802, 37.92899], [-121.69829, 37.92877], [-121.69827, 37.92732], [-121.69897, 37.92733]]]} | Open Access 1 | 11414 | McClarren Park | 21997 | 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.186 | McClarren Park | 0 | Local Park 2 | 4 |
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]);