units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 1, COUNTY = 28 and DES_TP = 55

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

DES_TP 1

  • State Resource Management Area · 3 ✖

ACCESS_TYP 1

  • Open Access · 3 ✖
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
11242 11242 11241 {"type": "MultiPolygon", "coordinates": [[[[-122.26313, 41.6087], [-122.263, 41.62322], [-122.244, 41.6232], [-122.24399, 41.62302], [-122.2437, 41.62303], [-122.24374, 41.60872], [-122.26313, 41.6087]]], [[[-122.7345, 41.87651], [-122.73344, 41.8872], [-122.72901, 41.88721], [-122.72948, 41.88009], [-122.72483, 41.88007], [-122.72456, 41.88722], [-122.72009, 41.88722], [-122.7202, 41.87272], [-122.72509, 41.87276], [-122.72997, 41.87283], [-122.72973, 41.87646], [-122.7345, 41.87651]]], [[[-123.01096, 41.33145], [-123.01076, 41.3351], [-123.00557, 41.33523], [-123.00561, 41.33157], [-123.01096, 41.33145]]], [[[-123.08699, 41.20564], [-123.07726, 41.20574], [-123.07748, 41.20213], [-123.08229, 41.20201], [-123.08234, 41.19849], [-123.08692, 41.19841], [-123.08699, 41.20564]]], [[[-123.23721, 41.40186], [-123.23716, 41.40911], [-123.23243, 41.40908], [-123.23246, 41.40187], [-123.23721, 41.40186]]]]} Open Access 1 21645 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   Siskiyou 28 1229.602 SLC 0 State Resource Management Area 55 3
16869 16869 16868 {"type": "MultiPolygon", "coordinates": [[[[-121.80463, 41.52062], [-121.80457, 41.53152], [-121.79967, 41.53154], [-121.79976, 41.5206], [-121.80463, 41.52062]]], [[[-122.05397, 41.95202], [-122.05393, 41.95558], [-122.0491, 41.95564], [-122.04913, 41.95206], [-122.05397, 41.95202]]], [[[-122.29062, 41.35254], [-122.28926, 41.35254], [-122.28578, 41.35187], [-122.28578, 41.35109], [-122.29062, 41.35203], [-122.29062, 41.35254]]], [[[-122.31147, 41.65609], [-122.31143, 41.66351], [-122.30659, 41.66351], [-122.30662, 41.65593], [-122.31147, 41.65609]]], [[[-122.60156, 41.79319], [-122.6014, 41.79493], [-122.60121, 41.79669], [-122.59643, 41.79669], [-122.59673, 41.79316], [-122.60156, 41.79319]]], [[[-122.60748, 41.78608], [-122.60728, 41.78787], [-122.60469, 41.78785], [-122.60488, 41.78609], [-122.60748, 41.78608]]], [[[-122.65645, 41.74349], [-122.65358, 41.74347], [-122.65355, 41.74344], [-122.65353, 41.74201], [-122.65374, 41.74206], [-122.65389, 41.74155], [-122.65554, 41.7416], [-122.65559, 41.74155], [-122.65573, 41.74155], [-122.6557, 41.7416], [-122.6559, 41.74217], [-122.65645, 41.74349]]], [[[-123.27162, 41.26636], [-123.27159, 41.27003], [-123.26708, 41.27003], [-123.26717, 41.26635], [-123.27162, 41.26636]]]]} Open Access 1 44760 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   Siskiyou 28 350.629 SLC 0 State Resource Management Area 55 3
16880 16880 16879 {"type": "MultiPolygon", "coordinates": [[[[-122.60218, 41.62156], [-122.60209, 41.62517], [-122.59735, 41.62525], [-122.59742, 41.62172], [-122.60218, 41.62156]]], [[[-122.61167, 41.61024], [-122.61157, 41.61766], [-122.60237, 41.61794], [-122.60228, 41.61055], [-122.61167, 41.61024]]], [[[-122.67244, 41.57781], [-122.66285, 41.57775], [-122.66278, 41.57415], [-122.65795, 41.57412], [-122.6578, 41.57051], [-122.67231, 41.5706], [-122.67244, 41.57781]]], [[[-122.66953, 41.66923], [-122.66481, 41.66926], [-122.66449, 41.66176], [-122.66922, 41.66168], [-122.66953, 41.66923]]]]} Open Access 1 44759 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   Siskiyou 28 475.994 SLC 0 State Resource Management Area 55 3

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