units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

25 rows where COUNTY = 26 and MNG_AGENCY = 344

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

MNG_AGENCY 1

  • Benicia, City of · 25 ✖

ACCESS_TYP 1

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
1330 1330 1329 {"type": "Polygon", "coordinates": [[[-122.17182, 38.08036], [-122.17165, 38.08078], [-122.17099, 38.08064], [-122.17094, 38.08045], [-122.1708, 38.08028], [-122.17092, 38.08026], [-122.17102, 38.08011], [-122.17182, 38.08036]]]} Open Access 1 10851 Park Solano 23438 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.974 Park Solano   None 116  
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
2520 2520 2519 {"type": "MultiPolygon", "coordinates": [[[[-122.10883, 38.08466], [-122.10856, 38.08512], [-122.10661, 38.08437], [-122.107, 38.08372], [-122.10883, 38.08466]]], [[[-122.11782, 38.07304], [-122.117, 38.07394], [-122.11665, 38.07395], [-122.11626, 38.07408], [-122.11545, 38.07502], [-122.11546, 38.07522], [-122.11574, 38.07538], [-122.11478, 38.07658], [-122.11159, 38.08039], [-122.11075, 38.07985], [-122.11051, 38.07963], [-122.11104, 38.07906], [-122.11376, 38.07643], [-122.11554, 38.07452], [-122.11728, 38.07273], [-122.11782, 38.07304]]]]} Open Access 1 17675 Marsh 21886 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 22.393 Marsh   None 207  
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
4947 4947 4946 {"type": "Polygon", "coordinates": [[[-122.16884, 38.07871], [-122.16854, 38.07916], [-122.1682, 38.07936], [-122.16783, 38.07951], [-122.16755, 38.07969], [-122.16756, 38.08011], [-122.16751, 38.08034], [-122.16729, 38.08055], [-122.16721, 38.08092], [-122.1669, 38.081], [-122.16654, 38.08118], [-122.16654, 38.08149], [-122.16666, 38.08169], [-122.16696, 38.08185], [-122.16793, 38.082], [-122.16805, 38.08215], [-122.1671, 38.08249], [-122.16632, 38.08239], [-122.16569, 38.08243], [-122.16459, 38.0827], [-122.16413, 38.08274], [-122.16375, 38.08249], [-122.16313, 38.08232], [-122.16256, 38.08227], [-122.16194, 38.08265], [-122.1615, 38.08322], [-122.16133, 38.08356], [-122.1602, 38.08327], [-122.15965, 38.08302], [-122.15923, 38.08311], [-122.15905, 38.08335], [-122.15909, 38.08365], [-122.15944, 38.0839], [-122.16023, 38.08416], [-122.16091, 38.08435], [-122.16162, 38.08442], [-122.16132, 38.08447], [-122.16036, 38.08443], [-122.15955, 38.0843], [-122.1591, 38.08407], [-122.15879, 38.08377], [-122.15838, 38.08295], [-122.15771, 38.08145], [-122.15953, 38.08104], [-122.15989, 38.0808], [-122.15998, 38.08036], [-122.15973, 38.08008], [-122.1594, 38.08002], [-122.15843, 38.08023], [-122.15773, 38.08039], [-122.15737, 38.08059], [-122.15697, 38.08023], [-122.1573, 38.07991], [-122.15721, 38.07952], [-122.1572, 38.07937], [-122.15636, 38.07899], [-122.15572, 38.07886], [-122.15521, 38.07879], [-122.15431, 38.07806], [-122.15439, 38.07758], [-122.15475, 38.07713], [-122.15529, 38.07692], [-122.1555, 38.07735], [-122.15737, 38.07771], [-122.15789, 38.07798], [-122.15838, 38.078], [-122.15877, 38.07787], [-122.15881, 38.07735], [-122.15841, 38.07702], [-122.1578, 38.07674], [-122.15658, 38.07661], [-122.15619, 38.07631], [-122.15681, 38.07606], [-122.15729, 38.07595], [-122.15868, 38.07592], [-122.16034, 38.07582], [-122.16222, 38.07559], [-122.16301, 38.07601], [-122.16423, 38.07647], [-122.16455, 38.07673], [-122.16487, 38.07694], [-122.16538, 38.07704], [-122.16529, 38.07722], [-122.16541, 38.0776], [-122.16625, 38.07763], [-122.16653, 38.07753], [-122.16675, 38.07768], [-122.1684, 38.07835], [-122.16851, 38.07845], [-122.1688, 38.07852], [-122.16884, 38.07871]]]} Open Access 1 1683 Tourtelot Open Space 26481 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 160.466 Tourtelot OS 0 Local Recreation Area 3 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
9116 9116 9115 {"type": "Polygon", "coordinates": [[[-122.15372, 38.04874], [-122.15327, 38.04939], [-122.15218, 38.04892], [-122.15261, 38.04822], [-122.15372, 38.04874]]]} Open Access 1 15108 Little League Field Park 21345 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.318 Little League Field Park 0 Local Recreation Area 3 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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);