units_with_maps

Table actions

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

1 row where COUNTY = 23, DES_TP = 835 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 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
9686 9686 9685 {"type": "MultiPolygon", "coordinates": [[[[-122.57362, 38.09538], [-122.57358, 38.09543], [-122.5733, 38.09536], [-122.57296, 38.09534], [-122.57276, 38.09537], [-122.57252, 38.09544], [-122.57224, 38.09559], [-122.57177, 38.09598], [-122.57144, 38.09618], [-122.57108, 38.09634], [-122.57091, 38.09627], [-122.57083, 38.09634], [-122.57042, 38.09658], [-122.57009, 38.09672], [-122.57005, 38.09677], [-122.56967, 38.09687], [-122.56952, 38.0965], [-122.56974, 38.09646], [-122.56986, 38.09648], [-122.57075, 38.09626], [-122.57075, 38.09624], [-122.57094, 38.09593], [-122.57117, 38.09594], [-122.57137, 38.09598], [-122.57132, 38.09582], [-122.57143, 38.09573], [-122.57173, 38.09569], [-122.57167, 38.09542], [-122.57195, 38.09518], [-122.57216, 38.09517], [-122.57251, 38.09511], [-122.57249, 38.0949], [-122.57258, 38.09475], [-122.57274, 38.09471], [-122.57275, 38.09441], [-122.5727, 38.0942], [-122.57274, 38.0941], [-122.5729, 38.09421], [-122.5729, 38.09453], [-122.57282, 38.09478], [-122.57268, 38.095], [-122.57259, 38.0951], [-122.57287, 38.09522], [-122.57302, 38.09516], [-122.57338, 38.09532], [-122.57362, 38.09538]]], [[[-122.57364, 38.0918], [-122.57339, 38.09168], [-122.57323, 38.09163], [-122.5731, 38.0916], [-122.57287, 38.09158], [-122.57272, 38.09159], [-122.57262, 38.09161], [-122.57238, 38.09169], [-122.57221, 38.09177], [-122.57209, 38.09184], [-122.57194, 38.09197], [-122.57184, 38.09207], [-122.57176, 38.09221], [-122.57171, 38.09233], [-122.57168, 38.09245], [-122.57167, 38.0928], [-122.57146, 38.09278], [-122.57146, 38.09239], [-122.57126, 38.09239], [-122.57105, 38.09243], [-122.57085, 38.09249], [-122.57064, 38.0926], [-122.57067, 38.09244], [-122.57118, 38.09213], [-122.57132, 38.09223], [-122.57181, 38.09187], [-122.57177, 38.09173], [-122.57208, 38.09158], [-122.57225, 38.09152], [-122.57262, 38.09146], [-122.5728, 38.09146], [-122.57303, 38.09149], [-122.57321, 38.09154], [-122.57342, 38.09162], [-122.57361, 38.09174], [-122.57364, 38.0918]]], [[[-122.57383, 38.09265], [-122.57375, 38.09277], [-122.57342, 38.09303], [-122.57297, 38.09314], [-122.57287, 38.09325], [-122.5728, 38.09366], [-122.57248, 38.09381], [-122.57234, 38.09385], [-122.57168, 38.09409], [-122.57166, 38.09407], [-122.57221, 38.09385], [-122.57189, 38.09373], [-122.57148, 38.0933], [-122.57146, 38.0932], [-122.57151, 38.09293], [-122.57167, 38.09294], [-122.57163, 38.09321], [-122.57191, 38.09355], [-122.572, 38.09361], [-122.57208, 38.09365], [-122.57228, 38.09369], [-122.57254, 38.09359], [-122.57263, 38.09354], [-122.57271, 38.09346], [-122.57243, 38.09331], [-122.57244, 38.09328], [-122.57274, 38.09342], [-122.57278, 38.09333], [-122.57283, 38.09317], [-122.57288, 38.09281], [-122.57337, 38.09261], [-122.57338, 38.09252], [-122.57347, 38.09251], [-122.57383, 38.09265]]], [[[-122.57365, 38.09194], [-122.57331, 38.09205], [-122.57329, 38.09203], [-122.57364, 38.09191], [-122.57365, 38.09194]]]]} Open Access 1 16353 Novato Lands 011 22921 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 6.715 Novato Lands 011   None 835  

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