units_with_maps

Table actions

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

1 row where DES_TP = 120, LAYER = 2 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

DES_TP 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
1420 1420 1419 {"type": "Polygon", "coordinates": [[[-121.87631, 37.40276], [-121.87599, 37.40296], [-121.87594, 37.40287], [-121.87584, 37.40275], [-121.87572, 37.40268], [-121.87554, 37.4026], [-121.87545, 37.40254], [-121.87456, 37.40155], [-121.87443, 37.40145], [-121.87422, 37.40134], [-121.87407, 37.40129], [-121.87384, 37.40126], [-121.87369, 37.40126], [-121.87353, 37.40129], [-121.87332, 37.40137], [-121.87154, 37.40238], [-121.87135, 37.40245], [-121.87107, 37.40248], [-121.87083, 37.40256], [-121.87028, 37.40286], [-121.87021, 37.40285], [-121.86956, 37.40213], [-121.8695, 37.40209], [-121.86942, 37.40207], [-121.86929, 37.40208], [-121.86659, 37.40363], [-121.86648, 37.40364], [-121.86643, 37.40363], [-121.86638, 37.40358], [-121.86565, 37.4026], [-121.86496, 37.4016], [-121.86511, 37.40159], [-121.86516, 37.40165], [-121.86521, 37.40167], [-121.86528, 37.40166], [-121.86534, 37.40161], [-121.86534, 37.40154], [-121.86538, 37.4015], [-121.86584, 37.40127], [-121.8659, 37.40127], [-121.86596, 37.40131], [-121.86627, 37.40174], [-121.86641, 37.40187], [-121.86649, 37.40191], [-121.86665, 37.40199], [-121.8668, 37.40203], [-121.86696, 37.40206], [-121.8672, 37.40205], [-121.86743, 37.402], [-121.86766, 37.40189], [-121.86873, 37.40129], [-121.86887, 37.40123], [-121.86914, 37.40118], [-121.86929, 37.40114], [-121.8699, 37.4008], [-121.86996, 37.40082], [-121.87035, 37.40125], [-121.87054, 37.40138], [-121.87068, 37.40144], [-121.87092, 37.4015], [-121.87108, 37.40151], [-121.87124, 37.4015], [-121.8714, 37.40146], [-121.87162, 37.40137], [-121.87371, 37.40016], [-121.87375, 37.40013], [-121.87377, 37.40008], [-121.87386, 37.40009], [-121.87423, 37.39987], [-121.87494, 37.40039], [-121.87514, 37.40056], [-121.87531, 37.40075], [-121.87546, 37.40095], [-121.8757, 37.40137], [-121.87631, 37.40276]]]} Open Access 1 9047 Cataldi 16968 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 32.695 Cataldi 1980 None 120  

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