calands: units_with_maps: 2 rows where COUNTY = 23, DES_TP = 16 and MNG

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

2 rows where COUNTY = 23, DES_TP = 16 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
14822	14822	14821	{"type": "Polygon", "coordinates": [[[-122.69118, 37.9329], [-122.68888, 37.93441], [-122.67482, 37.94751], [-122.66036, 37.93681], [-122.66163, 37.93601], [-122.66163, 37.93599], [-122.65724, 37.93353], [-122.65725, 37.9335], [-122.6572, 37.93347], [-122.65775, 37.93261], [-122.65787, 37.93201], [-122.66228, 37.92912], [-122.66557, 37.92719], [-122.66568, 37.92715], [-122.66657, 37.92673], [-122.66708, 37.92652], [-122.66955, 37.92521], [-122.67289, 37.92396], [-122.67443, 37.92344], [-122.67464, 37.92389], [-122.67503, 37.92435], [-122.67516, 37.9246], [-122.67551, 37.92494], [-122.67583, 37.92515], [-122.67596, 37.92522], [-122.67608, 37.92525], [-122.67657, 37.92529], [-122.677, 37.92529], [-122.67779, 37.9252], [-122.67879, 37.92521], [-122.67907, 37.92527], [-122.67913, 37.92531], [-122.67927, 37.92537], [-122.67975, 37.92569], [-122.6799, 37.92577], [-122.68007, 37.92582], [-122.6803, 37.92595], [-122.68035, 37.926], [-122.6804, 37.92609], [-122.68043, 37.92618], [-122.68043, 37.92635], [-122.68049, 37.92644], [-122.68101, 37.927], [-122.68148, 37.92737], [-122.68185, 37.92762], [-122.68199, 37.92778], [-122.68205, 37.92791], [-122.68208, 37.92809], [-122.68207, 37.92836], [-122.68203, 37.92864], [-122.682, 37.92902], [-122.68201, 37.92914], [-122.68206, 37.92934], [-122.68211, 37.92948], [-122.68223, 37.92966], [-122.68246, 37.92987], [-122.68274, 37.93004], [-122.68314, 37.93023], [-122.68387, 37.93053], [-122.68406, 37.93058], [-122.68427, 37.9306], [-122.68457, 37.93059], [-122.68522, 37.93045], [-122.68529, 37.93085], [-122.68565, 37.93107], [-122.68592, 37.93102], [-122.68642, 37.93039], [-122.68675, 37.93041], [-122.68792, 37.93056], [-122.68821, 37.93071], [-122.68836, 37.93086], [-122.68845, 37.931], [-122.68849, 37.93113], [-122.68851, 37.93133], [-122.68849, 37.93148], [-122.68841, 37.93167], [-122.68843, 37.93199], [-122.68855, 37.93222], [-122.68876, 37.93235], [-122.68919, 37.93253], [-122.68963, 37.93266], [-122.68999, 37.9327], [-122.69036, 37.93269], [-122.69081, 37.93262], [-122.69093, 37.93264], [-122.69104, 37.93271], [-122.69118, 37.9329]]]}	Open Access 1	45281	Martin Griffin Preserve	21904	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	1010.785	Martin Griffin Preserve	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]);