units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where MNG_AGENCY = 348 and MNG_AG_TYP = 2 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- City Agency · 48 ✖
MNG_AGENCY 1
- Brentwood, City of · 48 ✖
ACCESS_TYP 1
- Open Access 48
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6517 | 6517 | 6516 | {"type": "Polygon", "coordinates": [[[-121.71465, 37.92218], [-121.71415, 37.9226], [-121.714, 37.92308], [-121.71255, 37.92315], [-121.71247, 37.9229], [-121.71262, 37.92219], [-121.71315, 37.92159], [-121.71359, 37.92124], [-121.71414, 37.92094], [-121.71421, 37.92151], [-121.71441, 37.92186], [-121.71465, 37.92218]]]} | Open Access 1 | 2754 | Creekside Park | 17771 | 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.922 | Creekside Park | 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 | |
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 | |
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 | |
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 | |
14759 | 14759 | 14758 | {"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 | 47941 | Fiorita Pocket Park | 32099 | 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.083 | Fiorita PP | 0 | Local Park 2 | 4 | |
9902 | 9902 | 9901 | {"type": "Polygon", "coordinates": [[[-121.73119, 37.95185], [-121.73119, 37.95226], [-121.73077, 37.95227], [-121.73077, 37.9519], [-121.73078, 37.95186], [-121.73119, 37.95185]]]} | Open Access 1 | 47940 | Fruitwood Park | 32098 | 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.417 | Fruitwood Park | 0 | Local Park 2 | 4 | |
9888 | 9888 | 9887 | {"type": "Polygon", "coordinates": [[[-121.71875, 37.96018], [-121.71875, 37.96018], [-121.71874, 37.9607], [-121.71844, 37.96018], [-121.71875, 37.96018]]]} | Open Access 1 | 47931 | Gann Street Pocket Park | 32080 | 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.19 | Gann Street 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 | |
11900 | 11900 | 11899 | {"type": "Polygon", "coordinates": [[[-121.72277, 37.96245], [-121.72218, 37.96276], [-121.72178, 37.96232], [-121.72187, 37.96225], [-121.72194, 37.96226], [-121.72255, 37.96226], [-121.72277, 37.96245]]]} | Open Access 1 | 24469 | Gemini Park | 19252 | 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.706 | Gemini Park | 0 | Local Park 2 | 4 | |
17065 | 17065 | 17064 | {"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 | 47939 | Giotto Pocket Park | 32097 | 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.112 | Giotto PP | 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 | |
9775 | 9775 | 9774 | {"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 | 47926 | Granville Green Park | 32053 | 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.758 | Granville Green Park | 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 | |
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 | |
11592 | 11592 | 11591 | {"type": "Polygon", "coordinates": [[[-121.72108, 37.94512], [-121.72097, 37.94543], [-121.72086, 37.94556], [-121.7208, 37.9457], [-121.72078, 37.9459], [-121.72077, 37.94628], [-121.72073, 37.94643], [-121.72069, 37.94645], [-121.72067, 37.94649], [-121.72069, 37.94652], [-121.72068, 37.94658], [-121.71946, 37.94658], [-121.71946, 37.94628], [-121.71953, 37.94627], [-121.71959, 37.94624], [-121.71962, 37.9462], [-121.71964, 37.94614], [-121.71963, 37.94544], [-121.71958, 37.94537], [-121.71953, 37.94534], [-121.71946, 37.94533], [-121.71946, 37.94531], [-121.71996, 37.94531], [-121.72028, 37.94528], [-121.72066, 37.94522], [-121.72108, 37.94512]]]} | Open Access 1 | 23695 | King Park | 20656 | 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.946 | King Park | 0 | Local Park 2 | 4 | |
9906 | 9906 | 9905 | {"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 | 47938 | La Pergola Pocket Park | 32096 | 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.244 | La Pergola PP | 0 | Local Park 2 | 4 | |
7696 | 7696 | 7695 | {"type": "Polygon", "coordinates": [[[-121.74367, 37.92592], [-121.74365, 37.92608], [-121.74279, 37.92626], [-121.7424, 37.92624], [-121.74238, 37.92541], [-121.74303, 37.92543], [-121.74303, 37.92568], [-121.74367, 37.92592]]]} | Open Access 1 | 11461 | Lake Park | 20958 | 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.794 | Lake Park | 0 | Local Park 2 | 4 | |
8028 | 8028 | 8027 | {"type": "Polygon", "coordinates": [[[-121.73692, 37.94085], [-121.73677, 37.94122], [-121.73616, 37.94185], [-121.73409, 37.94184], [-121.73387, 37.94158], [-121.73356, 37.94143], [-121.7337, 37.94082], [-121.73646, 37.94077], [-121.73648, 37.94084], [-121.73692, 37.94085]]]} | Open Access 1 | 11378 | Loma Vista Park | 21410 | 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 | 7.251 | Loma Vista Park | 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 |
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]);