units_with_maps

Table actions

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

7 rows where COUNTY = 12, DES_TP = 2 and MNG_AGENCY = 351

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Hercules, City of · 7 ✖

DES_TP 1

  • Local Park · 7 ✖

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
1370 1370 1369 {"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 12052 Waterfront Park 27303 1133 Hercules, City of 354 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 1133 Hercules, City of 351 City 2 City Agency 2   Contra Costa 12 0.507 Waterfront Park 0 Local Park 2 4
5449 5449 5448 {"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 11993 Foxboro Park 19035 1133 Hercules, City of 354 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 1133 Hercules, City of 351 City 2 City Agency 2   Contra Costa 12 3.485 Foxboro Park 0 Local Park 2 4
8072 8072 8071 {"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 12005 Woodfield Park 27708 1133 Hercules, City of 354 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 1133 Hercules, City of 351 City 2 City Agency 2   Contra Costa 12 3.765 Woodfield Park 0 Local Park 2 4
8074 8074 8073 {"type": "Polygon", "coordinates": [[[-122.23719, 37.99248], [-122.23716, 37.99257], [-122.23705, 37.99266], [-122.23698, 37.99276], [-122.23681, 37.99357], [-122.23679, 37.99358], [-122.23679, 37.99363], [-122.23558, 37.9934], [-122.23555, 37.99247], [-122.23524, 37.99208], [-122.23421, 37.99163], [-122.23472, 37.99052], [-122.23565, 37.99071], [-122.23562, 37.9909], [-122.23593, 37.99102], [-122.23584, 37.99126], [-122.23608, 37.99136], [-122.23609, 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 12017 Hanna Ranch Park 19641 1133 Hercules, City of 354 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 1133 Hercules, City of 351 City 2 City Agency 2   Contra Costa 12 10.261 Hanna Ranch Park 0 Local Park 2 4
8076 8076 8075 {"type": "Polygon", "coordinates": [[[-122.26966, 38.00898], [-122.26961, 38.00903], [-122.26779, 38.00931], [-122.26785, 38.00878], [-122.26758, 38.00852], [-122.26758, 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.26704, 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 12029 Refugio Valley Park 24268 1133 Hercules, City of 354 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 1133 Hercules, City of 351 City 2 City Agency 2   Contra Costa 12 10.669 Refugio Valley Park 0 Local Park 2 4
8079 8079 8078 {"type": "Polygon", "coordinates": [[[-122.27455, 38.00682], [-122.27431, 38.00723], [-122.27387, 38.00728], [-122.27367, 38.00655], [-122.27338, 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 12041 Ohlone Park 23077 1133 Hercules, City of 354 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 1133 Hercules, City of 351 City 2 City Agency 2   Contra Costa 12 5.665 Ohlone Park 0 Local Park 2 4
15008 15008 15007 {"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.03333], [-122.27449, 38.03465], [-122.27349, 38.03366], [-122.2735, 38.03363], [-122.27311, 38.03323], [-122.2733, 38.03321], [-122.27336, 38.03329], [-122.27348, 38.03333], [-122.2736, 38.03329], [-122.27365, 38.0332], [-122.27405, 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.03272], [-122.27468, 38.03191], [-122.27491, 38.03132], [-122.27489, 38.03115], [-122.27485, 38.03103], [-122.27408, 38.03033], [-122.27414, 38.03025], [-122.27418, 38.03014], [-122.27423, 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.02837], [-122.27647, 38.02815], [-122.27645, 38.0281], [-122.27635, 38.02804], [-122.27655, 38.0279], [-122.27695, 38.02829]]]} Open Access 1 45658 Shoreline Park 28474 1133 Hercules, City of 354 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 1133 Hercules, City of 351 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=178#Shoreline Park Contra Costa 12 10.467 Shoreline Park 0 Local Park 2 4

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