units_with_maps

Table actions

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

2 rows where COUNTY = 22, DES_TP = 49 and MNG_AG_LEV = 1

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Recreation 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
6482 6482 6481 {"type": "Polygon", "coordinates": [[[-117.49208, 34.25165], [-117.49191, 34.25249], [-117.49152, 34.25285], [-117.49137, 34.25324], [-117.49132, 34.25361], [-117.49123, 34.25396], [-117.49105, 34.25424], [-117.49036, 34.25487], [-117.4893, 34.25482], [-117.48921, 34.25572], [-117.48903, 34.25595], [-117.48918, 34.25659], [-117.48857, 34.25675], [-117.48821, 34.25693], [-117.48831, 34.25044], [-117.48889, 34.25065], [-117.48902, 34.25061], [-117.48981, 34.25022], [-117.49014, 34.24998], [-117.49082, 34.249], [-117.49174, 34.24937], [-117.49085, 34.25064], [-117.49156, 34.25086], [-117.49165, 34.25102], [-117.49152, 34.25158], [-117.49208, 34.25165]], [[-117.49013, 34.25218], [-117.48925, 34.25195], [-117.48893, 34.25197], [-117.48878, 34.25203], [-117.48864, 34.25212], [-117.48854, 34.25234], [-117.4886, 34.25252], [-117.48868, 34.25264], [-117.48886, 34.25268], [-117.49103, 34.25281], [-117.49118, 34.2523], [-117.49087, 34.25222], [-117.49059, 34.25219], [-117.49013, 34.25218]], [[-117.49121, 34.25106], [-117.491, 34.25096], [-117.49079, 34.25096], [-117.49009, 34.25081], [-117.48986, 34.25081], [-117.48975, 34.25092], [-117.48964, 34.2511], [-117.48964, 34.25126], [-117.48972, 34.25137], [-117.48993, 34.25146], [-117.49091, 34.25163], [-117.49119, 34.25161], [-117.49123, 34.25158], [-117.49126, 34.25121], [-117.49121, 34.25106]]]} Open Access 1 2304 Applewhite Campground 15543 107 United States Forest Service 38 Federal 1 Federal Agency 1 http://www.fs.fed.us/ US Forest Service 7 107 United States Forest Service 37 Federal 1 Federal Agency 1   San Bernardino 22 36.645 Applewhite Campground 0 Recreation Management Area 49 4
12084 12084 12083 {"type": "Polygon", "coordinates": [[[-117.24699, 34.22787], [-117.24641, 34.2278], [-117.24625, 34.22776], [-117.24604, 34.22767], [-117.24588, 34.22753], [-117.24579, 34.22741], [-117.24574, 34.2273], [-117.24558, 34.22653], [-117.24552, 34.22637], [-117.24544, 34.22621], [-117.24695, 34.22622], [-117.24699, 34.22787]]]} Open Access 1 24892 Baylis Park Picnic Area 15888 107 United States Forest Service 38 Federal 1 Federal Agency 1 http://www.fs.fed.us/ US Forest Service 7 107 United States Forest Service 37 Federal 1 Federal Agency 1   San Bernardino 22 5.039 Baylis Park Picnic Area 0 Recreation Management Area 49 4

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