units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, COUNTY = 6 and MNG_AGENCY = 51

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • University of California · 1 ✖

ACCESS_TYP 1

  • Restricted Access · 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
16966 16966 16965 {"type": "MultiPolygon", "coordinates": [[[[-118.65894, 34.09067], [-118.6584, 34.09088], [-118.65818, 34.09092], [-118.65805, 34.09092], [-118.65778, 34.09087], [-118.65727, 34.09065], [-118.65706, 34.09061], [-118.65686, 34.09061], [-118.65631, 34.09068], [-118.65619, 34.09069], [-118.65602, 34.09066], [-118.65581, 34.09059], [-118.65522, 34.0903], [-118.65493, 34.09022], [-118.65474, 34.09019], [-118.65398, 34.09017], [-118.65376, 34.09019], [-118.65358, 34.09024], [-118.65348, 34.0903], [-118.65336, 34.09041], [-118.65325, 34.09056], [-118.65313, 34.09096], [-118.65309, 34.09104], [-118.65302, 34.09112], [-118.65289, 34.09121], [-118.65253, 34.09139], [-118.65237, 34.09152], [-118.65231, 34.09163], [-118.65228, 34.09173], [-118.6523, 34.09208], [-118.65228, 34.09218], [-118.6522, 34.09232], [-118.65216, 34.09236], [-118.65194, 34.09254], [-118.65177, 34.09262], [-118.65153, 34.0927], [-118.65116, 34.09274], [-118.651, 34.09278], [-118.65087, 34.09284], [-118.65059, 34.09306], [-118.65049, 34.0931], [-118.65019, 34.09315], [-118.65005, 34.0932], [-118.64986, 34.09335], [-118.6498, 34.09344], [-118.64966, 34.09372], [-118.64958, 34.0938], [-118.64949, 34.09385], [-118.64932, 34.09388], [-118.64917, 34.09385], [-118.6481, 34.0933], [-118.64793, 34.09325], [-118.64769, 34.09324], [-118.64753, 34.09328], [-118.64741, 34.09334], [-118.64725, 34.09346], [-118.64716, 34.09363], [-118.647, 34.09414], [-118.64698, 34.09424], [-118.64699, 34.09442], [-118.64705, 34.0946], [-118.64709, 34.09469], [-118.6472, 34.09482], [-118.64737, 34.09494], [-118.64751, 34.09501], [-118.64769, 34.09506], [-118.64891, 34.09528], [-118.64914, 34.09531], [-118.64954, 34.09531], [-118.64983, 34.09529], [-118.65032, 34.0952], [-118.6507, 34.09509], [-118.6512, 34.09488], [-118.65135, 34.09484], [-118.65157, 34.09483], [-118.65182, 34.09487], [-118.65203, 34.09496], [-118.65221, 34.0951], [-118.6523, 34.09521], [-118.65235, 34.09529], [-118.65242, 34.09551], [-118.65242, 34.09562], [-118.6524, 34.09574], [-118.65233, 34.09591], [-118.65219, 34.09613], [-118.65214, 34.09627], [-118.65017, 34.09629], [-118.6502, 34.09996], [-118.64111, 34.09994], [-118.64112, 34.09636], [-118.64115, 34.09468], [-118.64116, 34.09265], [-118.65012, 34.09267], [-118.65009, 34.08891], [-118.65894, 34.08891], [-118.65894, 34.09067]]], [[[-118.65894, 34.0962], [-118.65234, 34.09626], [-118.65238, 34.09618], [-118.65252, 34.09596], [-118.65257, 34.09584], [-118.65261, 34.09566], [-118.65261, 34.09546], [-118.65252, 34.0952], [-118.65238, 34.09502], [-118.65227, 34.09491], [-118.65214, 34.09483], [-118.65199, 34.09475], [-118.65187, 34.09471], [-118.6517, 34.09468], [-118.65139, 34.09467], [-118.65111, 34.09473], [-118.65049, 34.09497], [-118.65006, 34.09507], [-118.64959, 34.09513], [-118.64924, 34.09513], [-118.64891, 34.09511], [-118.64773, 34.0949], [-118.64752, 34.09482], [-118.64734, 34.0947], [-118.64723, 34.09454], [-118.64718, 34.09439], [-118.64719, 34.09421], [-118.64735, 34.09366], [-118.6474, 34.09357], [-118.64754, 34.09346], [-118.64774, 34.09341], [-118.64789, 34.09341], [-118.64802, 34.09346], [-118.64909, 34.09401], [-118.64925, 34.09404], [-118.6494, 34.09404], [-118.64962, 34.09397], [-118.64979, 34.09385], [-118.64987, 34.09374], [-118.64998, 34.09349], [-118.65001, 34.09345], [-118.65013, 34.09336], [-118.65023, 34.09332], [-118.65051, 34.09327], [-118.65067, 34.09321], [-118.65103, 34.09295], [-118.6511, 34.09292], [-118.65154, 34.09286], [-118.65179, 34.09279], [-118.65206, 34.09266], [-118.6523, 34.09248], [-118.65242, 34.09233], [-118.65248, 34.09218], [-118.65249, 34.09207], [-118.65247, 34.09175], [-118.65252, 34.09164], [-118.65259, 34.09155], [-118.65303, 34.09132], [-118.65319, 34.09121], [-118.65326, 34.09111], [-118.65333, 34.09099], [-118.65344, 34.09062], [-118.65351, 34.09051], [-118.6536, 34.09044], [-118.65375, 34.09037], [-118.65387, 34.09034], [-118.65469, 34.09035], [-118.65484, 34.09037], [-118.65503, 34.09041], [-118.65517, 34.09046], [-118.65573, 34.09074], [-118.65601, 34.09083], [-118.65612, 34.09085], [-118.65639, 34.09085], [-118.65684, 34.09079], [-118.65706, 34.09078], [-118.65719, 34.09081], [-118.65763, 34.091], [-118.65785, 34.09106], [-118.65802, 34.09108], [-118.65815, 34.09108], [-118.65839, 34.09105], [-118.6584, 34.09173], [-118.65894, 34.09173], [-118.65894, 34.0962]]]]} Restricted Access 2 6444 Stunt Ranch Santa Monica Mountains Reserve 25938 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5   Los Angeles 6 319.623 Stunt Ranch Santa Monica Mtns. Reserve 0 State Conservation Area 8 2

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