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_TYP = 1 and COUNTY = 17

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 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
15843 15843 15842 {"type": "MultiPolygon", "coordinates": [[[[-121.93149, 37.46354], [-121.93067, 37.46344], [-121.93033, 37.46304], [-121.93015, 37.46267], [-121.92979, 37.46233], [-121.92938, 37.46207], [-121.9288, 37.4623], [-121.9279, 37.46272], [-121.92746, 37.46275], [-121.92696, 37.46263], [-121.92638, 37.46241], [-121.92595, 37.46202], [-121.92535, 37.46125], [-121.92509, 37.46084], [-121.92529, 37.46066], [-121.92568, 37.46095], [-121.92608, 37.46139], [-121.9266, 37.46185], [-121.92712, 37.46206], [-121.92771, 37.46197], [-121.92803, 37.46182], [-121.92854, 37.46165], [-121.92906, 37.46156], [-121.92965, 37.46153], [-121.93037, 37.46199], [-121.93054, 37.46222], [-121.93117, 37.46283], [-121.93137, 37.46307], [-121.93149, 37.46354]]], [[[-121.93277, 37.45554], [-121.9326, 37.45584], [-121.93261, 37.45596], [-121.93252, 37.45625], [-121.93241, 37.45642], [-121.93217, 37.45676], [-121.93189, 37.45695], [-121.93187, 37.45675], [-121.93152, 37.45676], [-121.93101, 37.45696], [-121.93044, 37.45712], [-121.92955, 37.45728], [-121.93027, 37.45704], [-121.93099, 37.4566], [-121.93122, 37.45631], [-121.93144, 37.45611], [-121.93208, 37.45576], [-121.93227, 37.4557], [-121.93247, 37.45571], [-121.93277, 37.45554]]], [[[-121.93634, 37.4629], [-121.93608, 37.46463], [-121.93536, 37.465], [-121.9329, 37.46343], [-121.93504, 37.4625], [-121.93538, 37.46267], [-121.93603, 37.46293], [-121.93634, 37.4629]]], [[[-121.96441, 37.48777], [-121.95936, 37.48772], [-121.95916, 37.48774], [-121.95453, 37.48799], [-121.95126, 37.48689], [-121.95117, 37.48661], [-121.951, 37.48665], [-121.95082, 37.4863], [-121.95062, 37.48604], [-121.94859, 37.48386], [-121.9485, 37.48372], [-121.94847, 37.48357], [-121.94849, 37.48344], [-121.94852, 37.48334], [-121.94859, 37.48324], [-121.94868, 37.48315], [-121.95132, 37.48135], [-121.9515, 37.48118], [-121.95158, 37.48105], [-121.95163, 37.48092], [-121.95165, 37.48078], [-121.95164, 37.48067], [-121.95161, 37.48053], [-121.95124, 37.47952], [-121.95122, 37.47952], [-121.95122, 37.47943], [-121.95137, 37.47896], [-121.95149, 37.47882], [-121.95181, 37.47865], [-121.9532, 37.47822], [-121.95349, 37.47805], [-121.95367, 37.47768], [-121.9538, 37.47698], [-121.95391, 37.47585], [-121.95415, 37.47558], [-121.95451, 37.47557], [-121.95499, 37.47553], [-121.95568, 37.47538], [-121.95625, 37.47512], [-121.95666, 37.47476], [-121.95703, 37.47405], [-121.95724, 37.47224], [-121.95754, 37.47166], [-121.95799, 37.47118], [-121.9585, 37.47085], [-121.96082, 37.4701], [-121.96236, 37.46967], [-121.9631, 37.46994], [-121.96362, 37.4696], [-121.96379, 37.46913], [-121.96399, 37.46902], [-121.96426, 37.48248], [-121.96427, 37.48729], [-121.96441, 37.48731], [-121.96441, 37.48777]]], [[[-122.08824, 37.5844], [-122.0861, 37.58737], [-122.08504, 37.58786], [-122.08223, 37.58308], [-122.084, 37.58242], [-122.084, 37.58251], [-122.08392, 37.58269], [-122.08393, 37.58273], [-122.08406, 37.58279], [-122.08416, 37.58237], [-122.08494, 37.58213], [-122.08644, 37.58215], [-122.08658, 37.5821], [-122.08824, 37.5844]]]]} Restricted Access 2 25289 Don Edwards National Wildlife Refuge 18204 106 United States Fish and Wildlife Service 45 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1   Alameda 17 548.66 Don Edwards NWR 0 National Wildlife Refuge 105 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]);