calands: units_with_maps: 1 row where DES_TP = 4, MNG_AG_TYP = 4 and UNIT

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

1 row where DES_TP = 4, MNG_AG_TYP = 4 and UNIT_NAME = "Loma Verde Open Space Preserve"

Search:

descending

This data as json, copyable, CSV (advanced)

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
15906	15906	15905	{"type": "Polygon", "coordinates": [[[-122.55433, 38.0614], [-122.55411, 38.0614], [-122.55399, 38.06138], [-122.55385, 38.0614], [-122.55354, 38.06151], [-122.55342, 38.06158], [-122.55331, 38.06159], [-122.55311, 38.06166], [-122.55305, 38.0617], [-122.55294, 38.06174], [-122.55281, 38.06174], [-122.55254, 38.06178], [-122.55209, 38.06205], [-122.55198, 38.06208], [-122.5517, 38.06212], [-122.5515, 38.06217], [-122.55136, 38.06223], [-122.55126, 38.0623], [-122.55121, 38.06238], [-122.55118, 38.06247], [-122.55141, 38.06263], [-122.55153, 38.06277], [-122.55156, 38.06285], [-122.55156, 38.06295], [-122.55153, 38.06305], [-122.55132, 38.06341], [-122.55121, 38.06354], [-122.55118, 38.0636], [-122.55092, 38.06382], [-122.55078, 38.064], [-122.55056, 38.06415], [-122.5504, 38.06422], [-122.55028, 38.0643], [-122.55003, 38.0646], [-122.55002, 38.06468], [-122.55008, 38.06475], [-122.55019, 38.06477], [-122.55056, 38.06471], [-122.55098, 38.06467], [-122.55072, 38.06491], [-122.55128, 38.06564], [-122.55128, 38.06566], [-122.55097, 38.0657], [-122.5502, 38.06594], [-122.54972, 38.06594], [-122.54902, 38.06591], [-122.5489, 38.06563], [-122.54884, 38.06532], [-122.54876, 38.06525], [-122.54854, 38.06345], [-122.54861, 38.06343], [-122.54868, 38.06397], [-122.54977, 38.06387], [-122.54962, 38.06258], [-122.54844, 38.06267], [-122.54824, 38.06115], [-122.54961, 38.06054], [-122.54924, 38.06], [-122.54806, 38.06013], [-122.5479, 38.05898], [-122.54634, 38.05915], [-122.54642, 38.05974], [-122.54653, 38.05999], [-122.54628, 38.0601], [-122.54338, 38.05949], [-122.5428, 38.06105], [-122.543, 38.06218], [-122.54174, 38.0625], [-122.54178, 38.06298], [-122.54122, 38.06315], [-122.54106, 38.06323], [-122.54091, 38.06334], [-122.54085, 38.06336], [-122.54051, 38.06313], [-122.5386, 38.06219], [-122.5383, 38.0621], [-122.53695, 38.06187], [-122.53698, 38.06171], [-122.53683, 38.06158], [-122.53733, 38.06052], [-122.53647, 38.05977], [-122.53603, 38.05984], [-122.53552, 38.05936], [-122.53599, 38.05918], [-122.53597, 38.05869], [-122.53571, 38.05832], [-122.53593, 38.05791], [-122.53566, 38.05775], [-122.53572, 38.05758], [-122.53578, 38.05751], [-122.53604, 38.05737], [-122.53659, 38.0573], [-122.53669, 38.05534], [-122.53981, 38.05538], [-122.54195, 38.05604], [-122.54331, 38.05555], [-122.5497, 38.05414], [-122.5507, 38.05475], [-122.55109, 38.0548], [-122.55291, 38.05517], [-122.55343, 38.05531], [-122.55322, 38.05542], [-122.55323, 38.05553], [-122.55344, 38.0557], [-122.55346, 38.05577], [-122.55342, 38.05581], [-122.55345, 38.05593], [-122.5532, 38.05635], [-122.55316, 38.05643], [-122.55316, 38.05656], [-122.55326, 38.05667], [-122.55357, 38.05678], [-122.55368, 38.05684], [-122.55379, 38.05692], [-122.55384, 38.05718], [-122.55385, 38.058], [-122.5539, 38.05838], [-122.55387, 38.05882], [-122.55382, 38.05906], [-122.55376, 38.05915], [-122.55376, 38.05933], [-122.55373, 38.05945], [-122.55371, 38.05961], [-122.55376, 38.05975], [-122.55383, 38.05985], [-122.5538, 38.0599], [-122.5538, 38.05995], [-122.55385, 38.06008], [-122.55387, 38.06018], [-122.55382, 38.06071], [-122.55384, 38.06085], [-122.5539, 38.06097], [-122.55406, 38.06114], [-122.55417, 38.0612], [-122.55424, 38.06126], [-122.55432, 38.0613], [-122.55433, 38.0614]], [[-122.5416, 38.06091], [-122.54164, 38.06118], [-122.54179, 38.06089], [-122.54181, 38.06076], [-122.54181, 38.06063], [-122.54148, 38.06069], [-122.5416, 38.06091]]]}	Open Access 1	17418	Loma Verde Open Space Preserve	6293	2070	Marin County Open Space District 44	Special District 4	Recreation/Parks District 4	http://www.marincountyparks.org/Depts/PK.aspx	Special District 4	2070	Marin County Open Space District 43	Special District 4	Recreation/Parks District 4	http://www.marincounty.org/depts/pk/divisions/open-space/loma-verde	Marin 23	277.565	Loma Verde OSP	1975	Local Conservation Area 4	2

Advanced export

JSON shape: default, array, newline-delimited

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