superunits_with_maps

Table actions

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

25 rows where MNG_AGENCY = 344 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 25 ✖

MNG_AGENCY 1

  • Benicia, City of · 25 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
1950 1950 1949 {"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.08528], [-122.15817, 38.08585], [-122.1587, 38.08649], [-122.15939, 38.08674], [-122.1605, 38.08671], [-122.16132, 38.08696], [-122.1611, 38.08721], [-122.16126, 38.08762], [-122.16146, 38.08789]]]} Open Access 1 Benicia Community Park   16010 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 31.668 Benicia Community Park 2000
1951 1951 1950 {"type": "Polygon", "coordinates": [[[-122.15828, 38.05398], [-122.15776, 38.05473], [-122.1558, 38.05383], [-122.1562, 38.05302], [-122.15828, 38.05398]]]} Open Access 1 Benicia holding 1   16011 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 4.824 Benicia holding 1  
2250 2250 2249 {"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.15823, 38.06034], [-122.15846, 38.06022], [-122.15868, 38.06022], [-122.15895, 38.06019], [-122.15898, 38.06085]]]} Open Access 1 Bridgeview Park   16381 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 4.379 Bridgeview Park  
2833 2833 2832 {"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 Channing Circle Park   17124 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 1.577 Channing Circle Park  
3006 3006 3005 {"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 Civic Center Park   17352 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 3.334 Civic Ctr. Park  
3348 3348 3347 {"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 Fitzgerald Park   18929 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 2.827 Fitzgerald Park  
3473 3473 3472 {"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 Francesca Terrace Park   19042 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 5.057 Francesca Terrace Park  
3731 3731 3730 {"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 Duncan Graham Park   18298 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 1.135 Duncan Graham Park  
4076 4076 4075 {"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 Ethelree Saraiva Park   18733 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 0.74 Ethelree Saraiva Park  
4372 4372 4371 {"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 Frank Skillman Park   19054 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 3.945 Frank Skillman Park  
4521 4521 4520 {"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 Gateway Park   19236 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 0.308 Gateway Park  
5440 5440 5439 {"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.16982, 38.08247], [-122.17035, 38.08288], [-122.1709, 38.08302]]]} Open Access 1 Jack London Park   20305 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 12.407 Jack London Park  
5676 5676 5675 {"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 Marsh   21886 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 22.393 Marsh  
6273 6273 6272 {"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 Little League Field Park   21345 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 2.317 Little League Field Park  
6651 6651 6650 {"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.04374], [-122.16089, 38.04401], [-122.16066, 38.04393], [-122.16032, 38.04393], [-122.16027, 38.04422], [-122.16053, 38.04433], [-122.16046, 38.04442], [-122.16043, 38.04449], [-122.15902, 38.0439], [-122.15814, 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.15381, 38.04324], [-122.15451, 38.04345], [-122.15515, 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.04519], [-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 Marina Park   21832 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 21.541 Marina Park  
6760 6760 6759 {"type": "Polygon", "coordinates": [[[-122.18038, 38.06346], [-122.17916, 38.06287], [-122.17895, 38.06327], [-122.17879, 38.06321], [-122.179, 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 Matthew Turner Shipyard Park   21956 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 2.266 Matthew Turner Shipyard Park  
7390 7390 7389 {"type": "Polygon", "coordinates": [[[-122.1753, 38.05854], [-122.17518, 38.05887], [-122.17487, 38.05891], [-122.17473, 38.05898], [-122.1745, 38.05921], [-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.17508, 38.05842], [-122.1753, 38.05854]]]} Open Access 1 Ninth Street Park   22765 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 7.462 Ninth Street Park  
7642 7642 7641 {"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 Overlook Park   23271 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 2.271 Overlook Park  
7953 7953 7952 {"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 Park Solano   23438 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 0.974 Park Solano  
9828 9828 9827 {"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 Southhampton Park   25691 1027 Benicia, City of 344 City 2 City Agency 2 http://ci.benicia.ca.us/parks City 2 10.137 Southhampton Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);