units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, COUNTY = 23 and DES_TP = 802

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

ACCESS_TYP 1

  • Open 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
9577 9577 9576 {"type": "MultiPolygon", "coordinates": [[[[-122.53532, 38.04776], [-122.53436, 38.04873], [-122.53407, 38.04859], [-122.53397, 38.04848], [-122.53379, 38.04839], [-122.53379, 38.04836], [-122.53403, 38.04807], [-122.53417, 38.04784], [-122.53426, 38.04772], [-122.53439, 38.04763], [-122.53469, 38.04748], [-122.53493, 38.04731], [-122.53532, 38.04776]]], [[[-122.54526, 38.04753], [-122.5451, 38.04769], [-122.545, 38.04775], [-122.54485, 38.04782], [-122.54466, 38.04764], [-122.54464, 38.04764], [-122.54459, 38.04757], [-122.5445, 38.04757], [-122.54432, 38.04764], [-122.54408, 38.04759], [-122.5439, 38.0476], [-122.54382, 38.04754], [-122.54374, 38.04741], [-122.54367, 38.04736], [-122.54368, 38.04733], [-122.54357, 38.04726], [-122.54354, 38.04728], [-122.54347, 38.04722], [-122.54337, 38.04711], [-122.54328, 38.04708], [-122.54328, 38.04705], [-122.54324, 38.04704], [-122.54322, 38.04706], [-122.54311, 38.04704], [-122.54304, 38.04705], [-122.54284, 38.04695], [-122.54289, 38.04689], [-122.54285, 38.04683], [-122.54245, 38.0466], [-122.54237, 38.04668], [-122.54234, 38.04667], [-122.5423, 38.04671], [-122.54232, 38.04673], [-122.54229, 38.04677], [-122.54231, 38.04679], [-122.54226, 38.04686], [-122.54222, 38.047], [-122.5421, 38.04696], [-122.54218, 38.04659], [-122.54191, 38.04624], [-122.54119, 38.04606], [-122.53834, 38.04628], [-122.53793, 38.04594], [-122.5369, 38.04589], [-122.53704, 38.04554], [-122.53711, 38.04512], [-122.53741, 38.04508], [-122.5376, 38.04509], [-122.53793, 38.0452], [-122.53758, 38.04532], [-122.53734, 38.04532], [-122.5373, 38.04537], [-122.5373, 38.04547], [-122.53724, 38.04555], [-122.53724, 38.04564], [-122.53732, 38.04567], [-122.53777, 38.04567], [-122.53781, 38.0457], [-122.5379, 38.0457], [-122.53805, 38.04578], [-122.53816, 38.04596], [-122.53828, 38.04599], [-122.53839, 38.04613], [-122.53847, 38.04614], [-122.5387, 38.04606], [-122.53909, 38.04575], [-122.53927, 38.04576], [-122.53933, 38.04577], [-122.53988, 38.04577], [-122.54006, 38.04583], [-122.54034, 38.04588], [-122.54076, 38.04588], [-122.54102, 38.04581], [-122.54116, 38.04589], [-122.54126, 38.04583], [-122.54128, 38.04577], [-122.54137, 38.04561], [-122.54142, 38.04561], [-122.54126, 38.04588], [-122.54133, 38.04594], [-122.54154, 38.04598], [-122.54184, 38.04598], [-122.54208, 38.04607], [-122.54217, 38.04606], [-122.54241, 38.04606], [-122.54241, 38.04611], [-122.54244, 38.04617], [-122.54254, 38.04618], [-122.54255, 38.04621], [-122.54266, 38.04621], [-122.54267, 38.04618], [-122.54297, 38.04617], [-122.54297, 38.0462], [-122.54311, 38.04641], [-122.54307, 38.04643], [-122.54312, 38.04653], [-122.54316, 38.04653], [-122.5432, 38.0466], [-122.54329, 38.04661], [-122.54338, 38.04658], [-122.5434, 38.04664], [-122.54348, 38.04664], [-122.54359, 38.04661], [-122.54378, 38.04673], [-122.544, 38.04673], [-122.54415, 38.04683], [-122.54423, 38.04691], [-122.54416, 38.04713], [-122.54429, 38.0472], [-122.54449, 38.04718], [-122.54466, 38.04723], [-122.54489, 38.04737], [-122.54499, 38.04741], [-122.54498, 38.04744], [-122.54526, 38.04753]]], [[[-122.53984, 38.04383], [-122.5382, 38.04392], [-122.53823, 38.04385], [-122.53818, 38.04337], [-122.5383, 38.04336], [-122.53893, 38.04368], [-122.53984, 38.04383]]], [[[-122.54318, 38.04471], [-122.54313, 38.04545], [-122.54286, 38.04549], [-122.54283, 38.04502], [-122.54247, 38.04494], [-122.54204, 38.04507], [-122.54204, 38.04552], [-122.54149, 38.04548], [-122.54194, 38.04476], [-122.54318, 38.04471]]], [[[-122.54626, 38.04664], [-122.54555, 38.04712], [-122.54552, 38.04696], [-122.54592, 38.04679], [-122.54598, 38.04659], [-122.54564, 38.04626], [-122.54508, 38.04612], [-122.54478, 38.0463], [-122.54472, 38.04624], [-122.54464, 38.04608], [-122.54462, 38.04589], [-122.54457, 38.04576], [-122.5445, 38.04564], [-122.54439, 38.04553], [-122.5449, 38.04489], [-122.54626, 38.04664]]]]} Open Access 1 16099 Navato Lands 006 22678 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 16.21 Navato Lands 006   None 802  

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