units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, DES_TP = 482 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

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
5994 5994 5993 {"type": "MultiPolygon", "coordinates": [[[[-122.56148, 38.09042], [-122.56145, 38.09047], [-122.56093, 38.09081], [-122.56078, 38.09086], [-122.5606, 38.09088], [-122.56046, 38.09087], [-122.55844, 38.09048], [-122.55819, 38.09041], [-122.55791, 38.09028], [-122.55771, 38.09014], [-122.55569, 38.08848], [-122.55541, 38.08821], [-122.55561, 38.08836], [-122.55584, 38.08848], [-122.55603, 38.08856], [-122.55629, 38.08862], [-122.55665, 38.08864], [-122.55752, 38.08858], [-122.55806, 38.08858], [-122.55865, 38.08866], [-122.55905, 38.08875], [-122.55929, 38.08883], [-122.55973, 38.08903], [-122.56012, 38.08927], [-122.56118, 38.09011], [-122.56146, 38.09035], [-122.56148, 38.09042]]], [[[-122.56279, 38.0895], [-122.56277, 38.08955], [-122.56188, 38.09021], [-122.5618, 38.09024], [-122.56174, 38.09021], [-122.56055, 38.08925], [-122.56074, 38.08911], [-122.56144, 38.0889], [-122.56142, 38.0888], [-122.56148, 38.08878], [-122.56156, 38.08884], [-122.56179, 38.08861], [-122.56186, 38.08872], [-122.56195, 38.08882], [-122.56277, 38.08947], [-122.56279, 38.0895]]], [[[-122.56175, 38.09349], [-122.56163, 38.0935], [-122.56161, 38.09418], [-122.56122, 38.09355], [-122.56116, 38.0934], [-122.56112, 38.09328], [-122.5611, 38.0931], [-122.56105, 38.09137], [-122.56108, 38.09122], [-122.56118, 38.0911], [-122.56172, 38.09073], [-122.5618, 38.09072], [-122.56187, 38.09074], [-122.56194, 38.09084], [-122.56208, 38.0911], [-122.56215, 38.09134], [-122.56217, 38.09162], [-122.56215, 38.09189], [-122.56211, 38.09209], [-122.56175, 38.09349]]], [[[-122.56325, 38.09474], [-122.56261, 38.09516], [-122.56231, 38.09478], [-122.56217, 38.09455], [-122.56207, 38.09427], [-122.56204, 38.09398], [-122.56315, 38.09389], [-122.56325, 38.09474]]], [[[-122.56499, 38.09122], [-122.56388, 38.09334], [-122.56369, 38.09341], [-122.56373, 38.09373], [-122.56204, 38.09387], [-122.56207, 38.09366], [-122.56247, 38.09225], [-122.56255, 38.09168], [-122.5626, 38.09165], [-122.56297, 38.09163], [-122.5632, 38.09159], [-122.56367, 38.09148], [-122.56415, 38.0913], [-122.56422, 38.09125], [-122.56424, 38.09118], [-122.56423, 38.09111], [-122.56417, 38.09106], [-122.56409, 38.09103], [-122.56401, 38.09103], [-122.5639, 38.09108], [-122.56378, 38.09124], [-122.56363, 38.09132], [-122.56307, 38.09144], [-122.56273, 38.09148], [-122.56258, 38.09148], [-122.56254, 38.09144], [-122.56251, 38.09119], [-122.56243, 38.09095], [-122.5623, 38.09072], [-122.56211, 38.0905], [-122.5621, 38.09045], [-122.56212, 38.09041], [-122.56317, 38.08963], [-122.56348, 38.09013], [-122.56403, 38.08993], [-122.56403, 38.08991], [-122.56343, 38.08944], [-122.5639, 38.08908], [-122.56397, 38.08907], [-122.56415, 38.08921], [-122.5643, 38.08938], [-122.56402, 38.0895], [-122.56499, 38.09122]]], [[[-122.56339, 38.08909], [-122.563, 38.08938], [-122.56292, 38.08939], [-122.56206, 38.0887], [-122.56247, 38.08858], [-122.56263, 38.08846], [-122.56339, 38.08909]]], [[[-122.5639, 38.09389], [-122.5639, 38.09389], [-122.5638, 38.0939], [-122.56385, 38.09385], [-122.5639, 38.09383], [-122.5639, 38.09389]]], [[[-122.56472, 38.08923], [-122.56463, 38.08926], [-122.56447, 38.08896], [-122.5646, 38.08909], [-122.56472, 38.08923]]]]} Open Access 1 602 Scottsdale Marsh 25215 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 50.692 Scottsdale Marsh   None 482  

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