units_with_maps

Table actions

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

1 row where AGNCY_NAME = 22 and DES_TP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 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
9899 9899 9898 {"type": "Polygon", "coordinates": [[[-120.72276, 35.25881], [-120.71907, 35.26446], [-120.7187, 35.26439], [-120.7184, 35.26437], [-120.7182, 35.26433], [-120.71795, 35.26437], [-120.71781, 35.26438], [-120.7174, 35.26431], [-120.717, 35.26417], [-120.71696, 35.26413], [-120.71694, 35.26405], [-120.71691, 35.26402], [-120.71641, 35.26375], [-120.71619, 35.26367], [-120.71597, 35.26365], [-120.71528, 35.26367], [-120.71505, 35.26365], [-120.71472, 35.26357], [-120.71461, 35.26352], [-120.71453, 35.26346], [-120.71449, 35.26339], [-120.7144, 35.26319], [-120.71426, 35.26307], [-120.71422, 35.26297], [-120.71416, 35.26293], [-120.71394, 35.26283], [-120.71384, 35.2628], [-120.71307, 35.26274], [-120.71294, 35.26272], [-120.71281, 35.26268], [-120.71241, 35.26246], [-120.71226, 35.26241], [-120.71206, 35.26239], [-120.71124, 35.2624], [-120.711, 35.26243], [-120.7107, 35.26239], [-120.71031, 35.26247], [-120.71011, 35.26249], [-120.7099, 35.26247], [-120.70968, 35.26243], [-120.70916, 35.26224], [-120.70862, 35.26202], [-120.70911, 35.26118], [-120.70911, 35.26117], [-120.70799, 35.26061], [-120.70769, 35.2605], [-120.70728, 35.2604], [-120.70668, 35.26032], [-120.70363, 35.25931], [-120.71036, 35.25391], [-120.71036, 35.25389], [-120.70875, 35.2538], [-120.70699, 35.25338], [-120.70607, 35.25308], [-120.70512, 35.25297], [-120.70459, 35.25516], [-120.70331, 35.25593], [-120.70128, 35.25617], [-120.70009, 35.25634], [-120.69821, 35.25504], [-120.6978, 35.2545], [-120.69644, 35.25431], [-120.69612, 35.25393], [-120.69564, 35.25421], [-120.69543, 35.25404], [-120.69481, 35.25328], [-120.69227, 35.25114], [-120.69221, 35.25083], [-120.69199, 35.25009], [-120.69178, 35.24991], [-120.69144, 35.24969], [-120.6908, 35.24962], [-120.69007, 35.24946], [-120.68975, 35.2495], [-120.6889, 35.24852], [-120.68574, 35.25036], [-120.68455, 35.24895], [-120.68459, 35.2489], [-120.68344, 35.24726], [-120.6832, 35.24588], [-120.68342, 35.24564], [-120.68334, 35.24548], [-120.68704, 35.24348], [-120.69259, 35.2393], [-120.6958, 35.24208], [-120.70089, 35.2396], [-120.70424, 35.24254], [-120.70425, 35.24253], [-120.70441, 35.24041], [-120.71387, 35.24015], [-120.71391, 35.24413], [-120.7063, 35.24433], [-120.70629, 35.24434], [-120.72276, 35.25881]]]} Open Access 1 16977 Irish Hills Natural Reserve 20233 1307 San Luis Obispo, City of 22 City 2 City Agency 2 http://www.slocity.org/parksandrecreation/index.asp City 2 1307 San Luis Obispo, City of 22 City 2 City Agency 2   San Luis Obispo 1 1138.739 Irish Hills Natural Reserve 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]);