units_with_maps

Table actions

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

1 row where AGNCY_LEV = 2 and DES_TP = 896

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 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
10276 10276 10275 {"type": "Polygon", "coordinates": [[[-121.76401, 37.30512], [-121.76374, 37.30507], [-121.763, 37.30477], [-121.76282, 37.30474], [-121.76264, 37.30472], [-121.76246, 37.30474], [-121.76218, 37.30481], [-121.7617, 37.30508], [-121.76132, 37.30521], [-121.76002, 37.3054], [-121.75953, 37.30543], [-121.75927, 37.30523], [-121.75899, 37.30511], [-121.75879, 37.30507], [-121.75805, 37.30495], [-121.75789, 37.30495], [-121.75775, 37.30498], [-121.75767, 37.30502], [-121.7575, 37.30513], [-121.7574, 37.30517], [-121.7573, 37.30518], [-121.75721, 37.30513], [-121.75712, 37.30513], [-121.75706, 37.30517], [-121.75704, 37.30524], [-121.75706, 37.30528], [-121.75711, 37.30531], [-121.75708, 37.30536], [-121.75715, 37.30583], [-121.7572, 37.30588], [-121.75718, 37.30591], [-121.75717, 37.30595], [-121.7572, 37.30601], [-121.75725, 37.30604], [-121.75732, 37.30632], [-121.75735, 37.30655], [-121.75768, 37.30659], [-121.75768, 37.30661], [-121.75767, 37.30666], [-121.75733, 37.30662], [-121.7572, 37.30726], [-121.7569, 37.30716], [-121.75685, 37.3071], [-121.75687, 37.30695], [-121.75681, 37.3067], [-121.75713, 37.30656], [-121.75691, 37.3056], [-121.75691, 37.30546], [-121.75695, 37.30533], [-121.75663, 37.3052], [-121.75665, 37.30515], [-121.75673, 37.30505], [-121.75673, 37.305], [-121.7567, 37.30496], [-121.75664, 37.30492], [-121.7564, 37.30487], [-121.75552, 37.30484], [-121.75539, 37.30486], [-121.7553, 37.30481], [-121.75493, 37.30478], [-121.75474, 37.3039], [-121.75474, 37.30363], [-121.75477, 37.30348], [-121.75481, 37.30331], [-121.75505, 37.30271], [-121.75511, 37.30251], [-121.75513, 37.30235], [-121.75514, 37.30211], [-121.7551, 37.30129], [-121.75512, 37.30112], [-121.75524, 37.30079], [-121.75534, 37.30064], [-121.75563, 37.30032], [-121.75573, 37.30023], [-121.75598, 37.30008], [-121.75612, 37.30002], [-121.75641, 37.29992], [-121.75672, 37.29986], [-121.75723, 37.29981], [-121.75741, 37.29977], [-121.75775, 37.29967], [-121.75791, 37.29961], [-121.75821, 37.29946], [-121.75893, 37.29897], [-121.75918, 37.30004], [-121.75941, 37.30116], [-121.75991, 37.30195], [-121.76075, 37.30315], [-121.76107, 37.3037], [-121.76142, 37.30424], [-121.76366, 37.30353], [-121.76401, 37.30512]]]} Open Access 1 18012 Montgomery Hill 22437 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 75.534 Montgomery Hill 2004 None 896  

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