calands: units_with_maps: 1 row where DES_TP = 4, MNG_AGENCY = 43 and PARK_URL = "http://www.marincounty.org/depts/pk/divisions/open-space/mount-burdell"

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

1 row where DES_TP = 4, MNG_AGENCY = 43 and PARK_URL = "http://www.marincounty.org/depts/pk/divisions/open-space/mount-burdell"

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
15924	15924	15923	{"type": "Polygon", "coordinates": [[[-122.61533, 38.12598], [-122.61493, 38.1262], [-122.61439, 38.12871], [-122.61418, 38.12925], [-122.61368, 38.12995], [-122.61238, 38.13142], [-122.61171, 38.13244], [-122.6117, 38.13282], [-122.61072, 38.13467], [-122.60983, 38.13621], [-122.60916, 38.13774], [-122.60842, 38.13882], [-122.60855, 38.14775], [-122.60705, 38.1472], [-122.60106, 38.14798], [-122.59468, 38.14646], [-122.59238, 38.14593], [-122.58737, 38.14183], [-122.57955, 38.14374], [-122.57931, 38.14375], [-122.58049, 38.13628], [-122.57556, 38.13231], [-122.57611, 38.13144], [-122.57684, 38.13001], [-122.57656, 38.13005], [-122.57561, 38.12926], [-122.57403, 38.12993], [-122.57385, 38.12979], [-122.57362, 38.12964], [-122.57338, 38.12953], [-122.57316, 38.12946], [-122.57357, 38.12903], [-122.57352, 38.12893], [-122.57348, 38.12888], [-122.57332, 38.12879], [-122.57348, 38.1286], [-122.57358, 38.1284], [-122.57404, 38.12851], [-122.57426, 38.12793], [-122.57426, 38.1279], [-122.57429, 38.1278], [-122.57498, 38.12784], [-122.57519, 38.12789], [-122.5755, 38.12788], [-122.57568, 38.12791], [-122.57623, 38.12787], [-122.57654, 38.12777], [-122.57636, 38.12744], [-122.57649, 38.12739], [-122.57668, 38.12763], [-122.57701, 38.12789], [-122.57752, 38.12753], [-122.57737, 38.12714], [-122.57751, 38.12697], [-122.57771, 38.12677], [-122.57871, 38.12653], [-122.57873, 38.12635], [-122.57836, 38.12627], [-122.57826, 38.12622], [-122.57825, 38.12617], [-122.5782, 38.12613], [-122.57812, 38.12611], [-122.57806, 38.12612], [-122.57794, 38.12593], [-122.57749, 38.1259], [-122.5773, 38.12585], [-122.57682, 38.12569], [-122.57668, 38.1256], [-122.57654, 38.1254], [-122.57628, 38.12495], [-122.57584, 38.1251], [-122.57576, 38.12497], [-122.57616, 38.12483], [-122.57648, 38.12464], [-122.57646, 38.12415], [-122.57647, 38.12387], [-122.57594, 38.12389], [-122.57593, 38.12383], [-122.57589, 38.12378], [-122.5762, 38.12347], [-122.5762, 38.12345], [-122.57515, 38.12335], [-122.57558, 38.12123], [-122.57661, 38.12098], [-122.57704, 38.12091], [-122.57733, 38.12088], [-122.57762, 38.12087], [-122.57806, 38.12088], [-122.5792, 38.12099], [-122.57941, 38.12102], [-122.57993, 38.12115], [-122.58069, 38.12146], [-122.58091, 38.12151], [-122.58112, 38.12154], [-122.58135, 38.12155], [-122.58163, 38.12152], [-122.58244, 38.12132], [-122.58262, 38.12129], [-122.58294, 38.12129], [-122.58321, 38.12131], [-122.58322, 38.12202], [-122.5842, 38.1226], [-122.58378, 38.12349], [-122.58342, 38.12338], [-122.58373, 38.12276], [-122.58306, 38.12236], [-122.58224, 38.12253], [-122.58178, 38.12369], [-122.58224, 38.12377], [-122.58221, 38.12399], [-122.58223, 38.12422], [-122.58234, 38.12456], [-122.58247, 38.12474], [-122.58141, 38.12533], [-122.58118, 38.12565], [-122.58134, 38.12598], [-122.58162, 38.12574], [-122.58168, 38.12577], [-122.58175, 38.12576], [-122.58174, 38.12582], [-122.58191, 38.126], [-122.58227, 38.1263], [-122.58261, 38.12669], [-122.5828, 38.12686], [-122.58335, 38.1272], [-122.584, 38.12735], [-122.58487, 38.1252], [-122.58546, 38.12533], [-122.58577, 38.12537], [-122.58599, 38.12497], [-122.5867, 38.12544], [-122.58718, 38.1257], [-122.58794, 38.12582], [-122.58789, 38.12606], [-122.58778, 38.12647], [-122.5883, 38.12658], [-122.5891, 38.12662], [-122.59028, 38.1266], [-122.59041, 38.12642], [-122.59052, 38.12648], [-122.59059, 38.12645], [-122.59084, 38.12612], [-122.59114, 38.12626], [-122.59132, 38.12607], [-122.5916, 38.12624], [-122.59162, 38.12623], [-122.59179, 38.12632], [-122.59179, 38.12633], [-122.59209, 38.12652], [-122.59228, 38.12635], [-122.59261, 38.12609], [-122.59261, 38.12606], [-122.59276, 38.12598], [-122.59271, 38.1259], [-122.593, 38.12566], [-122.59295, 38.12562], [-122.5933, 38.12525], [-122.59327, 38.12522], [-122.59358, 38.12499], [-122.59353, 38.12465], [-122.59358, 38.12453], [-122.59368, 38.12453], [-122.59377, 38.12447], [-122.59378, 38.12442], [-122.59377, 38.12437], [-122.59398, 38.12409], [-122.59393, 38.12397], [-122.59399, 38.12395], [-122.59397, 38.12388], [-122.59417, 38.12383], [-122.59419, 38.12385], [-122.59439, 38.1238], [-122.59439, 38.12377], [-122.59482, 38.12366], [-122.59483, 38.12367], [-122.59524, 38.12355], [-122.59525, 38.12355], [-122.59543, 38.12351], [-122.59574, 38.12452], [-122.59649, 38.12448], [-122.59682, 38.12461], [-122.59684, 38.12457], [-122.59746, 38.12469], [-122.59863, 38.12416], [-122.59874, 38.1243], [-122.59886, 38.1242], [-122.59944, 38.12431], [-122.59933, 38.12472], [-122.5999, 38.12476], [-122.60042, 38.12439], [-122.60059, 38.12524], [-122.60092, 38.1267], [-122.60101, 38.12705], [-122.60118, 38.12743], [-122.60139, 38.12782], [-122.60157, 38.12808], [-122.60185, 38.12846], [-122.60221, 38.12884], [-122.60339, 38.12859], [-122.60371, 38.12907], [-122.60383, 38.12928], [-122.60424, 38.13042], [-122.60567, 38.13069], [-122.60584, 38.13022], [-122.60649, 38.13033], [-122.60674, 38.12935], [-122.60505, 38.12705], [-122.60639, 38.12616], [-122.60541, 38.12565], [-122.6049, 38.12499], [-122.60505, 38.1246], [-122.60515, 38.12445], [-122.60601, 38.12394], [-122.60619, 38.12397], [-122.60642, 38.12414], [-122.60644, 38.12414], [-122.60642, 38.12313], [-122.60643, 38.12308], [-122.60644, 38.12308], [-122.60649, 38.12459], [-122.60717, 38.12456], [-122.60757, 38.12402], [-122.60849, 38.12353], [-122.61185, 38.12361], [-122.61282, 38.12404], [-122.61282, 38.12352], [-122.61243, 38.12293], [-122.61234, 38.1226], [-122.61205, 38.1226], [-122.61203, 38.12256], [-122.61232, 38.12253], [-122.61226, 38.12225], [-122.61237, 38.12228], [-122.61249, 38.1226], [-122.61251, 38.1228], [-122.61292, 38.12315], [-122.61335, 38.12358], [-122.61373, 38.12407], [-122.61394, 38.12441], [-122.61413, 38.12476], [-122.61428, 38.12512], [-122.61448, 38.12575], [-122.61533, 38.12598]], [[-122.59435, 38.14496], [-122.59435, 38.14494], [-122.59403, 38.14463], [-122.59363, 38.14489], [-122.59395, 38.14521], [-122.59435, 38.14496]], [[-122.60009, 38.12798], [-122.5998, 38.12745], [-122.59897, 38.12769], [-122.59888, 38.12775], [-122.59883, 38.12781], [-122.59882, 38.12787], [-122.59882, 38.12824], [-122.59884, 38.12835], [-122.59887, 38.12842], [-122.59893, 38.1285], [-122.599, 38.12857], [-122.59912, 38.12864], [-122.59923, 38.12867], [-122.59935, 38.12869], [-122.59948, 38.12868], [-122.5996, 38.12866], [-122.60003, 38.1285], [-122.60009, 38.12798]], [[-122.60746, 38.13228], [-122.60747, 38.13227], [-122.60722, 38.13181], [-122.60644, 38.13206], [-122.60669, 38.13253], [-122.60746, 38.13228]]]}	Open Access 1	18091	Mount Burdell Open Space Preserve	31440	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/mount-burdell	Marin 23	1626.378	Mount Burdell OSP	1977	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]);