units_with_maps

Table actions

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

1 row where AGNCY_NAME = 146, LAYER = 13 and MNG_AGENCY = 273

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Los Angeles - Department of Parks and Recreation, County of · 1 ✖

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
7478 7478 7477 {"type": "Polygon", "coordinates": [[[-117.95999, 34.10704], [-117.9599, 34.11834], [-117.95943, 34.11891], [-117.95858, 34.11969], [-117.95755, 34.12058], [-117.95639, 34.12138], [-117.95542, 34.12235], [-117.95497, 34.12298], [-117.95388, 34.12367], [-117.95313, 34.12443], [-117.95266, 34.1252], [-117.9525, 34.12614], [-117.95196, 34.12642], [-117.95133, 34.12694], [-117.95091, 34.12769], [-117.95066, 34.12822], [-117.95053, 34.12906], [-117.95015, 34.13], [-117.94872, 34.13114], [-117.94844, 34.13138], [-117.94805, 34.1319], [-117.94765, 34.13216], [-117.94567, 34.13364], [-117.94402, 34.13482], [-117.94341, 34.13538], [-117.94279, 34.13606], [-117.94249, 34.13642], [-117.93973, 34.13462], [-117.94295, 34.13132], [-117.94585, 34.12985], [-117.9469, 34.12888], [-117.94687, 34.12161], [-117.94251, 34.12163], [-117.94262, 34.118], [-117.93818, 34.11798], [-117.93817, 34.11927], [-117.93609, 34.11925], [-117.93609, 34.11897], [-117.93615, 34.11857], [-117.93688, 34.11521], [-117.93704, 34.11478], [-117.93726, 34.11441], [-117.94023, 34.11089], [-117.9404, 34.11063], [-117.94096, 34.11063], [-117.94293, 34.10827], [-117.94297, 34.1072], [-117.95999, 34.10704]]]} Open Access 1 6999 Santa Fe Dam Recreation Area 32698 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 381 Los Angeles - Department of Parks and Recreation, County of 273 County 3 County Agency - Parks 7 http://parks.lacounty.gov/santa-fe-dam-recreational-area/ Los Angeles 6 912.515 Santa Fe Dam Rec. Area 0 Local Recreation Area 3 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]);