units_with_maps

Table actions

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

2 rows where COUNTY = 48 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

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
16834 16834 16833 {"type": "Polygon", "coordinates": [[[-119.9027, 37.22836], [-119.90274, 37.22877], [-119.90272, 37.22927], [-119.90266, 37.22968], [-119.90248, 37.23018], [-119.9021, 37.23082], [-119.90181, 37.23124], [-119.9015, 37.23159], [-119.90102, 37.23201], [-119.90008, 37.2326], [-119.89985, 37.23279], [-119.89973, 37.23295], [-119.89961, 37.23347], [-119.89943, 37.23413], [-119.89898, 37.2347], [-119.89853, 37.23526], [-119.89787, 37.23589], [-119.89667, 37.23681], [-119.8961, 37.23705], [-119.89555, 37.23721], [-119.89432, 37.2372], [-119.89379, 37.23705], [-119.89303, 37.23669], [-119.89233, 37.23613], [-119.89202, 37.23595], [-119.89153, 37.23577], [-119.89115, 37.23556], [-119.89085, 37.23549], [-119.8906, 37.23546], [-119.89015, 37.23545], [-119.88983, 37.23546], [-119.88925, 37.23573], [-119.88862, 37.23611], [-119.88862, 37.23476], [-119.88945, 37.23437], [-119.89016, 37.23435], [-119.89074, 37.23437], [-119.89115, 37.23442], [-119.89175, 37.23456], [-119.8922, 37.23481], [-119.89273, 37.235], [-119.89323, 37.23531], [-119.89388, 37.23582], [-119.89438, 37.23605], [-119.89457, 37.23611], [-119.89531, 37.23611], [-119.89554, 37.23604], [-119.89585, 37.23591], [-119.89687, 37.23514], [-119.89742, 37.23461], [-119.89813, 37.23372], [-119.89826, 37.23325], [-119.89842, 37.23256], [-119.89874, 37.23213], [-119.89915, 37.23179], [-119.90008, 37.2312], [-119.90042, 37.2309], [-119.90064, 37.23066], [-119.90087, 37.23032], [-119.90119, 37.22978], [-119.90131, 37.22946], [-119.90135, 37.22919], [-119.90137, 37.22879], [-119.90132, 37.22836], [-119.9027, 37.22836]]]} Open Access 1 44771 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   Madera 48 55.076 SLC 0 State Resource Management Area 55 3
16840 16840 16839 {"type": "MultiPolygon", "coordinates": [[[[-119.76601, 36.91962], [-119.7636, 36.92003], [-119.76289, 36.9203], [-119.76261, 36.91997], [-119.76318, 36.91981], [-119.76576, 36.919], [-119.76601, 36.91962]]], [[[-119.76278, 36.92035], [-119.76224, 36.92064], [-119.75912, 36.92058], [-119.75532, 36.92228], [-119.75435, 36.92355], [-119.75383, 36.9233], [-119.75406, 36.92285], [-119.75457, 36.92223], [-119.7565, 36.92094], [-119.7579, 36.92044], [-119.75879, 36.92034], [-119.7601, 36.91999], [-119.76219, 36.92011], [-119.76246, 36.92003], [-119.76278, 36.92035]]], [[[-119.7554, 36.93223], [-119.7545, 36.93259], [-119.75399, 36.93406], [-119.75335, 36.93405], [-119.75361, 36.93256], [-119.75229, 36.93156], [-119.75185, 36.9301], [-119.75138, 36.92834], [-119.75133, 36.92752], [-119.75223, 36.92685], [-119.75258, 36.92621], [-119.75267, 36.92492], [-119.75326, 36.92447], [-119.75379, 36.9234], [-119.75425, 36.92364], [-119.75347, 36.9264], [-119.75359, 36.92689], [-119.75403, 36.92733], [-119.75444, 36.92871], [-119.75448, 36.92903], [-119.75459, 36.92926], [-119.755, 36.92976], [-119.75507, 36.93094], [-119.7554, 36.93223]]]]} Open Access 1 16689 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   Madera 48 65.906 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]);