units_with_maps

Table actions

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

1 row where DES_TP = 87, MNG_AG_LEV = 1 and SUID_NMA = 21950

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Federal Other or Unknown · 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
11423 11423 11422 {"type": "MultiPolygon", "coordinates": [[[[-121.30305, 38.54735], [-121.30211, 38.5479], [-121.30127, 38.54837], [-121.2953, 38.55181], [-121.29482, 38.55207], [-121.29427, 38.55231], [-121.2937, 38.5525], [-121.29335, 38.5526], [-121.29265, 38.55275], [-121.29246, 38.55278], [-121.29003, 38.5528], [-121.28957, 38.55274], [-121.28897, 38.55261], [-121.28836, 38.55242], [-121.28791, 38.55226], [-121.28551, 38.5512], [-121.28518, 38.55109], [-121.28486, 38.55102], [-121.28379, 38.55086], [-121.28308, 38.55082], [-121.28265, 38.55083], [-121.28259, 38.54964], [-121.28298, 38.54965], [-121.28397, 38.54949], [-121.28537, 38.54886], [-121.28599, 38.54831], [-121.28692, 38.54751], [-121.28713, 38.54683], [-121.28788, 38.54565], [-121.28812, 38.54522], [-121.28839, 38.54526], [-121.28848, 38.54518], [-121.29005, 38.54547], [-121.29024, 38.54486], [-121.29018, 38.54435], [-121.28998, 38.54383], [-121.28964, 38.54334], [-121.28791, 38.54363], [-121.28759, 38.54403], [-121.28589, 38.54301], [-121.28583, 38.54294], [-121.28639, 38.54202], [-121.28574, 38.54162], [-121.28514, 38.54238], [-121.28501, 38.54227], [-121.28488, 38.54207], [-121.28543, 38.54142], [-121.28547, 38.54098], [-121.28481, 38.54044], [-121.28397, 38.54], [-121.28293, 38.54004], [-121.28244, 38.54027], [-121.28118, 38.53964], [-121.28064, 38.53961], [-121.27946, 38.54002], [-121.27897, 38.54049], [-121.27866, 38.54086], [-121.2783, 38.54113], [-121.27786, 38.54135], [-121.27631, 38.54189], [-121.2764, 38.54203], [-121.27556, 38.54252], [-121.27453, 38.54244], [-121.27376, 38.54246], [-121.27307, 38.54332], [-121.27282, 38.54358], [-121.27375, 38.54468], [-121.27278, 38.54507], [-121.27227, 38.54435], [-121.27224, 38.54368], [-121.27233, 38.54302], [-121.27252, 38.54256], [-121.27246, 38.54215], [-121.27209, 38.54127], [-121.27177, 38.54079], [-121.27132, 38.5405], [-121.27142, 38.5403], [-121.27227, 38.54066], [-121.27301, 38.5409], [-121.27377, 38.54112], [-121.27493, 38.54155], [-121.27598, 38.54132], [-121.27663, 38.54074], [-121.2757, 38.53913], [-121.27535, 38.53918], [-121.27453, 38.53879], [-121.2726, 38.53884], [-121.27114, 38.53948], [-121.27019, 38.54032], [-121.26992, 38.54086], [-121.26982, 38.54135], [-121.26894, 38.54175], [-121.26856, 38.54449], [-121.2689, 38.54555], [-121.26937, 38.54647], [-121.26788, 38.54711], [-121.26917, 38.54757], [-121.26919, 38.54759], [-121.26923, 38.54765], [-121.2689, 38.54865], [-121.2688, 38.54869], [-121.26872, 38.54877], [-121.26856, 38.54887], [-121.26839, 38.54894], [-121.26831, 38.549], [-121.26706, 38.54949], [-121.26703, 38.54956], [-121.2661, 38.54997], [-121.26584, 38.54992], [-121.26464, 38.54933], [-121.26446, 38.54912], [-121.2637, 38.54838], [-121.26341, 38.54821], [-121.26297, 38.54721], [-121.26298, 38.54713], [-121.26297, 38.54709], [-121.26302, 38.54687], [-121.26313, 38.54672], [-121.26313, 38.5467], [-121.26121, 38.54672], [-121.2612, 38.54482], [-121.26109, 38.54475], [-121.26111, 38.53501], [-121.26859, 38.53502], [-121.26859, 38.53527], [-121.28764, 38.5349], [-121.29213, 38.53601], [-121.2884, 38.53879], [-121.28755, 38.53809], [-121.28787, 38.53781], [-121.28787, 38.53779], [-121.28664, 38.53694], [-121.2863, 38.53673], [-121.28504, 38.53627], [-121.28387, 38.53604], [-121.28242, 38.53602], [-121.28172, 38.5361], [-121.28183, 38.53748], [-121.28205, 38.5376], [-121.28355, 38.53763], [-121.28389, 38.53766], [-121.28467, 38.53784], [-121.28628, 38.5387], [-121.28665, 38.5387], [-121.28746, 38.53816], [-121.28831, 38.53886], [-121.28745, 38.53963], [-121.28745, 38.53965], [-121.30255, 38.53981], [-121.30254, 38.54027], [-121.29962, 38.54163], [-121.30305, 38.54735]]], [[[-121.27303, 38.54697], [-121.27298, 38.54745], [-121.27276, 38.5477], [-121.27231, 38.54795], [-121.27189, 38.54805], [-121.27153, 38.54807], [-121.27114, 38.54797], [-121.27069, 38.5477], [-121.27032, 38.54743], [-121.27016, 38.54712], [-121.27014, 38.54691], [-121.27016, 38.54678], [-121.27086, 38.54634], [-121.27185, 38.54597], [-121.27209, 38.54611], [-121.27236, 38.54639], [-121.27303, 38.54697]]]]} Restricted Access 2 22251 Mather 21950 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Sacramento 41 927.044 Mather 0 Federal Other or Unknown 87 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]);