units_with_maps

Table actions

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

1 row where AGNCY_TYP = 7, DES_TP = 1102 and MNG_AG_TYP = 7

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency - Parks · 1 ✖

DES_TP 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
12684 12684 12683 {"type": "MultiPolygon", "coordinates": [[[[-124.23966, 41.77097], [-124.23864, 41.77117], [-124.23847, 41.77079], [-124.23837, 41.77061], [-124.2383, 41.77053], [-124.23809, 41.77029], [-124.23778, 41.76998], [-124.23727, 41.76955], [-124.22932, 41.76403], [-124.23032, 41.76399], [-124.2313, 41.7646], [-124.23231, 41.76529], [-124.23319, 41.76587], [-124.23412, 41.76635], [-124.2342, 41.76637], [-124.23494, 41.76685], [-124.23562, 41.76742], [-124.236, 41.76782], [-124.23687, 41.76861], [-124.23692, 41.7687], [-124.2371, 41.76889], [-124.2383, 41.77003], [-124.23917, 41.77076], [-124.23952, 41.7709], [-124.23966, 41.77097]]], [[[-124.25357, 41.78535], [-124.2531, 41.78529], [-124.25267, 41.78538], [-124.25246, 41.7854], [-124.25172, 41.78564], [-124.25108, 41.78595], [-124.25085, 41.78611], [-124.25074, 41.78616], [-124.25049, 41.78634], [-124.24986, 41.78696], [-124.24973, 41.78716], [-124.24952, 41.78732], [-124.2494, 41.78752], [-124.24871, 41.78753], [-124.24443, 41.78444], [-124.24436, 41.78221], [-124.24399, 41.77305], [-124.24457, 41.77304], [-124.24459, 41.77204], [-124.24479, 41.77198], [-124.24507, 41.77183], [-124.24528, 41.7716], [-124.2457, 41.77092], [-124.24621, 41.77072], [-124.24689, 41.77071], [-124.2469, 41.77073], [-124.24706, 41.77073], [-124.24772, 41.77089], [-124.24788, 41.77103], [-124.24788, 41.77115], [-124.24811, 41.77166], [-124.24833, 41.7718], [-124.24836, 41.77244], [-124.24816, 41.77264], [-124.24818, 41.77302], [-124.24825, 41.77336], [-124.24824, 41.77358], [-124.2483, 41.77389], [-124.2485, 41.77414], [-124.24875, 41.77441], [-124.24879, 41.77451], [-124.24899, 41.77468], [-124.24914, 41.77488], [-124.24932, 41.77485], [-124.24943, 41.77486], [-124.24979, 41.7748], [-124.24995, 41.7747], [-124.25017, 41.77466], [-124.25035, 41.77471], [-124.25073, 41.77472], [-124.25085, 41.77478], [-124.25094, 41.77496], [-124.25088, 41.77517], [-124.25097, 41.77524], [-124.251, 41.77532], [-124.25099, 41.77543], [-124.2509, 41.7755], [-124.25091, 41.77559], [-124.2508, 41.77563], [-124.2504, 41.77569], [-124.25012, 41.77588], [-124.2501, 41.77596], [-124.25024, 41.7763], [-124.25046, 41.77656], [-124.25068, 41.77671], [-124.25078, 41.77687], [-124.25111, 41.77717], [-124.25126, 41.77726], [-124.25139, 41.77729], [-124.25165, 41.77755], [-124.25177, 41.77759], [-124.25209, 41.77775], [-124.25226, 41.77793], [-124.25269, 41.77815], [-124.25297, 41.77831], [-124.25301, 41.7783], [-124.25344, 41.77855], [-124.25346, 41.7795], [-124.25344, 41.78037], [-124.25349, 41.7824], [-124.25189, 41.78253], [-124.25191, 41.78428], [-124.25247, 41.78431], [-124.25301, 41.78431], [-124.25302, 41.78446], [-124.25355, 41.78445], [-124.25357, 41.78535]]]]} Open Access 1 29662 Point St. George 3081 347 Del Norte County Parks, County of 672 County 3 County Agency - Parks 7 http://www.dnco.org/ County 3 347 Del Norte County Parks, County of 661 County 3 County Agency - Parks 7 http://www.visitredwoodcoast.com/content/point-st-george-heritage-area/ncoC5001D7E35E00EA39 Del Norte 50 262.074 Point St. George   None 1102  

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]);