units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, AGNCY_WEB = "http://www.btcsd.org/" and MNG_AGENCY = 418

This data as json, copyable, CSV (advanced)

MNG_AGENCY 1

  • Brooktrails Community Services District · 1 ✖

ACCESS_TYP 1

  • Restricted 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
15682 15682 15681 {"type": "Polygon", "coordinates": [[[-123.38922, 39.4385], [-123.38888, 39.43888], [-123.38872, 39.43884], [-123.38836, 39.43885], [-123.38793, 39.43897], [-123.38765, 39.43907], [-123.38741, 39.43928], [-123.3873, 39.43956], [-123.38734, 39.43987], [-123.38754, 39.44014], [-123.3877, 39.44026], [-123.38802, 39.44001], [-123.38807, 39.44006], [-123.38775, 39.44032], [-123.38797, 39.44061], [-123.38759, 39.44096], [-123.38761, 39.44128], [-123.388, 39.44131], [-123.38802, 39.44139], [-123.38764, 39.44141], [-123.38763, 39.44142], [-123.38805, 39.44196], [-123.38808, 39.44209], [-123.38806, 39.44218], [-123.38809, 39.44229], [-123.38805, 39.44246], [-123.38806, 39.44262], [-123.38813, 39.44281], [-123.38816, 39.443], [-123.38838, 39.4434], [-123.38842, 39.44351], [-123.38827, 39.44357], [-123.38818, 39.44362], [-123.38805, 39.44375], [-123.38801, 39.44384], [-123.38798, 39.44392], [-123.38797, 39.44401], [-123.38799, 39.44409], [-123.38807, 39.44428], [-123.38809, 39.44438], [-123.38809, 39.44442], [-123.38806, 39.44446], [-123.38801, 39.44448], [-123.38793, 39.44447], [-123.38781, 39.44443], [-123.3876, 39.4443], [-123.38732, 39.44418], [-123.387, 39.44412], [-123.38674, 39.44413], [-123.38657, 39.44407], [-123.38611, 39.44381], [-123.38579, 39.44378], [-123.3855, 39.44386], [-123.38525, 39.44339], [-123.38602, 39.44232], [-123.38594, 39.44214], [-123.38582, 39.44212], [-123.38557, 39.4422], [-123.38542, 39.44243], [-123.38505, 39.44211], [-123.38493, 39.44192], [-123.38475, 39.44172], [-123.38457, 39.4416], [-123.38464, 39.44139], [-123.38474, 39.44121], [-123.38494, 39.44057], [-123.38514, 39.44025], [-123.38521, 39.44002], [-123.38521, 39.4397], [-123.38511, 39.43937], [-123.38498, 39.43905], [-123.3848, 39.43878], [-123.38465, 39.43848], [-123.3844, 39.43812], [-123.38446, 39.43793], [-123.38447, 39.43772], [-123.3842, 39.43699], [-123.38417, 39.43681], [-123.38423, 39.43652], [-123.3843, 39.43642], [-123.38476, 39.43627], [-123.38491, 39.43655], [-123.38532, 39.43638], [-123.3854, 39.43642], [-123.38569, 39.43623], [-123.38586, 39.43656], [-123.3856, 39.43664], [-123.38568, 39.43687], [-123.38579, 39.43704], [-123.38617, 39.43738], [-123.38637, 39.4375], [-123.3867, 39.43775], [-123.38694, 39.43788], [-123.38732, 39.43814], [-123.3875, 39.43829], [-123.38771, 39.43839], [-123.38824, 39.43852], [-123.38922, 39.4385]]]} Restricted Access 2 48511 Brooktrails Disc Golf Course 33223 2208 Brooktrails Community Services District 424 Special District 4 Community Services District 19 http://www.btcsd.org/ Special District 4 2208 Brooktrails Community Services District 418 Special District 4 Community Services District 17   Mendocino 24 47.2 Brooktrails Disc GC 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]);