superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, MNG_AG_TYP = 7 and PARK_NAME = "Field Sports Park"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency - Parks · 1 ✖

ACCESS_TYP 1

  • Open Access · 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
4216 4216 4215 {"type": "Polygon", "coordinates": [[[-121.73259, 37.22017], [-121.73143, 37.22093], [-121.72923, 37.21986], [-121.72855, 37.22034], [-121.7301, 37.22181], [-121.72757, 37.22352], [-121.72235, 37.21797], [-121.72234, 37.21764], [-121.72303, 37.21652], [-121.72322, 37.21628], [-121.72358, 37.216], [-121.72375, 37.21606], [-121.72395, 37.2161], [-121.7243, 37.21612], [-121.72465, 37.21607], [-121.72527, 37.21585], [-121.72548, 37.21581], [-121.72587, 37.2158], [-121.72777, 37.21584], [-121.72836, 37.2165], [-121.72909, 37.2166], [-121.72922, 37.21707], [-121.7297, 37.21715], [-121.73005, 37.21745], [-121.73072, 37.21797], [-121.73086, 37.21812], [-121.73099, 37.21834], [-121.7312, 37.21906], [-121.73123, 37.21913], [-121.73145, 37.21942], [-121.73174, 37.21963], [-121.73259, 37.22017]]]} Open Access 1 Field Sports Park   18891 326 Santa Clara County Parks and Recreation Dept., County of 465 County 3 County Agency - Parks 7 http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx County 3 102.244 Field Sports 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]);