superunits_with_maps

Table actions

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

3 rows where ACCESS_TYP = 1, MNG_AGENCY = 1060 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

  • County Agency · 3 ✖

ACCESS_TYP 1

  • Open Access · 3 ✖
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
9736 9736 9735 {"type": "Polygon", "coordinates": [[[-121.61997, 37.90654], [-121.61837, 37.90657], [-121.61747, 37.90656], [-121.61748, 37.90592], [-121.61867, 37.90531], [-121.61898, 37.90506], [-121.61898, 37.90495], [-121.61947, 37.90532], [-121.61964, 37.90549], [-121.61976, 37.90565], [-121.61987, 37.90588], [-121.61992, 37.90603], [-121.61995, 37.90619], [-121.61997, 37.90654]]]} Open Access 1 Slifer Park   25558 369 Contra Costa, County of 1060 County 3 County Agency 3 http://www.co.contra-costa.ca.us/446/Parks-and-Recreation County 3 6.524 Slifer Park  
11771 11771 11770 {"type": "Polygon", "coordinates": [[[-122.03078, 38.03015], [-122.03061, 38.03021], [-122.03036, 38.02969], [-122.03052, 38.02965], [-122.03078, 38.03015]]]} Open Access 1 Big Oak Tree Park http://www.contracosta.ca.gov/4398/Clyde 28387 369 Contra Costa, County of 1060 County 3 County Agency 3 http://www.co.contra-costa.ca.us/446/Parks-and-Recreation County 3 0.241 Big Oak Tree Park  
11782 11782 11781 {"type": "Polygon", "coordinates": [[[-122.07002, 37.98678], [-122.06947, 37.98652], [-122.06924, 37.98637], [-122.06881, 37.98575], [-122.06874, 37.98561], [-122.06869, 37.98543], [-122.0683, 37.98352], [-122.06884, 37.98351], [-122.06919, 37.98462], [-122.06922, 37.98477], [-122.0692, 37.98517], [-122.06931, 37.98555], [-122.06955, 37.986], [-122.07001, 37.98661], [-122.07002, 37.98678]]]} Open Access 1 Hayden Park   28398 369 Contra Costa, County of 1060 County 3 County Agency 3 http://www.co.contra-costa.ca.us/446/Parks-and-Recreation County 3 4.478 Hayden 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]);