calands: superunits_with_maps: 8 rows where ACCESS_TYP = 2, LAYER = 10 and MNG

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

8 rows where ACCESS_TYP = 2, LAYER = 10 and MNG_AGENCY = 241

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME
4063	4063	4062	{"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.99867, 38.3144], [-122.99823, 38.31441], [-122.99803, 38.31444], [-122.99761, 38.31456], [-122.99668, 38.31508], [-122.99383, 38.31148], [-122.99216, 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.98862, 38.30853], [-122.98887, 38.30813], [-122.98961, 38.30746], [-122.99089, 38.30638], [-122.99155, 38.30658], [-122.99309, 38.30759], [-122.99409, 38.30712], [-122.99553, 38.31018], [-123.00095, 38.31294], [-123.00187, 38.31464]]]}	Restricted Access 2	Estero Americano Preserve		18725	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	126.117	Estero Americano Preserve
6114	6114	6113	{"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	Leonard Ranch		21175	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	219.847	Leonard Ranch
6303	6303	6302	{"type": "Polygon", "coordinates": [[[-122.65077, 38.61356], [-122.64992, 38.61454], [-122.63987, 38.62487], [-122.63944, 38.62453], [-122.63742, 38.62319], [-122.63189, 38.61971], [-122.63037, 38.61881], [-122.63529, 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.63735, 38.6052], [-122.63722, 38.60481], [-122.63659, 38.60373], [-122.63589, 38.60226], [-122.6365, 38.6021], [-122.63719, 38.60238], [-122.63841, 38.6036], [-122.63847, 38.60361], [-122.6402, 38.60343], [-122.64173, 38.60305], [-122.64139, 38.60371], [-122.64065, 38.60495], [-122.64036, 38.60548], [-122.64015, 38.60613], [-122.64143, 38.60642], [-122.6417, 38.60607], [-122.64476, 38.60766], [-122.64556, 38.60874], [-122.6461, 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	Live Oaks Ranch		21378	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	613.366	Live Oaks Ranch
8109	8109	8108	{"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	Petaluma River Marsh		23624	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	0.799	Petaluma River Marsh
9442	9442	9441	{"type": "Polygon", "coordinates": [[[-122.47456, 38.11893], [-122.47451, 38.11926], [-122.47326, 38.12358], [-122.47206, 38.12591], [-122.47068, 38.12756], [-122.47164, 38.12826], [-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.14834], [-122.44409, 38.1485], [-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.14323], [-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.44368, 38.13767], [-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.11865], [-122.4745, 38.11878], [-122.47456, 38.11893]]]}	Restricted Access 2	Sears Point Tidal Marsh Restoration		25247	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	945.181	Sears Point Tidal Marsh Restoration
11622	11622	11621	{"type": "Polygon", "coordinates": [[[-122.41076, 38.30586], [-122.4105, 38.30587], [-122.41012, 38.30648], [-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.30949], [-122.40842, 38.3088], [-122.40858, 38.30836], [-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.40967, 38.30578], [-122.4104, 38.30572], [-122.41076, 38.30586]]]}	Restricted Access 2	John Holden	http://www.sonomalandtrust.org/explore/interactive_map/map.php	28164	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	20.99	John Holden
13106	13106	13105	{"type": "MultiPolygon", "coordinates": [[[[-122.51527, 38.37001], [-122.51519, 38.37009], [-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.51119, 38.37404], [-122.51013, 38.37434], [-122.51014, 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	Glen Oaks Ranch		30371	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	237.212	Glen Oaks Ranch
13108	13108	13107	{"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	Cedars Gateway		30373	3082	Sonoma Land Trust 241	Non Profit 6	Non Profit - Land Trust 10	http://www.sonomalandtrust.org/	Non Governmental Organization 10	40.53	Cedars Gateway

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);