units_with_maps

Table actions

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

1 row where MNG_AGENCY = 87 and YR_EST = 1986

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • East Bay Regional Park District · 1 ✖

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
16857 16857 16856 {"type": "Polygon", "coordinates": [[[-122.16525, 37.78676], [-122.16506, 37.78688], [-122.16491, 37.78714], [-122.16476, 37.78733], [-122.16457, 37.78752], [-122.16421, 37.78766], [-122.16373, 37.78763], [-122.16354, 37.78767], [-122.1629, 37.78754], [-122.16274, 37.78736], [-122.16258, 37.78761], [-122.16245, 37.78776], [-122.16234, 37.78786], [-122.16203, 37.78835], [-122.16177, 37.78857], [-122.16157, 37.78861], [-122.16137, 37.78923], [-122.16043, 37.78943], [-122.16001, 37.78928], [-122.15824, 37.78893], [-122.15759, 37.78815], [-122.15745, 37.78804], [-122.15629, 37.78755], [-122.15559, 37.78706], [-122.15504, 37.78605], [-122.15448, 37.78564], [-122.15416, 37.78575], [-122.15443, 37.78605], [-122.15217, 37.78722], [-122.15125, 37.78633], [-122.15082, 37.7865], [-122.1481, 37.78385], [-122.14729, 37.78418], [-122.14632, 37.78324], [-122.14717, 37.78258], [-122.14639, 37.78191], [-122.14535, 37.7826], [-122.1441, 37.78144], [-122.14443, 37.78126], [-122.14444, 37.78011], [-122.14421, 37.77962], [-122.14389, 37.77932], [-122.14361, 37.7788], [-122.14269, 37.77805], [-122.14293, 37.77764], [-122.14312, 37.77694], [-122.14214, 37.77641], [-122.14156, 37.77587], [-122.14158, 37.77572], [-122.14071, 37.77463], [-122.14364, 37.77317], [-122.14385, 37.77327], [-122.1436, 37.77386], [-122.14447, 37.77466], [-122.14494, 37.7756], [-122.14548, 37.77601], [-122.14569, 37.77594], [-122.14746, 37.77701], [-122.14792, 37.77762], [-122.14793, 37.77761], [-122.14774, 37.77684], [-122.14723, 37.7765], [-122.14726, 37.77641], [-122.14726, 37.77617], [-122.14639, 37.77551], [-122.14603, 37.77537], [-122.14643, 37.77506], [-122.14682, 37.77504], [-122.14742, 37.77574], [-122.15095, 37.77612], [-122.15046, 37.77682], [-122.15219, 37.77819], [-122.15346, 37.77871], [-122.15343, 37.77878], [-122.15164, 37.78013], [-122.15253, 37.78086], [-122.15355, 37.78118], [-122.15398, 37.78099], [-122.15464, 37.78148], [-122.1556, 37.78194], [-122.1555, 37.78278], [-122.15631, 37.78297], [-122.15682, 37.78317], [-122.15727, 37.78351], [-122.1581, 37.78461], [-122.15869, 37.784], [-122.1589, 37.78419], [-122.15953, 37.78446], [-122.16022, 37.78487], [-122.16076, 37.78526], [-122.16109, 37.78562], [-122.16157, 37.78596], [-122.16184, 37.7862], [-122.16259, 37.78645], [-122.16331, 37.78679], [-122.16337, 37.78696], [-122.1634, 37.78749], [-122.16382, 37.78749], [-122.16415, 37.78742], [-122.16454, 37.78728], [-122.16467, 37.78702], [-122.16473, 37.78683], [-122.16519, 37.78661], [-122.16525, 37.78676]]]} Open Access 1 17344 Leona Heights Regional Open Space 3282 2032 East Bay Regional Park District 89 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/parks/leona Alameda 17 297.093 Leona Heights Reg. OS 1986 Local Recreation Area 3 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]);