units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, AGNCY_TYP = 5, COUNTY = 57 and DES_TP = 55

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • State Resource Management Area · 2 ✖

ACCESS_TYP 1

  • Open Access · 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
16862 16862 16861 {"type": "Polygon", "coordinates": [[[-121.36711, 40.14473], [-121.3671, 40.15548], [-121.36417, 40.15546], [-121.36414, 40.14476], [-121.36711, 40.14473]]]} Open Access 1 44773 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   Plumas 57 73.975 SLC 0 State Resource Management Area 55 3
16873 16873 16872 {"type": "MultiPolygon", "coordinates": [[[[-120.19286, 39.76602], [-120.18412, 39.76597], [-120.18402, 39.75865], [-120.1839, 39.75864], [-120.18377, 39.75498], [-120.18396, 39.75497], [-120.18394, 39.75146], [-120.19224, 39.75165], [-120.19286, 39.76602]]], [[[-120.24693, 40.05614], [-120.24693, 40.07141], [-120.23757, 40.07119], [-120.23756, 40.06745], [-120.23704, 40.06744], [-120.23703, 40.06739], [-120.23288, 40.06738], [-120.23282, 40.05627], [-120.24693, 40.05614]]], [[[-120.31429, 40.01439], [-120.31418, 40.026], [-120.31414, 40.02872], [-120.29528, 40.02864], [-120.29535, 40.01424], [-120.29637, 40.01423], [-120.31429, 40.01439]]], [[[-120.38038, 39.75937], [-120.38029, 39.76305], [-120.37627, 39.76299], [-120.37625, 39.75933], [-120.38038, 39.75937]]], [[[-120.42813, 40.01805], [-120.428, 40.02895], [-120.40899, 40.02889], [-120.40911, 40.02158], [-120.4138, 40.0216], [-120.41385, 40.02158], [-120.4139, 40.01793], [-120.40918, 40.01793], [-120.40925, 40.0143], [-120.41873, 40.01428], [-120.42344, 40.01432], [-120.42339, 40.01793], [-120.42344, 40.01794], [-120.42345, 40.01803], [-120.42813, 40.01805]]], [[[-120.42788, 39.75977], [-120.42772, 39.76701], [-120.41794, 39.76673], [-120.41796, 39.75959], [-120.42788, 39.75977]]], [[[-120.64091, 40.0294], [-120.627, 40.0295], [-120.62685, 40.02233], [-120.63166, 40.02237], [-120.6317, 40.0258], [-120.63171, 40.02581], [-120.63617, 40.02569], [-120.6363, 40.02229], [-120.64089, 40.02235], [-120.64091, 40.0294]]], [[[-120.98044, 39.77528], [-120.97077, 39.77516], [-120.9708, 39.76396], [-120.97548, 39.76397], [-120.97547, 39.76758], [-120.98042, 39.76749], [-120.98044, 39.77528]]], [[[-121.04544, 39.8186], [-121.04044, 39.8186], [-121.04046, 39.81457], [-121.03571, 39.81453], [-121.0357, 39.81454], [-121.03569, 39.81861], [-121.0267, 39.81862], [-121.02669, 39.81098], [-121.03598, 39.81099], [-121.03604, 39.80375], [-121.04518, 39.8037], [-121.04544, 39.8186]]], [[[-121.09322, 39.84757], [-121.09313, 39.85463], [-121.08354, 39.85466], [-121.08359, 39.84742], [-121.09322, 39.84757]]], [[[-121.09289, 39.86208], [-121.08784, 39.86203], [-121.08784, 39.85797], [-121.09286, 39.85784], [-121.09289, 39.86208]]]]} Open Access 1 23540 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   Plumas 57 3218.861 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]);