units_with_maps

Table actions

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

2 rows where DES_TP = 49, LABEL_NAME = "Eastman Lake Rec. Area" and MNG_AG_TYP = 1

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Federal Agency · 2 ✖

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
9834 9834 9833 {"type": "MultiPolygon", "coordinates": [[[[-119.98871, 37.24573], [-119.9876, 37.24574], [-119.98755, 37.24764], [-119.98418, 37.24763], [-119.98418, 37.24862], [-119.97959, 37.2486], [-119.97958, 37.24951], [-119.9762, 37.24953], [-119.9762, 37.24865], [-119.97504, 37.24863], [-119.97503, 37.24818], [-119.97196, 37.24819], [-119.98821, 37.23507], [-119.98808, 37.23872], [-119.98571, 37.23874], [-119.98559, 37.24224], [-119.9856, 37.24225], [-119.98871, 37.24225], [-119.98871, 37.24573]]], [[[-119.94474, 37.27009], [-119.94424, 37.27246], [-119.94437, 37.27537], [-119.94326, 37.27538], [-119.94243, 37.27536], [-119.94148, 37.27657], [-119.94151, 37.27762], [-119.94062, 37.2785], [-119.94015, 37.27833], [-119.94084, 37.27763], [-119.94085, 37.27618], [-119.94138, 37.27541], [-119.94137, 37.2754], [-119.94115, 37.2754], [-119.94116, 37.27298], [-119.94474, 37.27009]]]]} Open Access 1 16845 Eastman Lake Recreation Area 13556 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 100 United States Army Corps of Engineers 142 Federal 1 Federal Agency 1 http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/EastmanLake.aspx Mariposa 31 284.146 Eastman Lake Rec. Area 0 Recreation Management Area 49 4
16830 16830 16829 {"type": "MultiPolygon", "coordinates": [[[[-119.94779, 37.25909], [-119.94775, 37.26382], [-119.94675, 37.26382], [-119.94674, 37.26483], [-119.94503, 37.26985], [-119.94097, 37.27313], [-119.94097, 37.27204], [-119.94087, 37.27203], [-119.94306, 37.26793], [-119.94208, 37.26436], [-119.94209, 37.26357], [-119.94315, 37.26357], [-119.94317, 37.2608], [-119.94466, 37.26018], [-119.94779, 37.25909]]], [[[-119.99489, 37.21396], [-119.99318, 37.2153], [-119.9937, 37.21564], [-119.99236, 37.21649], [-119.99222, 37.21684], [-119.99187, 37.21731], [-119.9913, 37.2177], [-119.99099, 37.21789], [-119.9909, 37.21838], [-119.99253, 37.22083], [-119.9918, 37.22084], [-119.99257, 37.22295], [-119.99243, 37.22356], [-119.99144, 37.22427], [-119.99121, 37.22454], [-119.99103, 37.2248], [-119.9907, 37.22633], [-119.9887, 37.22794], [-119.98861, 37.22798], [-119.9886, 37.23384], [-119.98853, 37.23386], [-119.98854, 37.23482], [-119.98821, 37.23507], [-119.97283, 37.24749], [-119.97278, 37.24744], [-119.97177, 37.24826], [-119.96593, 37.2482], [-119.96589, 37.24454], [-119.96377, 37.24454], [-119.96375, 37.2453], [-119.96138, 37.24534], [-119.96132, 37.24559], [-119.96135, 37.24559], [-119.96128, 37.24649], [-119.95538, 37.24648], [-119.95529, 37.24817], [-119.95206, 37.24814], [-119.95204, 37.24899], [-119.95, 37.24901], [-119.94997, 37.25445], [-119.95105, 37.25449], [-119.95106, 37.25626], [-119.94781, 37.25634], [-119.94779, 37.25891], [-119.94457, 37.26003], [-119.94317, 37.26061], [-119.94319, 37.25893], [-119.94266, 37.25893], [-119.94269, 37.25704], [-119.9432, 37.25704], [-119.94328, 37.24635], [-119.94775, 37.24641], [-119.94769, 37.24539], [-119.95098, 37.24542], [-119.951, 37.24457], [-119.95211, 37.24453], [-119.95216, 37.24259], [-119.95324, 37.24259], [-119.96301, 37.23349], [-119.96293, 37.22461], [-119.96158, 37.22456], [-119.96156, 37.21384], [-119.96165, 37.21383], [-119.96164, 37.20629], [-119.97387, 37.20627], [-119.97391, 37.2043], [-119.97962, 37.20427], [-119.97962, 37.20464], [-119.9803, 37.20465], [-119.98033, 37.20694], [-119.97963, 37.20695], [-119.97963, 37.20901], [-119.97984, 37.20938], [-119.98042, 37.20981], [-119.98113, 37.21004], [-119.98154, 37.21039], [-119.98192, 37.21082], [-119.98235, 37.21166], [-119.98252, 37.21206], [-119.98306, 37.21247], [-119.98353, 37.21254], [-119.98392, 37.21254], [-119.98448, 37.21241], [-119.986, 37.21198], [-119.9863, 37.21232], [-119.9857, 37.21268], [-119.9857, 37.21269], [-119.98621, 37.21304], [-119.98642, 37.21306], [-119.98711, 37.2134], [-119.98813, 37.21293], [-119.98936, 37.21197], [-119.98967, 37.21182], [-119.98995, 37.21178], [-119.99029, 37.21194], [-119.99038, 37.21207], [-119.9904, 37.21208], [-119.99081, 37.21297], [-119.99085, 37.21324], [-119.99118, 37.2137], [-119.99101, 37.21462], [-119.99168, 37.21469], [-119.99219, 37.2148], [-119.99306, 37.21425], [-119.99361, 37.21388], [-119.99396, 37.21354], [-119.99404, 37.21342], [-119.9943, 37.21342], [-119.99484, 37.21368], [-119.99489, 37.21396]], [[-119.95362, 37.24704], [-119.95362, 37.24702], [-119.95303, 37.247], [-119.95301, 37.24705], [-119.95362, 37.24704]]]]} Open Access 1 44416 Eastman Lake Recreation Area 13556 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 100 United States Army Corps of Engineers 142 Federal 1 Federal Agency 1 http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/EastmanLake.aspx Madera 48 2968.721 Eastman Lake Rec. 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]);