superunits_with_maps

Table actions

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

7 rows where ACCESS_TYP = 1 and MNG_AGENCY = 351

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Hercules, City of · 7 ✖

ACCESS_TYP 1

  • Open Access · 7 ✖
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
4354 4354 4353 {"type": "Polygon", "coordinates": [[[-122.26061, 38.01443], [-122.26017, 38.01496], [-122.25964, 38.01488], [-122.25894, 38.01487], [-122.25863, 38.01494], [-122.2587, 38.01457], [-122.25859, 38.0141], [-122.26007, 38.01404], [-122.26061, 38.01443]]]} Open Access 1 Foxboro Park   19035 1133 Hercules, City of 351 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 3.485 Foxboro Park  
4873 4873 4872 {"type": "Polygon", "coordinates": [[[-122.23719, 37.99248], [-122.23716, 37.99257], [-122.23705, 37.99266], [-122.23698, 37.99276], [-122.23679, 37.99363], [-122.23558, 37.9934], [-122.23555, 37.99246], [-122.23524, 37.99208], [-122.23421, 37.99163], [-122.23472, 37.99052], [-122.23565, 37.99071], [-122.23563, 37.9909], [-122.23593, 37.99102], [-122.23585, 37.99126], [-122.23608, 37.99136], [-122.2361, 37.9915], [-122.23629, 37.99157], [-122.2364, 37.99182], [-122.23657, 37.99209], [-122.23675, 37.99223], [-122.23709, 37.99238], [-122.23719, 37.99248]]]} Open Access 1 Hanna Ranch Park   19641 1133 Hercules, City of 351 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 10.265 Hanna Ranch Park  
7617 7617 7616 {"type": "Polygon", "coordinates": [[[-122.27455, 38.00682], [-122.27431, 38.00723], [-122.27387, 38.00728], [-122.27367, 38.00655], [-122.27337, 38.00617], [-122.27258, 38.00601], [-122.27246, 38.00546], [-122.27306, 38.00523], [-122.27353, 38.00508], [-122.27435, 38.00571], [-122.27451, 38.00622], [-122.27437, 38.00636], [-122.27455, 38.00682]]]} Open Access 1 Ohlone Park   23077 1133 Hercules, City of 351 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 5.667 Ohlone Park  
8621 8621 8620 {"type": "Polygon", "coordinates": [[[-122.26966, 38.00898], [-122.26961, 38.00903], [-122.26779, 38.00931], [-122.26785, 38.00878], [-122.26758, 38.00852], [-122.26757, 38.00846], [-122.2669, 38.00788], [-122.26664, 38.00778], [-122.26646, 38.00774], [-122.26682, 38.0071], [-122.26688, 38.00709], [-122.26698, 38.00713], [-122.26705, 38.00711], [-122.26742, 38.0066], [-122.26898, 38.00767], [-122.26924, 38.00793], [-122.26931, 38.00801], [-122.26946, 38.00827], [-122.2696, 38.00861], [-122.26966, 38.00896], [-122.26966, 38.00898]]]} Open Access 1 Refugio Valley Park   24268 1133 Hercules, City of 351 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 10.671 Refugio Valley Park  
11064 11064 11063 {"type": "Polygon", "coordinates": [[[-122.2916, 38.01582], [-122.29115, 38.01599], [-122.29085, 38.01572], [-122.2913, 38.01544], [-122.2916, 38.01582]]]} Open Access 1 Waterfront Park   27303 1133 Hercules, City of 351 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 0.507 Waterfront Park  
11376 11376 11375 {"type": "Polygon", "coordinates": [[[-122.25266, 38.0067], [-122.25224, 38.00769], [-122.25192, 38.00797], [-122.25101, 38.0076], [-122.25175, 38.00629], [-122.25266, 38.0067]]]} Open Access 1 Woodfield Park   27708 1133 Hercules, City of 351 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 3.764 Woodfield Park  
11830 11830 11829 {"type": "Polygon", "coordinates": [[[-122.27695, 38.02829], [-122.27668, 38.02857], [-122.27649, 38.02878], [-122.27626, 38.02908], [-122.27607, 38.02939], [-122.27585, 38.02979], [-122.2756, 38.0303], [-122.27523, 38.03116], [-122.27496, 38.03196], [-122.2748, 38.03258], [-122.27467, 38.03334], [-122.27449, 38.03465], [-122.27349, 38.03366], [-122.2735, 38.03362], [-122.27311, 38.03323], [-122.2733, 38.03321], [-122.27336, 38.03329], [-122.27348, 38.03332], [-122.2736, 38.03329], [-122.27365, 38.0332], [-122.27404, 38.03314], [-122.27396, 38.03285], [-122.27372, 38.03242], [-122.27387, 38.03234], [-122.27397, 38.0324], [-122.2741, 38.03267], [-122.27442, 38.03272], [-122.27447, 38.03271], [-122.27468, 38.03191], [-122.27491, 38.03132], [-122.27489, 38.03115], [-122.27485, 38.03103], [-122.27408, 38.03033], [-122.27414, 38.03024], [-122.27418, 38.03014], [-122.27424, 38.0299], [-122.27427, 38.02985], [-122.27435, 38.02982], [-122.27466, 38.02984], [-122.2748, 38.02988], [-122.27483, 38.02998], [-122.27515, 38.03012], [-122.27527, 38.03009], [-122.27546, 38.02976], [-122.27557, 38.02929], [-122.27593, 38.02886], [-122.27624, 38.02838], [-122.27647, 38.02815], [-122.27645, 38.0281], [-122.27635, 38.02804], [-122.27655, 38.0279], [-122.27695, 38.02829]]]} Open Access 1 Shoreline Park http://www.ci.hercules.ca.us/index.aspx?page=178#Shoreline Park 28474 1133 Hercules, City of 351 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 10.475 Shoreline Park  

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