units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 2, GAP_STS = 2 and MNG_AGENCY = 593

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • American River Conservancy · 2 ✖

ACCESS_TYP 1

  • Restricted 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
4416 4416 4415 {"type": "MultiPolygon", "coordinates": [[[[-120.90814, 38.57014], [-120.88983, 38.57064], [-120.88467, 38.57039], [-120.87584, 38.57006], [-120.87151, 38.56993], [-120.8715, 38.56994], [-120.86697, 38.56993], [-120.86692, 38.56986], [-120.8621, 38.56961], [-120.86253, 38.55815], [-120.85319, 38.55806], [-120.85317, 38.56585], [-120.84869, 38.5658], [-120.84867, 38.56178], [-120.84703, 38.56175], [-120.84722, 38.56109], [-120.84747, 38.56052], [-120.84786, 38.55986], [-120.84785, 38.55864], [-120.84776, 38.55795], [-120.84741, 38.55706], [-120.84716, 38.55637], [-120.84716, 38.55602], [-120.84747, 38.55538], [-120.8479, 38.55469], [-120.84815, 38.55447], [-120.85319, 38.55445], [-120.85298, 38.55034], [-120.85383, 38.55007], [-120.85469, 38.54965], [-120.8556, 38.54902], [-120.85593, 38.54876], [-120.85622, 38.54844], [-120.85654, 38.54799], [-120.85673, 38.54759], [-120.85682, 38.54727], [-120.86255, 38.54729], [-120.86253, 38.54355], [-120.86193, 38.54352], [-120.8622, 38.54343], [-120.8624, 38.54325], [-120.86258, 38.54305], [-120.86265, 38.54278], [-120.86275, 38.54246], [-120.86278, 38.54217], [-120.86285, 38.54182], [-120.86295, 38.54149], [-120.86296, 38.54115], [-120.86303, 38.54057], [-120.86312, 38.54032], [-120.8632, 38.54004], [-120.8632, 38.53983], [-120.86315, 38.53957], [-120.86318, 38.53931], [-120.86318, 38.53903], [-120.86315, 38.53865], [-120.86303, 38.53826], [-120.86299, 38.53795], [-120.86305, 38.53755], [-120.86304, 38.53735], [-120.86308, 38.53705], [-120.86308, 38.53681], [-120.86312, 38.53663], [-120.87136, 38.53664], [-120.87142, 38.54103], [-120.87181, 38.55451], [-120.88584, 38.55578], [-120.88549, 38.55967], [-120.89525, 38.55995], [-120.89521, 38.56332], [-120.8996, 38.56317], [-120.9078, 38.56279], [-120.90814, 38.57014]]], [[[-120.86073, 38.54359], [-120.85581, 38.5436], [-120.85581, 38.5436], [-120.85591, 38.5434], [-120.85607, 38.54316], [-120.85627, 38.54297], [-120.8565, 38.54279], [-120.85668, 38.54269], [-120.85716, 38.54254], [-120.8574, 38.54244], [-120.85763, 38.54239], [-120.85782, 38.54241], [-120.85828, 38.54248], [-120.85862, 38.54256], [-120.85924, 38.54276], [-120.85942, 38.54276], [-120.85951, 38.5429], [-120.85966, 38.543], [-120.85987, 38.5431], [-120.86022, 38.5432], [-120.86038, 38.54328], [-120.86073, 38.54359]]]]} Restricted Access 2 47296 El Dorado Ranch 31004 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 2066.338 El Dorado Ranch 0 Private Conservation 16 2
15281 15281 15280 {"type": "MultiPolygon", "coordinates": [[[[-120.86261, 38.53701], [-120.86257, 38.53794], [-120.86264, 38.5384], [-120.86251, 38.53943], [-120.86255, 38.53979], [-120.86253, 38.54056], [-120.86247, 38.54133], [-120.86227, 38.54212], [-120.86232, 38.54264], [-120.86183, 38.54323], [-120.86116, 38.54345], [-120.86029, 38.54304], [-120.85959, 38.54261], [-120.8578, 38.54218], [-120.85666, 38.54224], [-120.85572, 38.54279], [-120.8553, 38.54346], [-120.8552, 38.54393], [-120.85244, 38.54392], [-120.8524, 38.54218], [-120.85217, 38.54078], [-120.86208, 38.54056], [-120.86202, 38.53698], [-120.86261, 38.53701]]], [[[-120.85667, 38.54735], [-120.85662, 38.54767], [-120.85595, 38.54814], [-120.85555, 38.54854], [-120.8547, 38.54903], [-120.8538, 38.54953], [-120.85255, 38.55006], [-120.8525, 38.54733], [-120.85667, 38.54735]]]]} Restricted Access 2 47297 El Dorado Ranch 31004 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   Amador 52 78.399 El Dorado 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]);