calands: units_with_maps: 1 row where DES_TP = 3, MNG_AGENCY = 150 and UNIT

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

1 row where DES_TP = 3, MNG_AGENCY = 150 and UNIT_NAME = "Corte Madera Creek Path"

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
14527	14527	14526	{"type": "MultiPolygon", "coordinates": [[[[-122.54844, 37.95431], [-122.54842, 37.95436], [-122.54741, 37.95403], [-122.54721, 37.95401], [-122.54654, 37.95404], [-122.54635, 37.95402], [-122.54612, 37.95396], [-122.54596, 37.95389], [-122.54586, 37.95384], [-122.54575, 37.95373], [-122.54566, 37.95356], [-122.54563, 37.95344], [-122.54563, 37.95333], [-122.54587, 37.95255], [-122.54588, 37.95236], [-122.54585, 37.95219], [-122.54577, 37.95201], [-122.5453, 37.95168], [-122.54523, 37.95158], [-122.54469, 37.95013], [-122.54418, 37.94896], [-122.54412, 37.94889], [-122.54401, 37.94869], [-122.54384, 37.94852], [-122.54359, 37.94836], [-122.54332, 37.94827], [-122.53985, 37.94776], [-122.53949, 37.94766], [-122.53916, 37.94751], [-122.53891, 37.94736], [-122.53871, 37.94721], [-122.53854, 37.94703], [-122.53838, 37.94683], [-122.5383, 37.94668], [-122.53822, 37.9465], [-122.53793, 37.94547], [-122.53784, 37.94537], [-122.53761, 37.94526], [-122.53765, 37.94521], [-122.53789, 37.94533], [-122.53796, 37.9454], [-122.53799, 37.94546], [-122.53828, 37.94648], [-122.53836, 37.94666], [-122.53847, 37.94683], [-122.53861, 37.94702], [-122.53879, 37.94719], [-122.53899, 37.94734], [-122.53921, 37.94747], [-122.5396, 37.94764], [-122.54, 37.94773], [-122.5413, 37.94791], [-122.54334, 37.94822], [-122.54364, 37.94832], [-122.5439, 37.94849], [-122.54408, 37.94869], [-122.54424, 37.94891], [-122.54472, 37.95003], [-122.54529, 37.95156], [-122.54536, 37.95165], [-122.54568, 37.95186], [-122.54583, 37.95198], [-122.54592, 37.95218], [-122.54595, 37.95236], [-122.54594, 37.95256], [-122.5457, 37.95332], [-122.54572, 37.95352], [-122.5458, 37.9537], [-122.54586, 37.95376], [-122.54599, 37.95383], [-122.54635, 37.95396], [-122.54654, 37.95398], [-122.54721, 37.95396], [-122.54744, 37.95398], [-122.54753, 37.954], [-122.54761, 37.95404], [-122.5479, 37.95414], [-122.54844, 37.95431]]], [[[-122.55647, 37.96234], [-122.5564, 37.96235], [-122.55602, 37.96196], [-122.55591, 37.96174], [-122.55566, 37.96141], [-122.55529, 37.96105], [-122.55441, 37.9604], [-122.55409, 37.96013], [-122.55284, 37.95885], [-122.55277, 37.95873], [-122.55273, 37.95863], [-122.5527, 37.95852], [-122.5527, 37.9584], [-122.55273, 37.95821], [-122.55288, 37.95785], [-122.55291, 37.95772], [-122.5529, 37.95758], [-122.55284, 37.95744], [-122.55249, 37.95685], [-122.5523, 37.95649], [-122.55215, 37.95625], [-122.55194, 37.95601], [-122.55172, 37.95578], [-122.55131, 37.95539], [-122.55135, 37.95534], [-122.552, 37.95598], [-122.55221, 37.95623], [-122.55237, 37.95647], [-122.55255, 37.95683], [-122.55291, 37.95742], [-122.55297, 37.95757], [-122.55297, 37.95777], [-122.55293, 37.95794], [-122.55279, 37.95825], [-122.55276, 37.95843], [-122.5528, 37.95863], [-122.5529, 37.95882], [-122.55415, 37.96009], [-122.55446, 37.96036], [-122.55535, 37.96101], [-122.55546, 37.96113], [-122.55571, 37.96137], [-122.55587, 37.96158], [-122.55597, 37.96172], [-122.55608, 37.96194], [-122.55647, 37.96234]]]]}	Open Access 1	47191	Corte Madera Creek Path	30883	306	Marin County Parks Department, County of 154	County 3	County Agency - Parks 7	http://www.marincountyparks.org/depts/pk	County 3	306	Marin County Parks Department, County of 150	County 3	County Agency - Parks 7		Marin 23	3.865	Corte Madera Creek Path	0	Local Recreation Area 3	4

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