units_with_maps

Table actions

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

1 row where AGNCY_NAME = 131 and DES_TP = 1106

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
12700 12700 12699 {"type": "Polygon", "coordinates": [[[-121.70792, 36.18525], [-121.70782, 36.18527], [-121.70773, 36.18527], [-121.70765, 36.18534], [-121.70756, 36.1854], [-121.70751, 36.18548], [-121.70751, 36.18555], [-121.70756, 36.18566], [-121.70457, 36.18563], [-121.70453, 36.18564], [-121.70292, 36.18562], [-121.70183, 36.18486], [-121.70168, 36.1847], [-121.7007, 36.18328], [-121.70058, 36.18314], [-121.70035, 36.18295], [-121.70016, 36.18274], [-121.70003, 36.18252], [-121.69994, 36.18233], [-121.69989, 36.18215], [-121.69986, 36.1817], [-121.69979, 36.18118], [-121.69979, 36.1809], [-121.69984, 36.18059], [-121.69983, 36.18044], [-121.69979, 36.18023], [-121.69966, 36.17997], [-121.6996, 36.17833], [-121.70009, 36.17832], [-121.70016, 36.17845], [-121.70054, 36.17861], [-121.70073, 36.17858], [-121.70082, 36.17857], [-121.70101, 36.17861], [-121.7011, 36.17861], [-121.70114, 36.17869], [-121.70116, 36.17875], [-121.70115, 36.17885], [-121.70117, 36.17893], [-121.70129, 36.17908], [-121.70131, 36.17916], [-121.7014, 36.17926], [-121.70141, 36.17948], [-121.70144, 36.17956], [-121.70141, 36.17979], [-121.70146, 36.18004], [-121.70149, 36.18011], [-121.70156, 36.18019], [-121.70157, 36.18026], [-121.70158, 36.18034], [-121.70154, 36.18041], [-121.70137, 36.18057], [-121.70136, 36.18081], [-121.7013, 36.18089], [-121.70131, 36.18105], [-121.70133, 36.18112], [-121.70143, 36.1812], [-121.70145, 36.18127], [-121.70152, 36.18135], [-121.70161, 36.18141], [-121.7017, 36.1815], [-121.70202, 36.18164], [-121.70208, 36.18171], [-121.70214, 36.18176], [-121.70218, 36.18183], [-121.70239, 36.18199], [-121.70242, 36.18208], [-121.7025, 36.18215], [-121.7027, 36.18218], [-121.70281, 36.18224], [-121.7031, 36.18247], [-121.70321, 36.18248], [-121.70333, 36.18254], [-121.70343, 36.18262], [-121.70362, 36.18266], [-121.70372, 36.1825], [-121.70381, 36.18247], [-121.70392, 36.18249], [-121.70402, 36.18254], [-121.70411, 36.18261], [-121.7041, 36.1827], [-121.70393, 36.18285], [-121.70395, 36.18292], [-121.70402, 36.183], [-121.70411, 36.18307], [-121.70432, 36.18314], [-121.70439, 36.18321], [-121.70443, 36.18339], [-121.70454, 36.18345], [-121.7048, 36.18375], [-121.70489, 36.18381], [-121.70499, 36.18384], [-121.70517, 36.18398], [-121.70548, 36.18407], [-121.70585, 36.18444], [-121.70588, 36.18451], [-121.70611, 36.1846], [-121.70621, 36.18467], [-121.70629, 36.18482], [-121.70638, 36.18489], [-121.70648, 36.18492], [-121.70674, 36.18505], [-121.70704, 36.18505], [-121.70713, 36.18509], [-121.70714, 36.18517], [-121.70726, 36.18524], [-121.70735, 36.18527], [-121.70746, 36.18524], [-121.70752, 36.18507], [-121.70761, 36.18505], [-121.70783, 36.1851], [-121.7079, 36.18517], [-121.70792, 36.18525]]]} Open Access 1 29690 State of California 8231 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Monterey 14 51.268 State of California   None 1106  

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