units_with_maps

Table actions

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

1 row where AGNCY_NAME = 444 and DES_TP = 832

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 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
9681 9681 9680 {"type": "MultiPolygon", "coordinates": [[[[-122.58154, 38.10567], [-122.58133, 38.10596], [-122.58095, 38.10567], [-122.58016, 38.10532], [-122.58021, 38.10523], [-122.58014, 38.10518], [-122.58002, 38.10498], [-122.58012, 38.10484], [-122.58017, 38.10487], [-122.58013, 38.10496], [-122.58022, 38.10502], [-122.58026, 38.1051], [-122.58047, 38.10517], [-122.58054, 38.10521], [-122.58077, 38.10526], [-122.58075, 38.10531], [-122.58082, 38.10534], [-122.58084, 38.10532], [-122.58092, 38.10537], [-122.58095, 38.10533], [-122.58105, 38.10538], [-122.58154, 38.10567]]], [[[-122.58382, 38.1069], [-122.58357, 38.10723], [-122.58353, 38.10707], [-122.5833, 38.10698], [-122.58315, 38.10688], [-122.58303, 38.10689], [-122.58294, 38.10687], [-122.58263, 38.10678], [-122.58257, 38.10677], [-122.58256, 38.10675], [-122.58238, 38.10676], [-122.58197, 38.1065], [-122.58178, 38.10626], [-122.58168, 38.10618], [-122.58173, 38.1061], [-122.58198, 38.10628], [-122.58211, 38.10645], [-122.58241, 38.10667], [-122.58264, 38.10667], [-122.58275, 38.10653], [-122.58303, 38.10662], [-122.58328, 38.10661], [-122.58349, 38.10674], [-122.5837, 38.10681], [-122.58382, 38.1069]]], [[[-122.58663, 38.10767], [-122.58656, 38.10771], [-122.58647, 38.1077], [-122.58605, 38.10747], [-122.58592, 38.10764], [-122.58585, 38.1076], [-122.58564, 38.10759], [-122.58516, 38.1075], [-122.58496, 38.10739], [-122.58479, 38.10741], [-122.58478, 38.10742], [-122.58476, 38.10741], [-122.58464, 38.10744], [-122.58433, 38.10745], [-122.58455, 38.10714], [-122.58493, 38.1072], [-122.58499, 38.10713], [-122.58509, 38.10713], [-122.58516, 38.10717], [-122.58527, 38.10727], [-122.58567, 38.10735], [-122.58581, 38.10735], [-122.586, 38.10738], [-122.58608, 38.10742], [-122.5861, 38.1074], [-122.58647, 38.10756], [-122.58663, 38.10767]]]]} Open Access 1 16350 Novato Lands 020 22927 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 3.328 Novato Lands 020   None 832  

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