units_with_maps

Table actions

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

2 rows where COUNTY = 18 and MNG_AGENCY = 73

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • California State Lands Commission · 2 ✖
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
4153 4153 4152 {"type": "Polygon", "coordinates": [[[-122.83779, 40.22768], [-122.83774, 40.24195], [-122.81931, 40.24226], [-122.81888, 40.22865], [-122.83779, 40.22768]]]} Unknown Access 4 44717 California State Lands Commission 16726 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   Tehama 18 608.074 SLC 0 State Resource Management Area 55 3
16877 16877 16876 {"type": "MultiPolygon", "coordinates": [[[[-121.64937, 40.28726], [-121.63055, 40.28689], [-121.63, 40.2729], [-121.64891, 40.27295], [-121.64937, 40.28726]]], [[[-121.65267, 40.10025], [-121.65256, 40.10793], [-121.63372, 40.10847], [-121.63388, 40.10133], [-121.65267, 40.10025]]], [[[-121.76334, 40.1103], [-121.75869, 40.11031], [-121.75863, 40.10674], [-121.76329, 40.10673], [-121.76334, 40.1103]]], [[[-121.78663, 40.43028], [-121.78661, 40.43389], [-121.78185, 40.43388], [-121.78186, 40.43026], [-121.78663, 40.43028]]], [[[-121.99011, 40.37407], [-121.97106, 40.37409], [-121.97033, 40.35972], [-121.98967, 40.35963], [-121.99011, 40.37407]]], [[[-122.18313, 40.34405], [-122.18313, 40.34431], [-122.1828, 40.34501], [-122.18234, 40.34564], [-122.18213, 40.34641], [-122.18184, 40.34778], [-122.18159, 40.34878], [-122.18135, 40.34954], [-122.18079, 40.35056], [-122.18028, 40.35111], [-122.17949, 40.35142], [-122.1785, 40.35172], [-122.17745, 40.35254], [-122.17681, 40.35294], [-122.177, 40.35189], [-122.17733, 40.35067], [-122.17741, 40.34924], [-122.17771, 40.34692], [-122.17834, 40.34563], [-122.17891, 40.34518], [-122.17982, 40.34472], [-122.18181, 40.34406], [-122.18264, 40.34399], [-122.18313, 40.34405]]], [[[-122.21038, 40.33559], [-122.2104, 40.33686], [-122.2103, 40.33725], [-122.20943, 40.33978], [-122.20937, 40.34033], [-122.20924, 40.34059], [-122.20866, 40.341], [-122.20784, 40.3421], [-122.20754, 40.34265], [-122.207, 40.34311], [-122.20655, 40.34339], [-122.206, 40.34356], [-122.20514, 40.34376], [-122.20456, 40.34351], [-122.20393, 40.34333], [-122.20358, 40.34331], [-122.20318, 40.34345], [-122.20272, 40.34392], [-122.20243, 40.34392], [-122.2018, 40.34368], [-122.20211, 40.34349], [-122.20211, 40.34348], [-122.2015, 40.34325], [-122.20236, 40.34293], [-122.20301, 40.34284], [-122.20309, 40.34297], [-122.20449, 40.34219], [-122.20497, 40.34184], [-122.20504, 40.34149], [-122.20588, 40.34041], [-122.20676, 40.3395], [-122.20798, 40.33809], [-122.20891, 40.33724], [-122.20929, 40.33666], [-122.21038, 40.33559]]], [[[-122.61045, 39.98004], [-122.60584, 39.98015], [-122.60581, 39.98744], [-122.59671, 39.98763], [-122.59659, 39.98037], [-122.60122, 39.98026], [-122.60119, 39.97303], [-122.61044, 39.97294], [-122.61045, 39.98004]]], [[[-122.66576, 40.0299], [-122.64688, 40.03072], [-122.64722, 40.0165], [-122.66545, 40.01534], [-122.66576, 40.0299]]], [[[-122.76542, 40.05505], [-122.76073, 40.05505], [-122.76073, 40.05148], [-122.76541, 40.05147], [-122.76542, 40.05505]]], [[[-122.77482, 40.05504], [-122.77012, 40.05504], [-122.77011, 40.05147], [-122.77481, 40.05147], [-122.77482, 40.05504]]], [[[-122.9503, 40.15105], [-122.93164, 40.15138], [-122.93159, 40.13814], [-122.95027, 40.13752], [-122.9503, 40.15105]]]]} Open Access 1 23157 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   Tehama 18 3389.103 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]);