units_with_maps

Table actions

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

1 row where DES_TP = 443, MNG_AGENCY = 51 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 1 ✖

MNG_AGENCY 1

  • University of California · 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
5474 5474 5473 {"type": "Polygon", "coordinates": [[[-121.67324, 37.34487], [-121.65922, 37.34495], [-121.65922, 37.34857], [-121.66372, 37.34855], [-121.66372, 37.35228], [-121.65929, 37.35233], [-121.65934, 37.36149], [-121.64126, 37.36174], [-121.62308, 37.36146], [-121.62308, 37.3556], [-121.623, 37.35158], [-121.61845, 37.3516], [-121.61848, 37.33735], [-121.61337, 37.33733], [-121.61349, 37.32832], [-121.62251, 37.32493], [-121.62279, 37.34029], [-121.62316, 37.34029], [-121.62343, 37.34034], [-121.62367, 37.34027], [-121.62389, 37.34015], [-121.62416, 37.33995], [-121.62429, 37.33978], [-121.62453, 37.33972], [-121.62466, 37.33947], [-121.62475, 37.33945], [-121.62485, 37.33939], [-121.62491, 37.33929], [-121.6249, 37.33922], [-121.62485, 37.33912], [-121.62474, 37.33906], [-121.62486, 37.33886], [-121.62501, 37.33867], [-121.62519, 37.33851], [-121.6254, 37.33836], [-121.62562, 37.33823], [-121.62568, 37.33811], [-121.62575, 37.33805], [-121.6258, 37.33803], [-121.62589, 37.33803], [-121.62597, 37.33802], [-121.62608, 37.33796], [-121.62611, 37.33793], [-121.6262, 37.33773], [-121.62629, 37.33762], [-121.62635, 37.33757], [-121.6265, 37.33751], [-121.62658, 37.33745], [-121.62702, 37.33686], [-121.62704, 37.33681], [-121.62704, 37.33672], [-121.62693, 37.33661], [-121.6269, 37.33655], [-121.6269, 37.33649], [-121.62692, 37.33643], [-121.62697, 37.33638], [-121.62703, 37.33634], [-121.62711, 37.33633], [-121.62719, 37.33625], [-121.62728, 37.33612], [-121.62735, 37.33591], [-121.62743, 37.33581], [-121.62754, 37.33572], [-121.62766, 37.33566], [-121.6278, 37.33562], [-121.62792, 37.33563], [-121.628, 37.33562], [-121.62806, 37.33558], [-121.62816, 37.33548], [-121.62828, 37.3354], [-121.62849, 37.33533], [-121.62864, 37.33531], [-121.6288, 37.33531], [-121.62894, 37.33534], [-121.62902, 37.33549], [-121.62905, 37.33551], [-121.62909, 37.33552], [-121.62926, 37.33549], [-121.6293, 37.33551], [-121.62938, 37.3356], [-121.62943, 37.33562], [-121.62948, 37.33561], [-121.62975, 37.33543], [-121.63007, 37.33514], [-121.63026, 37.33492], [-121.6305, 37.33458], [-121.63067, 37.33436], [-121.63087, 37.33416], [-121.6311, 37.33397], [-121.63135, 37.33381], [-121.63169, 37.33362], [-121.63191, 37.33355], [-121.63212, 37.33354], [-121.6323, 37.33348], [-121.63285, 37.33307], [-121.63308, 37.33298], [-121.63382, 37.33275], [-121.63457, 37.33257], [-121.63535, 37.33245], [-121.63586, 37.33241], [-121.63624, 37.33228], [-121.63707, 37.33206], [-121.6377, 37.33181], [-121.63802, 37.33173], [-121.63895, 37.33129], [-121.63945, 37.33099], [-121.6398, 37.33082], [-121.64018, 37.33066], [-121.64056, 37.33054], [-121.64074, 37.33053], [-121.64085, 37.3305], [-121.64099, 37.3304], [-121.64105, 37.33032], [-121.64107, 37.33022], [-121.64115, 37.33015], [-121.6413, 37.33009], [-121.64147, 37.33008], [-121.64162, 37.32998], [-121.64187, 37.32987], [-121.64195, 37.32991], [-121.64208, 37.32992], [-121.64217, 37.3299], [-121.64233, 37.32981], [-121.64244, 37.32978], [-121.64256, 37.32978], [-121.64273, 37.32983], [-121.64294, 37.32999], [-121.64303, 37.33], [-121.64311, 37.32998], [-121.64317, 37.32993], [-121.64319, 37.32978], [-121.64325, 37.3297], [-121.64332, 37.32966], [-121.64352, 37.32959], [-121.64363, 37.32921], [-121.64368, 37.32867], [-121.6438, 37.32825], [-121.64397, 37.32805], [-121.64445, 37.3278], [-121.64474, 37.32761], [-121.64501, 37.3274], [-121.64538, 37.32705], [-121.64559, 37.32679], [-121.66048, 37.32679], [-121.66049, 37.32678], [-121.66047, 37.3257], [-121.67324, 37.34487]]]} Open Access 1 17374 Lick Observatory UCSC 14326 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 http://www.ucolick.org/ Santa Clara 19 3498.51 Lick Observatory UCSC   None 443  

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