units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, DES_TP = 1181, MNG_AGENCY = 128 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open 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
13738 13738 13737 {"type": "Polygon", "coordinates": [[[-120.73667, 39.47016], [-120.73657, 39.47755], [-120.73196, 39.47752], [-120.73198, 39.48087], [-120.72711, 39.48102], [-120.72718, 39.48469], [-120.71771, 39.48463], [-120.7177, 39.49196], [-120.70865, 39.49214], [-120.70863, 39.49212], [-120.70882, 39.49178], [-120.70902, 39.4913], [-120.70912, 39.49113], [-120.70917, 39.49097], [-120.70929, 39.49081], [-120.70943, 39.49075], [-120.70989, 39.49065], [-120.71016, 39.49061], [-120.71064, 39.49068], [-120.71091, 39.49069], [-120.71122, 39.49065], [-120.71147, 39.49057], [-120.71164, 39.49046], [-120.71209, 39.49036], [-120.71225, 39.49019], [-120.71234, 39.48997], [-120.71239, 39.48977], [-120.71244, 39.48947], [-120.71253, 39.48925], [-120.71269, 39.48915], [-120.71298, 39.48912], [-120.71314, 39.48915], [-120.71338, 39.48923], [-120.71365, 39.4893], [-120.71392, 39.48935], [-120.71436, 39.48936], [-120.71476, 39.48932], [-120.71496, 39.48924], [-120.71527, 39.48928], [-120.71557, 39.48935], [-120.71584, 39.4894], [-120.71611, 39.48939], [-120.71629, 39.48932], [-120.71662, 39.48934], [-120.71683, 39.48934], [-120.71696, 39.48928], [-120.71714, 39.48907], [-120.71714, 39.48881], [-120.71702, 39.48861], [-120.71686, 39.48842], [-120.71684, 39.48799], [-120.71669, 39.4878], [-120.71645, 39.48759], [-120.71633, 39.48739], [-120.71626, 39.48713], [-120.71631, 39.48674], [-120.71625, 39.48657], [-120.71522, 39.48607], [-120.71507, 39.48595], [-120.71503, 39.48582], [-120.71503, 39.48565], [-120.71507, 39.48543], [-120.71518, 39.48516], [-120.71518, 39.48491], [-120.71506, 39.48448], [-120.71469, 39.48396], [-120.71459, 39.48379], [-120.71418, 39.48348], [-120.71379, 39.48317], [-120.71369, 39.48301], [-120.71382, 39.48274], [-120.71396, 39.48257], [-120.71423, 39.48206], [-120.71437, 39.48184], [-120.71504, 39.48126], [-120.71528, 39.48112], [-120.71539, 39.48111], [-120.71585, 39.48096], [-120.71598, 39.48089], [-120.71616, 39.48074], [-120.71628, 39.48054], [-120.7165, 39.48037], [-120.71702, 39.48002], [-120.71729, 39.4799], [-120.71785, 39.47963], [-120.71859, 39.47937], [-120.71888, 39.47923], [-120.71904, 39.47907], [-120.71934, 39.47886], [-120.71958, 39.47875], [-120.7199, 39.47853], [-120.72018, 39.47839], [-120.72036, 39.47822], [-120.7206, 39.47792], [-120.72105, 39.47745], [-120.72157, 39.47687], [-120.72185, 39.4766], [-120.72236, 39.47622], [-120.72293, 39.4757], [-120.72376, 39.47521], [-120.72404, 39.475], [-120.72434, 39.47473], [-120.72459, 39.47439], [-120.72484, 39.47399], [-120.72523, 39.47327], [-120.72546, 39.47295], [-120.72562, 39.47283], [-120.7261, 39.47262], [-120.72634, 39.47248], [-120.72651, 39.47235], [-120.72713, 39.47198], [-120.72754, 39.47184], [-120.7279, 39.47168], [-120.7283, 39.47154], [-120.7288, 39.47127], [-120.72948, 39.47101], [-120.72964, 39.47099], [-120.72991, 39.47104], [-120.73014, 39.47115], [-120.73043, 39.47123], [-120.73063, 39.47123], [-120.73087, 39.47114], [-120.73112, 39.47073], [-120.73146, 39.47029], [-120.73205, 39.4699], [-120.73229, 39.46983], [-120.73256, 39.46986], [-120.73285, 39.46985], [-120.73315, 39.46982], [-120.73346, 39.46975], [-120.73384, 39.46976], [-120.73421, 39.4698], [-120.73502, 39.46992], [-120.73616, 39.47012], [-120.73663, 39.47013], [-120.73667, 39.47016]]]} Open Access 1 36232 Other State 27 8209 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5 http://asi.ucdavis.edu/rr Sierra 58 481.401 Other State 27   None 1181  

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