units_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, DES_TP = 16 and LABEL_NAME = "Brush Creek Ranch"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Private Conservation · 1 ✖

ACCESS_TYP 1

  • No Public 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
3903 3903 3902 {"type": "Polygon", "coordinates": [[[-121.03542, 38.78141], [-121.03507, 38.78183], [-121.0346, 38.78212], [-121.03407, 38.78232], [-121.03329, 38.78251], [-121.03294, 38.78277], [-121.03281, 38.78309], [-121.03251, 38.78343], [-121.03212, 38.78352], [-121.03173, 38.78352], [-121.03122, 38.78337], [-121.0308, 38.78336], [-121.03049, 38.78342], [-121.03022, 38.78367], [-121.02605, 38.7837], [-121.02584, 38.77615], [-121.02577, 38.77476], [-121.02639, 38.77374], [-121.02717, 38.77352], [-121.03037, 38.77412], [-121.0309, 38.77359], [-121.03129, 38.77362], [-121.03139, 38.7737], [-121.03083, 38.77451], [-121.03091, 38.77531], [-121.03245, 38.77575], [-121.03465, 38.7743], [-121.03466, 38.77614], [-121.02705, 38.77614], [-121.02704, 38.77615], [-121.03315, 38.77619], [-121.03315, 38.77636], [-121.03329, 38.77676], [-121.03362, 38.77707], [-121.03421, 38.77714], [-121.03468, 38.77725], [-121.03503, 38.77769], [-121.03515, 38.77801], [-121.03498, 38.77838], [-121.03517, 38.77907], [-121.03541, 38.77968], [-121.03542, 38.78141]]]} No Public Access 3 36005 Brush Creek Ranch 16454 3003 American River Conservancy 604 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10   El Dorado 34 188.734 Brush Creek Ranch 0 Private Conservation 16 2

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