units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where AGNCY_NAME = 347, DES_TP = 2 and MNG_AGENCY = 344
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- City Agency 18
MNG_AGENCY 1
- Benicia, City of · 18 ✖
DES_TP 1
- Local Park · 18 ✖
ACCESS_TYP 1
- Open Access 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1328 | 1328 | 1327 | {"type": "Polygon", "coordinates": [[[-122.15732, 38.0806], [-122.1569, 38.08087], [-122.15644, 38.08063], [-122.15466, 38.08044], [-122.15466, 38.08032], [-122.1548, 38.08004], [-122.15494, 38.07957], [-122.15567, 38.07968], [-122.15607, 38.07993], [-122.15624, 38.08012], [-122.15681, 38.08024], [-122.15732, 38.0806]]]} | Open Access 1 | 10834 | Frank Skillman Park | 19054 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 3.944 | Frank Skillman Park | 0 | Local Park 2 | 4 | |
1329 | 1329 | 1328 | {"type": "Polygon", "coordinates": [[[-122.18383, 38.09471], [-122.1838, 38.09489], [-122.18358, 38.09508], [-122.18317, 38.09495], [-122.18237, 38.09491], [-122.18239, 38.09454], [-122.18298, 38.09452], [-122.18335, 38.09437], [-122.18383, 38.09471]]]} | Open Access 1 | 10843 | Channing Circle Park | 17124 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 1.577 | Channing Circle Park | 0 | Local Park 2 | 4 | |
1334 | 1334 | 1333 | {"type": "Polygon", "coordinates": [[[-122.15933, 38.07512], [-122.15933, 38.07532], [-122.15829, 38.07543], [-122.15682, 38.07548], [-122.15563, 38.0758], [-122.15542, 38.07564], [-122.15525, 38.07575], [-122.15507, 38.07565], [-122.15491, 38.07575], [-122.15472, 38.07575], [-122.15485, 38.07472], [-122.15508, 38.07477], [-122.15591, 38.07472], [-122.15688, 38.07449], [-122.15786, 38.07409], [-122.15809, 38.07452], [-122.15852, 38.07478], [-122.15916, 38.07489], [-122.15933, 38.07512]]]} | Open Access 1 | 10860 | Southhampton Park | 25691 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 10.134 | Southhampton Park | 0 | Local Park 2 | 4 | |
1335 | 1335 | 1334 | {"type": "Polygon", "coordinates": [[[-122.16896, 38.0589], [-122.16836, 38.05972], [-122.16685, 38.05884], [-122.16731, 38.05817], [-122.16896, 38.0589]]]} | Open Access 1 | 10872 | Willow Glen Park | 27578 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 3.875 | Willow Glen Park | 0 | Local Park 2 | 4 | |
1529 | 1529 | 1528 | {"type": "Polygon", "coordinates": [[[-122.14522, 38.04964], [-122.14497, 38.04998], [-122.14428, 38.04965], [-122.14451, 38.04933], [-122.14522, 38.04964]]]} | Open Access 1 | 10896 | Ethelree Saraiva Park | 18733 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 0.741 | Ethelree Saraiva Park | 0 | Local Park 2 | 4 | |
2528 | 2528 | 2527 | {"type": "Polygon", "coordinates": [[[-122.18038, 38.06346], [-122.17915, 38.06286], [-122.17895, 38.06327], [-122.17879, 38.06321], [-122.17901, 38.06282], [-122.17803, 38.06237], [-122.17882, 38.06223], [-122.17909, 38.06206], [-122.17928, 38.06224], [-122.17965, 38.06273], [-122.18035, 38.06337], [-122.18038, 38.06346]]]} | Open Access 1 | 17735 | Matthew Turner Shipyard Park | 21956 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 2.257 | Matthew Turner Shipyard Park | 0 | Local Park 2 | 4 | |
5590 | 5590 | 5589 | {"type": "Polygon", "coordinates": [[[-122.1753, 38.05854], [-122.17518, 38.05887], [-122.17487, 38.05891], [-122.17473, 38.05898], [-122.1745, 38.0592], [-122.17449, 38.05999], [-122.17505, 38.06071], [-122.17488, 38.061], [-122.1729, 38.06002], [-122.17442, 38.05811], [-122.1744, 38.0579], [-122.17463, 38.05795], [-122.17471, 38.05799], [-122.17477, 38.05815], [-122.17488, 38.05826], [-122.17507, 38.05842], [-122.1753, 38.05854]]]} | Open Access 1 | 14104 | Ninth Street Park | 22765 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 7.46 | Ninth Street Park | 0 | Local Park 2 | 4 | |
7985 | 7985 | 7984 | {"type": "Polygon", "coordinates": [[[-122.13957, 38.05526], [-122.13946, 38.05577], [-122.13901, 38.05588], [-122.13853, 38.05669], [-122.13838, 38.05697], [-122.13712, 38.05639], [-122.13704, 38.05602], [-122.1395, 38.05512], [-122.13957, 38.05526]]]} | Open Access 1 | 10907 | Francesca Terrace Park | 19042 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 5.056 | Francesca Terrace Park | 0 | Local Park 2 | 4 | |
7986 | 7986 | 7985 | {"type": "Polygon", "coordinates": [[[-122.1451, 38.05818], [-122.14473, 38.05875], [-122.14461, 38.0587], [-122.14438, 38.05843], [-122.14418, 38.05833], [-122.14453, 38.0578], [-122.14508, 38.05809], [-122.1451, 38.05818]]]} | Open Access 1 | 10919 | Duncan Graham Park | 18298 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 1.136 | Duncan Graham Park | 0 | Local Park 2 | 4 | |
7987 | 7987 | 7986 | {"type": "Polygon", "coordinates": [[[-122.1534, 38.06324], [-122.15322, 38.06357], [-122.15154, 38.0628], [-122.1519, 38.06232], [-122.15309, 38.06292], [-122.15309, 38.06309], [-122.1534, 38.06324]]]} | Open Access 1 | 10931 | Overlook Park | 23271 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 2.271 | Overlook Park | 0 | Local Park 2 | 4 | |
7989 | 7989 | 7988 | {"type": "Polygon", "coordinates": [[[-122.15898, 38.06085], [-122.15842, 38.06096], [-122.15787, 38.06131], [-122.15715, 38.061], [-122.15679, 38.0607], [-122.15697, 38.06049], [-122.15719, 38.0601], [-122.15736, 38.05988], [-122.15824, 38.06034], [-122.15846, 38.06022], [-122.15868, 38.06022], [-122.15895, 38.06019], [-122.15898, 38.06085]]]} | Open Access 1 | 10943 | Bridgeview Park | 16381 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 4.379 | Bridgeview Park | 0 | Local Park 2 | 4 | |
7990 | 7990 | 7989 | {"type": "Polygon", "coordinates": [[[-122.17275, 38.0908], [-122.17251, 38.0911], [-122.17217, 38.09094], [-122.1725, 38.09066], [-122.17275, 38.0908]]]} | Open Access 1 | 10955 | Gateway Park | 19236 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 0.309 | Gateway Park | 0 | Local Park 2 | 4 | |
7992 | 7992 | 7991 | {"type": "Polygon", "coordinates": [[[-122.1561, 38.05304], [-122.15563, 38.05378], [-122.15414, 38.05302], [-122.15466, 38.05235], [-122.1561, 38.05304]]]} | Open Access 1 | 10886 | Civic Center Park | 17352 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 3.335 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
9114 | 9114 | 9113 | {"type": "Polygon", "coordinates": [[[-122.15575, 38.04966], [-122.15517, 38.05049], [-122.15412, 38.04999], [-122.15467, 38.04915], [-122.15575, 38.04966]]]} | Open Access 1 | 15105 | Fitzgerald Park | 18929 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 2.827 | Fitzgerald Park | 0 | Local Park 2 | 4 | |
9918 | 9918 | 9917 | {"type": "Polygon", "coordinates": [[[-122.1709, 38.08302], [-122.17059, 38.08346], [-122.17013, 38.08385], [-122.16949, 38.08424], [-122.16857, 38.0845], [-122.16794, 38.08461], [-122.16773, 38.08416], [-122.16733, 38.08379], [-122.16856, 38.08288], [-122.16826, 38.08215], [-122.16952, 38.08172], [-122.16952, 38.08208], [-122.16981, 38.08247], [-122.17035, 38.08288], [-122.1709, 38.08302]]]} | Open Access 1 | 17061 | Jack London Park | 20305 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 12.401 | Jack London Park | 0 | Local Park 2 | 4 | |
10129 | 10129 | 10128 | {"type": "Polygon", "coordinates": [[[-122.1629, 38.04369], [-122.16277, 38.04386], [-122.16231, 38.0441], [-122.16135, 38.04413], [-122.16109, 38.04405], [-122.16117, 38.0438], [-122.16103, 38.04373], [-122.16089, 38.04401], [-122.16066, 38.04393], [-122.16031, 38.04393], [-122.16027, 38.04423], [-122.16053, 38.04433], [-122.16046, 38.04442], [-122.16043, 38.04449], [-122.15902, 38.0439], [-122.15813, 38.04407], [-122.15804, 38.04521], [-122.15821, 38.04554], [-122.15798, 38.04595], [-122.15744, 38.04645], [-122.15724, 38.04643], [-122.15669, 38.04615], [-122.15622, 38.0465], [-122.15368, 38.04548], [-122.15345, 38.04524], [-122.15343, 38.04496], [-122.15386, 38.0443], [-122.15385, 38.04428], [-122.15141, 38.0441], [-122.15231, 38.04285], [-122.15257, 38.04291], [-122.15279, 38.04287], [-122.15327, 38.04296], [-122.1538, 38.04324], [-122.15451, 38.04345], [-122.15514, 38.04351], [-122.15679, 38.04342], [-122.15702, 38.04358], [-122.15699, 38.0439], [-122.15694, 38.04412], [-122.15681, 38.04428], [-122.15534, 38.04427], [-122.1542, 38.04432], [-122.15394, 38.04464], [-122.15384, 38.04488], [-122.15376, 38.045], [-122.15378, 38.0452], [-122.15489, 38.04573], [-122.1562, 38.04616], [-122.15648, 38.04609], [-122.15671, 38.04599], [-122.15737, 38.04621], [-122.15768, 38.04599], [-122.15793, 38.04567], [-122.15798, 38.0455], [-122.15783, 38.04529], [-122.1578, 38.04391], [-122.15801, 38.04367], [-122.15813, 38.04367], [-122.15861, 38.04361], [-122.15902, 38.0434], [-122.15945, 38.0436], [-122.16023, 38.04377], [-122.16071, 38.04381], [-122.16102, 38.04361], [-122.16163, 38.04384], [-122.1629, 38.04369]]]} | Open Access 1 | 17604 | Marina Park | 21832 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 21.507 | Marina Park | 0 | Local Park 2 | 4 | |
10546 | 10546 | 10545 | {"type": "Polygon", "coordinates": [[[-122.16146, 38.08789], [-122.16142, 38.08812], [-122.16113, 38.08875], [-122.16075, 38.08914], [-122.15994, 38.08931], [-122.15902, 38.08918], [-122.15851, 38.08897], [-122.15817, 38.08892], [-122.15769, 38.08893], [-122.15708, 38.08888], [-122.15659, 38.0884], [-122.1563, 38.08783], [-122.15735, 38.08635], [-122.15778, 38.08578], [-122.15762, 38.08522], [-122.15727, 38.08473], [-122.15865, 38.08398], [-122.15903, 38.08432], [-122.15847, 38.08498], [-122.15814, 38.08529], [-122.15817, 38.08585], [-122.1587, 38.08649], [-122.1594, 38.08674], [-122.1605, 38.08671], [-122.16132, 38.08696], [-122.1611, 38.0872], [-122.16126, 38.08762], [-122.16146, 38.08789]]]} | Open Access 1 | 18760 | Benicia Community Park | 16010 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 31.661 | Benicia Community Park | 2000 | Local Park 2 | 4 | |
14646 | 14646 | 14645 | {"type": "Polygon", "coordinates": [[[-122.14708, 38.08644], [-122.14703, 38.08677], [-122.14675, 38.08739], [-122.14585, 38.0874], [-122.14584, 38.08702], [-122.14579, 38.08655], [-122.14581, 38.0865], [-122.14586, 38.08648], [-122.14708, 38.08644]]]} | Open Access 1 | 44900 | Waters End Park | 27305 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 2.501 | Waters End 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]);