calands: units_with_maps: 9 rows where ACCESS_TYP = 2, AGNCY_NAME = 245 and MNG

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

9 rows where ACCESS_TYP = 2, AGNCY_NAME = 245 and MNG_AGENCY = 241

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	DES_TP	GAP_STS
2442	2442	2441	{"type": "Polygon", "coordinates": [[[-122.4923, 38.11974], [-122.49219, 38.12381], [-122.48094, 38.13068], [-122.47815, 38.13213], [-122.47787, 38.13223], [-122.47757, 38.13227], [-122.47646, 38.13226], [-122.47621, 38.13224], [-122.47598, 38.13216], [-122.47578, 38.13203], [-122.47568, 38.13193], [-122.47541, 38.13154], [-122.47473, 38.13141], [-122.47237, 38.12844], [-122.48847, 38.12189], [-122.48949, 38.12141], [-122.49045, 38.1209], [-122.4914, 38.12034], [-122.4923, 38.11974]]]}	Restricted Access 2	17347	Leonard Ranch	21175	3082	Sonoma Land Trust 245	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10		Sonoma 16	219.848	Leonard Ranch	Private Conservation 16	2
3508	3508	3507	{"type": "Polygon", "coordinates": [[[-123.14011, 38.61069], [-123.13538, 38.61068], [-123.13529, 38.6071], [-123.14003, 38.60711], [-123.14011, 38.61069]]]}	Restricted Access 2	26072	Cedars Gateway	30373	3082	Sonoma Land Trust 245	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10		Sonoma 16	40.534	Cedars Gateway	Private Conservation 16	2
3684	3684	3683	{"type": "Polygon", "coordinates": [[[-122.64173, 38.60305], [-122.64139, 38.60371], [-122.64065, 38.60495], [-122.64036, 38.60548], [-122.64015, 38.60613], [-122.64142, 38.60642], [-122.64113, 38.60681], [-122.64038, 38.60761], [-122.64021, 38.60798], [-122.63973, 38.60812], [-122.63931, 38.60891], [-122.63908, 38.60915], [-122.63908, 38.60927], [-122.6389, 38.6093], [-122.63896, 38.6094], [-122.63896, 38.60946], [-122.63892, 38.60957], [-122.63883, 38.60973], [-122.63934, 38.61024], [-122.63977, 38.61055], [-122.6392, 38.61208], [-122.63885, 38.61242], [-122.63794, 38.61266], [-122.63741, 38.61285], [-122.63708, 38.61305], [-122.63665, 38.61321], [-122.63644, 38.61346], [-122.63622, 38.61393], [-122.63559, 38.61441], [-122.63451, 38.61471], [-122.63408, 38.61584], [-122.63377, 38.61611], [-122.63334, 38.61617], [-122.6331, 38.61632], [-122.6332, 38.61993], [-122.63268, 38.6202], [-122.63189, 38.61971], [-122.63037, 38.61881], [-122.6353, 38.6131], [-122.62958, 38.61021], [-122.6304, 38.60914], [-122.63082, 38.60869], [-122.63075, 38.60682], [-122.63205, 38.60665], [-122.63674, 38.6055], [-122.63736, 38.6052], [-122.63722, 38.60482], [-122.63659, 38.60373], [-122.63589, 38.60226], [-122.6365, 38.6021], [-122.63719, 38.60238], [-122.6384, 38.6036], [-122.63847, 38.60361], [-122.6402, 38.60343], [-122.64173, 38.60305]]]}	Restricted Access 2	29785	Live Oaks Ranch	21378	3082	Sonoma Land Trust 245	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10		Napa 11	189.718	Live Oaks Ranch	Private Conservation 16	2
4210	4210	4209	{"type": "Polygon", "coordinates": [[[-122.47197, 38.1283], [-122.4645, 38.13105], [-122.44704, 38.13795], [-122.44644, 38.13823], [-122.44615, 38.13839], [-122.44568, 38.13872], [-122.44545, 38.13897], [-122.44525, 38.1392], [-122.44504, 38.13949], [-122.44486, 38.13977], [-122.44471, 38.14006], [-122.44458, 38.14035], [-122.44446, 38.14067], [-122.44437, 38.141], [-122.44428, 38.14149], [-122.44372, 38.14707], [-122.44374, 38.14738], [-122.44379, 38.14769], [-122.44391, 38.14814], [-122.444, 38.14835], [-122.44409, 38.14851], [-122.44427, 38.14876], [-122.44452, 38.14903], [-122.44526, 38.14959], [-122.44458, 38.14983], [-122.44386, 38.14899], [-122.44332, 38.14857], [-122.44119, 38.1476], [-122.43736, 38.14574], [-122.43544, 38.14477], [-122.43452, 38.14398], [-122.43428, 38.14347], [-122.43428, 38.14324], [-122.43463, 38.14305], [-122.43581, 38.14269], [-122.43858, 38.14212], [-122.44008, 38.14139], [-122.44194, 38.13975], [-122.44273, 38.13902], [-122.44346, 38.1384], [-122.44341, 38.13799], [-122.44356, 38.13762], [-122.44369, 38.13768], [-122.4437, 38.13766], [-122.44276, 38.13578], [-122.44175, 38.13459], [-122.44837, 38.12832], [-122.44877, 38.12827], [-122.44917, 38.12819], [-122.44956, 38.1281], [-122.44994, 38.12799], [-122.4503, 38.12785], [-122.45066, 38.1277], [-122.45101, 38.12753], [-122.45134, 38.12733], [-122.45165, 38.12713], [-122.45195, 38.1269], [-122.45222, 38.12666], [-122.45248, 38.12641], [-122.45278, 38.12614], [-122.45307, 38.12587], [-122.45333, 38.12558], [-122.45358, 38.12529], [-122.45381, 38.12498], [-122.45402, 38.12467], [-122.45455, 38.12282], [-122.45528, 38.12149], [-122.45577, 38.1208], [-122.45771, 38.11917], [-122.45865, 38.11863], [-122.45944, 38.1183], [-122.46431, 38.11785], [-122.46604, 38.11802], [-122.46687, 38.1184], [-122.46755, 38.11832], [-122.46856, 38.11787], [-122.46924, 38.1173], [-122.47014, 38.11694], [-122.47078, 38.11682], [-122.47175, 38.11735], [-122.47439, 38.11866], [-122.4745, 38.11878], [-122.47456, 38.11893], [-122.47451, 38.11926], [-122.47326, 38.12358], [-122.47206, 38.12591], [-122.47068, 38.12757], [-122.47164, 38.12826], [-122.47197, 38.1283]]]}	Restricted Access 2	44951	Sears Point Tidal Marsh Restoration	25247	3082	Sonoma Land Trust 245	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10		Sonoma 16	945.166	Sears Point Tidal Marsh Restoration	Private Conservation 16	2
6646	6646	6645	{"type": "MultiPolygon", "coordinates": [[[[-122.51527, 38.37001], [-122.51519, 38.37008], [-122.51534, 38.3703], [-122.51546, 38.37054], [-122.51559, 38.37091], [-122.51563, 38.37129], [-122.51562, 38.37155], [-122.51553, 38.37193], [-122.51537, 38.37229], [-122.5153, 38.37241], [-122.51491, 38.37287], [-122.51118, 38.37404], [-122.51013, 38.37434], [-122.51015, 38.37307], [-122.50548, 38.37304], [-122.50521, 38.37843], [-122.50043, 38.37993], [-122.49924, 38.37749], [-122.49835, 38.37301], [-122.50062, 38.37298], [-122.50067, 38.3693], [-122.50109, 38.36935], [-122.50814, 38.36943], [-122.51383, 38.36841], [-122.51527, 38.37001]]], [[[-122.51662, 38.37234], [-122.51662, 38.37234], [-122.51535, 38.37273], [-122.51611, 38.3718], [-122.51628, 38.37168], [-122.51662, 38.37234]]]]}	Restricted Access 2	4664	Glen Oaks Ranch	30371	3082	Sonoma Land Trust 245	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10		Sonoma 16	237.145	Glen Oaks Ranch	Private Conservation 16	2
10499	10499	10498	{"type": "MultiPolygon", "coordinates": [[[[-122.50461, 38.11713], [-122.50461, 38.11714], [-122.50399, 38.11757], [-122.50451, 38.11703], [-122.50461, 38.11713]]], [[[-122.50863, 38.1256], [-122.50826, 38.12589], [-122.5074, 38.1264], [-122.5073, 38.12632], [-122.5077, 38.12596], [-122.50808, 38.12568], [-122.50863, 38.1256]]]]}	Restricted Access 2	18650	Petaluma River Marsh	23624	3082	Sonoma Land Trust 245	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10		Sonoma 16	0.8	Petaluma River Marsh	Private Conservation 16	2
12739	12739	12738	{"type": "Polygon", "coordinates": [[[-123.00187, 38.31464], [-123.00168, 38.31468], [-123.00149, 38.31469], [-123.0013, 38.31467], [-123.00099, 38.31458], [-123.00054, 38.31452], [-122.9992, 38.31445], [-122.99866, 38.3144], [-122.99823, 38.31441], [-122.99803, 38.31444], [-122.99761, 38.31456], [-122.99668, 38.31508], [-122.99383, 38.31148], [-122.99215, 38.31077], [-122.99203, 38.3109], [-122.99179, 38.31125], [-122.99172, 38.31155], [-122.99169, 38.31176], [-122.98597, 38.31107], [-122.98577, 38.31048], [-122.98517, 38.30994], [-122.98578, 38.3092], [-122.98644, 38.30902], [-122.98804, 38.30885], [-122.98863, 38.30853], [-122.98887, 38.30813], [-122.98961, 38.30746], [-122.99089, 38.30638], [-122.99155, 38.30658], [-122.99309, 38.3076], [-122.99409, 38.30712], [-122.99553, 38.31018], [-123.00095, 38.31294], [-123.00187, 38.31464]]]}	Restricted Access 2	29771	Estero Americano Preserve	18725	3082	Sonoma Land Trust 245	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10		Sonoma 16	126.098	Estero Americano Preserve	Private Conservation 16	2
12752	12752	12751	{"type": "Polygon", "coordinates": [[[-122.65077, 38.61356], [-122.64992, 38.61454], [-122.63987, 38.62487], [-122.63944, 38.62453], [-122.63742, 38.62319], [-122.63268, 38.6202], [-122.6332, 38.61993], [-122.6331, 38.61632], [-122.63334, 38.61617], [-122.63377, 38.61611], [-122.63408, 38.61584], [-122.63451, 38.61471], [-122.63559, 38.6144], [-122.63622, 38.61393], [-122.63644, 38.61346], [-122.63665, 38.61321], [-122.63708, 38.61305], [-122.63741, 38.61285], [-122.63794, 38.61266], [-122.63885, 38.61242], [-122.6392, 38.61208], [-122.63977, 38.61055], [-122.63934, 38.61024], [-122.63883, 38.60973], [-122.63892, 38.60957], [-122.63896, 38.60946], [-122.63896, 38.60939], [-122.63889, 38.6093], [-122.63908, 38.60927], [-122.63908, 38.60915], [-122.63931, 38.60891], [-122.63973, 38.60812], [-122.64021, 38.60798], [-122.64038, 38.60761], [-122.64114, 38.60679], [-122.6417, 38.60607], [-122.64476, 38.60766], [-122.64556, 38.60874], [-122.64611, 38.60904], [-122.64892, 38.60685], [-122.64974, 38.60729], [-122.65027, 38.60754], [-122.64673, 38.61137], [-122.65077, 38.61356]]]}	Restricted Access 2	29784	Live Oaks Ranch	21378	3082	Sonoma Land Trust 245	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10		Sonoma 16	423.5	Live Oaks Ranch	Private Conservation 16	2
14658	14658	14657	{"type": "Polygon", "coordinates": [[[-122.41076, 38.30586], [-122.4105, 38.30586], [-122.41012, 38.30647], [-122.40815, 38.31238], [-122.40664, 38.31183], [-122.40681, 38.31136], [-122.4072, 38.31105], [-122.40728, 38.31092], [-122.40729, 38.31082], [-122.40727, 38.31073], [-122.40725, 38.31069], [-122.40711, 38.31053], [-122.40702, 38.31037], [-122.40702, 38.31023], [-122.4071, 38.31006], [-122.40718, 38.30992], [-122.40732, 38.30976], [-122.40754, 38.30964], [-122.40801, 38.3095], [-122.40842, 38.3088], [-122.40859, 38.30835], [-122.4086, 38.30803], [-122.40874, 38.30778], [-122.40884, 38.30736], [-122.40873, 38.30665], [-122.40876, 38.30618], [-122.4087, 38.30548], [-122.40881, 38.30532], [-122.40968, 38.30578], [-122.4104, 38.30572], [-122.41076, 38.30586]]]}	Restricted Access 2	44920	John Holden	28164	3082	Sonoma Land Trust 245	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/explore/interactive_map/map.php	Sonoma 16	20.987	John Holden	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]);