units_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, AGNCY_TYP = 13 and DES_TP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Park · 1 ✖

ACCESS_TYP 1

  • No Public Access · 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
8217 8217 8216 {"type": "Polygon", "coordinates": [[[-117.17097, 33.11374], [-117.17037, 33.11403], [-117.16936, 33.1144], [-117.16869, 33.11525], [-117.16869, 33.11589], [-117.1677, 33.11649], [-117.16752, 33.11688], [-117.16683, 33.11688], [-117.16714, 33.11618], [-117.16679, 33.11598], [-117.16555, 33.11598], [-117.16559, 33.11623], [-117.16539, 33.11626], [-117.16533, 33.11598], [-117.16473, 33.11597], [-117.16472, 33.11457], [-117.16443, 33.11428], [-117.16415, 33.11412], [-117.16436, 33.11387], [-117.16443, 33.1135], [-117.16443, 33.11338], [-117.16416, 33.11309], [-117.16432, 33.11292], [-117.16492, 33.11313], [-117.16499, 33.11327], [-117.16616, 33.11328], [-117.16617, 33.11297], [-117.1667, 33.11245], [-117.16671, 33.11222], [-117.16609, 33.1121], [-117.16543, 33.11143], [-117.16572, 33.11127], [-117.16596, 33.11142], [-117.16637, 33.11155], [-117.16697, 33.1115], [-117.16709, 33.11132], [-117.16748, 33.11138], [-117.16788, 33.11159], [-117.16805, 33.11267], [-117.16799, 33.11329], [-117.16876, 33.11329], [-117.16878, 33.11319], [-117.16924, 33.11279], [-117.17009, 33.11237], [-117.16996, 33.11267], [-117.16958, 33.1131], [-117.16954, 33.11329], [-117.16947, 33.1133], [-117.16942, 33.11355], [-117.16966, 33.11366], [-117.17097, 33.11374]], [[-117.16912, 33.11452], [-117.16939, 33.11424], [-117.16972, 33.11406], [-117.16972, 33.11395], [-117.16945, 33.11372], [-117.16928, 33.11338], [-117.16907, 33.11344], [-117.16868, 33.11397], [-117.1683, 33.11424], [-117.16779, 33.11418], [-117.16765, 33.11374], [-117.16769, 33.11329], [-117.16666, 33.11328], [-117.16658, 33.11343], [-117.16583, 33.11369], [-117.1652, 33.11353], [-117.1649, 33.11361], [-117.16487, 33.11397], [-117.16536, 33.11482], [-117.16555, 33.11498], [-117.16593, 33.11491], [-117.16683, 33.11496], [-117.16743, 33.1153], [-117.16849, 33.11523], [-117.16906, 33.11473], [-117.16912, 33.11452]]]} No Public Access 3 47786 South Lake Park 31662 2170 Vallecitos Water District 879 Special District 4 Water District 13 http://www.vwd.org/ Special District 4 1308 San Marcos, City of 197 City 2 City Agency 2   San Diego 4 29.916 South Lake Park 0 Local Park 2 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]);