calands: units_with_maps: 2 rows where ACCESS_TYP = 3, GAP_STS = 2 and MNG

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

2 rows where ACCESS_TYP = 3, GAP_STS = 2 and MNG_AGENCY = 814

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
6810	6810	6809	{"type": "MultiPolygon", "coordinates": [[[[-122.65173, 37.90384], [-122.65158, 37.90401], [-122.65115, 37.90382], [-122.65129, 37.90362], [-122.65173, 37.90384]]], [[[-122.81765, 38.06146], [-122.81754, 38.06146], [-122.81245, 38.06286], [-122.81194, 38.06173], [-122.81125, 38.0612], [-122.81059, 38.06056], [-122.81039, 38.06027], [-122.81315, 38.06025], [-122.812, 38.0582], [-122.81371, 38.05837], [-122.81468, 38.05828], [-122.81566, 38.05855], [-122.81608, 38.05902], [-122.81638, 38.05949], [-122.81568, 38.05977], [-122.8158, 38.06056], [-122.81601, 38.06082], [-122.8167, 38.06063], [-122.81701, 38.06047], [-122.81765, 38.06146]]], [[[-122.84113, 38.10518], [-122.84095, 38.10548], [-122.84078, 38.10549], [-122.84085, 38.1053], [-122.84071, 38.10517], [-122.8379, 38.10183], [-122.83231, 38.09736], [-122.8317, 38.09725], [-122.83173, 38.09716], [-122.83238, 38.09725], [-122.83803, 38.10165], [-122.84015, 38.10423], [-122.84113, 38.10518]]], [[[-122.83548, 38.08171], [-122.8341, 38.08231], [-122.83189, 38.08006], [-122.83318, 38.07953], [-122.83486, 38.08077], [-122.83548, 38.08171]]], [[[-122.84228, 38.08864], [-122.84103, 38.08934], [-122.84025, 38.08854], [-122.8415, 38.08785], [-122.84196, 38.08828], [-122.84228, 38.08864]]], [[[-122.85899, 38.10407], [-122.85845, 38.10455], [-122.85783, 38.10436], [-122.85849, 38.10377], [-122.85899, 38.10407]]], [[[-122.88891, 38.15011], [-122.88843, 38.15017], [-122.88843, 38.15004], [-122.88809, 38.14962], [-122.88773, 38.14911], [-122.88745, 38.14878], [-122.8871, 38.14862], [-122.88702, 38.1485], [-122.88743, 38.14817], [-122.88891, 38.15011]]], [[[-122.90414, 38.17203], [-122.90388, 38.1729], [-122.90099, 38.17342], [-122.90073, 38.17342], [-122.90071, 38.17341], [-122.90057, 38.17348], [-122.89968, 38.17359], [-122.89957, 38.17346], [-122.89817, 38.17223], [-122.89797, 38.1721], [-122.89788, 38.17201], [-122.8981, 38.17137], [-122.89817, 38.17107], [-122.89817, 38.17075], [-122.89666, 38.16946], [-122.89646, 38.16909], [-122.89614, 38.16871], [-122.89591, 38.16839], [-122.89553, 38.16803], [-122.89503, 38.16771], [-122.89481, 38.16759], [-122.89522, 38.16725], [-122.89567, 38.16713], [-122.89675, 38.16701], [-122.89643, 38.16566], [-122.89875, 38.16535], [-122.89916, 38.16474], [-122.89978, 38.16476], [-122.89978, 38.16475], [-122.89764, 38.16335], [-122.8959, 38.16296], [-122.89509, 38.16292], [-122.89436, 38.16304], [-122.89316, 38.16389], [-122.89236, 38.16462], [-122.89211, 38.16516], [-122.89186, 38.16501], [-122.89146, 38.16489], [-122.89135, 38.16483], [-122.89129, 38.16478], [-122.89125, 38.16471], [-122.89124, 38.1646], [-122.89127, 38.16448], [-122.89132, 38.16436], [-122.8914, 38.16425], [-122.8915, 38.16416], [-122.89186, 38.1639], [-122.89328, 38.16265], [-122.89357, 38.16257], [-122.89441, 38.16289], [-122.8947, 38.16257], [-122.89613, 38.16248], [-122.89614, 38.16233], [-122.89659, 38.16232], [-122.89876, 38.16323], [-122.89926, 38.16406], [-122.8998, 38.16436], [-122.8998, 38.16438], [-122.9005, 38.16468], [-122.90055, 38.16467], [-122.9016, 38.16537], [-122.90178, 38.16563], [-122.90182, 38.16565], [-122.90374, 38.16866], [-122.90376, 38.17108], [-122.90414, 38.17203]]], [[[-122.8953, 38.15984], [-122.89499, 38.16023], [-122.89451, 38.16011], [-122.89461, 38.15988], [-122.89466, 38.15964], [-122.89466, 38.15951], [-122.89463, 38.15927], [-122.89519, 38.15913], [-122.89532, 38.15957], [-122.8953, 38.15984]]], [[[-122.9089, 38.17946], [-122.90852, 38.17959], [-122.90767, 38.17868], [-122.90822, 38.1784], [-122.90889, 38.17903], [-122.9089, 38.17946]]], [[[-122.91023, 38.18131], [-122.90988, 38.18144], [-122.90983, 38.18128], [-122.90925, 38.18048], [-122.9092, 38.18027], [-122.90917, 38.18024], [-122.90944, 38.18015], [-122.90968, 38.18042], [-122.91023, 38.18131]]], [[[-122.9139, 38.18884], [-122.91364, 38.18905], [-122.91333, 38.18876], [-122.91308, 38.18846], [-122.91357, 38.18817], [-122.91378, 38.18817], [-122.9139, 38.18884]]], [[[-122.9214, 38.19643], [-122.9201, 38.19691], [-122.91995, 38.19678], [-122.9198, 38.19668], [-122.91973, 38.1966], [-122.91967, 38.1965], [-122.91962, 38.19635], [-122.91961, 38.19605], [-122.91957, 38.19585], [-122.91937, 38.19542], [-122.91927, 38.19517], [-122.92039, 38.19433], [-122.92138, 38.19633], [-122.9214, 38.19643]]], [[[-122.93386, 38.21111], [-122.9338, 38.21165], [-122.93265, 38.21197], [-122.93186, 38.21209], [-122.93142, 38.21286], [-122.92912, 38.21517], [-122.92848, 38.21643], [-122.9281, 38.21748], [-122.9263, 38.21878], [-122.92671, 38.21776], [-122.92653, 38.21229], [-122.92681, 38.20867], [-122.92772, 38.20701], [-122.92895, 38.20698], [-122.92999, 38.20915], [-122.93386, 38.21111]]], [[[-122.95406, 38.21874], [-122.95301, 38.22084], [-122.95266, 38.22165], [-122.95101, 38.22065], [-122.94925, 38.22001], [-122.94862, 38.21989], [-122.94773, 38.22016], [-122.94698, 38.21992], [-122.94759, 38.21871], [-122.94857, 38.21768], [-122.94896, 38.21746], [-122.94924, 38.2168], [-122.95, 38.21597], [-122.94996, 38.21568], [-122.95169, 38.21495], [-122.95283, 38.21445], [-122.95303, 38.21456], [-122.9531, 38.21482], [-122.95354, 38.21541], [-122.95386, 38.21699], [-122.95364, 38.2184], [-122.95369, 38.21852], [-122.95406, 38.21874]]]]}	No Public Access 3	5363	Audubon Canyon Ranch	15702	3005	Audubon Canyon Ranch 837	Non Profit 6	Non Profit - Conservation 12	http://www.egret.org	Non Governmental Organization 10	3005	Audubon Canyon Ranch 814	Non Profit 6	Non Profit - Conservation 12		Marin 23	380.201	Audubon Canyon Ranch	0	Private Conservation 16	2
15642	15642	15641	{"type": "Polygon", "coordinates": [[[-122.7593, 38.69993], [-122.75919, 38.70741], [-122.75872, 38.7141], [-122.7511, 38.71424], [-122.7511, 38.72102], [-122.74372, 38.72095], [-122.73443, 38.72113], [-122.73435, 38.72474], [-122.72489, 38.72494], [-122.72492, 38.72128], [-122.72038, 38.72127], [-122.72039, 38.71391], [-122.72507, 38.71387], [-122.72506, 38.71074], [-122.72548, 38.7106], [-122.72596, 38.71055], [-122.72626, 38.71048], [-122.72695, 38.71021], [-122.72733, 38.71014], [-122.72789, 38.70998], [-122.7289, 38.70972], [-122.72889, 38.70667], [-122.73433, 38.70664], [-122.73433, 38.69959], [-122.74354, 38.69953], [-122.7593, 38.69993]]]}	No Public Access 3	38036	Modini Ingalls Ecological Preserve	22341	3005	Audubon Canyon Ranch 837	Non Profit 6	Non Profit - Conservation 12	http://www.egret.org	Non Governmental Organization 10	3005	Audubon Canyon Ranch 814	Non Profit 6	Non Profit - Conservation 12		Sonoma 16	1585.152	Modini Ingalls EP	0	Private Conservation 16	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]);