units_with_maps

Table actions

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

1 row where COUNTY = 6, DES_TP = 4 and MNG_AGENCY = 325

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Duarte, City of · 1 ✖

DES_TP 1

  • Local Conservation Area · 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
7476 7476 7475 {"type": "MultiPolygon", "coordinates": [[[[-117.94363, 34.16523], [-117.94362, 34.16688], [-117.94228, 34.16689], [-117.94231, 34.16524], [-117.94363, 34.16523]]], [[[-117.95964, 34.15204], [-117.95956, 34.16516], [-117.94833, 34.16521], [-117.94805, 34.16498], [-117.94792, 34.16489], [-117.94772, 34.1648], [-117.94726, 34.16467], [-117.94692, 34.16467], [-117.94675, 34.16478], [-117.94654, 34.16501], [-117.94644, 34.16506], [-117.94544, 34.16233], [-117.94546, 34.16215], [-117.94543, 34.16206], [-117.94532, 34.16184], [-117.94532, 34.16179], [-117.94533, 34.16172], [-117.94544, 34.16156], [-117.9455, 34.16142], [-117.94551, 34.1612], [-117.94553, 34.16114], [-117.94559, 34.1611], [-117.94582, 34.16102], [-117.94619, 34.16084], [-117.94636, 34.16083], [-117.94642, 34.16078], [-117.94642, 34.16074], [-117.94638, 34.1607], [-117.94631, 34.16069], [-117.94608, 34.16079], [-117.94588, 34.16082], [-117.94589, 34.16084], [-117.94605, 34.16083], [-117.94617, 34.16079], [-117.94631, 34.16072], [-117.94636, 34.16072], [-117.94638, 34.16074], [-117.94638, 34.16078], [-117.94636, 34.1608], [-117.94618, 34.16081], [-117.94581, 34.16099], [-117.94558, 34.16107], [-117.9455, 34.16114], [-117.94548, 34.16119], [-117.94547, 34.16141], [-117.94539, 34.16157], [-117.94529, 34.16175], [-117.94529, 34.16184], [-117.94541, 34.1621], [-117.94542, 34.1622], [-117.94541, 34.16228], [-117.94463, 34.16017], [-117.94484, 34.16022], [-117.94504, 34.16032], [-117.9452, 34.16044], [-117.94536, 34.16064], [-117.94565, 34.1608], [-117.94581, 34.16085], [-117.94585, 34.16085], [-117.94587, 34.16083], [-117.94565, 34.16078], [-117.94538, 34.16062], [-117.94517, 34.16038], [-117.94501, 34.16026], [-117.94485, 34.16019], [-117.94462, 34.16014], [-117.94463, 34.158], [-117.94337, 34.158], [-117.94337, 34.15433], [-117.9448, 34.1543], [-117.94486, 34.15417], [-117.94479, 34.15399], [-117.9449, 34.15381], [-117.94518, 34.15366], [-117.94523, 34.15358], [-117.94526, 34.15346], [-117.94539, 34.15328], [-117.94544, 34.15331], [-117.94533, 34.15348], [-117.9453, 34.15359], [-117.94552, 34.15362], [-117.94623, 34.15382], [-117.9466, 34.15353], [-117.94709, 34.15363], [-117.94718, 34.15358], [-117.94725, 34.15364], [-117.9473, 34.15373], [-117.94738, 34.1537], [-117.94742, 34.1538], [-117.94745, 34.15391], [-117.94745, 34.15406], [-117.9474, 34.15423], [-117.9474, 34.15426], [-117.94871, 34.15425], [-117.94858, 34.15372], [-117.94928, 34.15361], [-117.94944, 34.15425], [-117.95101, 34.15423], [-117.95102, 34.15421], [-117.9511, 34.1542], [-117.95113, 34.1545], [-117.95133, 34.15518], [-117.95172, 34.15573], [-117.95288, 34.15541], [-117.95278, 34.15515], [-117.95283, 34.15511], [-117.95411, 34.15621], [-117.95439, 34.15601], [-117.95436, 34.15612], [-117.95496, 34.15628], [-117.95873, 34.1538], [-117.95932, 34.15232], [-117.95939, 34.152], [-117.95964, 34.15204]], [[-117.95364, 34.1575], [-117.95401, 34.15753], [-117.95406, 34.15723], [-117.95387, 34.15708], [-117.95359, 34.15719], [-117.95364, 34.1575]]], [[[-117.94829, 34.16521], [-117.94651, 34.16522], [-117.94645, 34.16508], [-117.94656, 34.16504], [-117.94678, 34.1648], [-117.94693, 34.1647], [-117.94726, 34.1647], [-117.94751, 34.16476], [-117.94789, 34.16491], [-117.94829, 34.16521]]]]} Open Access 1 6988 Duarte Wilderness Preserve 3162 1089 Duarte, City of 328 City 2 City Agency 2 http://www.accessduarte.com/index.php?option=com_content&view=article&id=62&Itemid=72 City 2 1089 Duarte, City of 325 City 2 City Agency 2   Los Angeles 6 405.48 Duarte Wilderness Preserve 0 Local Conservation Area 4 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]);