calands: units_with_maps: 5 rows where ACCESS_TYP = 2, LAYER = 10 and MNG

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

5 rows where ACCESS_TYP = 2, LAYER = 10 and MNG_AGENCY = 89

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
485	485	484	{"type": "MultiPolygon", "coordinates": [[[[-119.57997, 35.64111], [-119.57116, 35.64112], [-119.57115, 35.64445], [-119.56896, 35.64444], [-119.56895, 35.64466], [-119.56222, 35.64465], [-119.56221, 35.64444], [-119.53554, 35.64451], [-119.53554, 35.63747], [-119.5445, 35.63746], [-119.54453, 35.63473], [-119.56227, 35.63466], [-119.56228, 35.63556], [-119.56671, 35.63557], [-119.56672, 35.63466], [-119.56672, 35.63375], [-119.56894, 35.63374], [-119.56894, 35.63556], [-119.56672, 35.63557], [-119.56671, 35.63648], [-119.5656, 35.63647], [-119.56227, 35.63647], [-119.56226, 35.63738], [-119.57996, 35.63738], [-119.57997, 35.64111]], [[-119.5445, 35.63926], [-119.54451, 35.63927], [-119.54893, 35.63924], [-119.54895, 35.63744], [-119.54451, 35.63746], [-119.5445, 35.63926]]], [[[-119.57113, 35.64487], [-119.571, 35.64832], [-119.57096, 35.65194], [-119.56622, 35.65193], [-119.56626, 35.64877], [-119.56625, 35.64836], [-119.54891, 35.64846], [-119.54898, 35.64468], [-119.56038, 35.64466], [-119.5604, 35.64486], [-119.57113, 35.64487]]], [[[-119.5624, 35.61941], [-119.5623, 35.63012], [-119.55342, 35.63014], [-119.55351, 35.6229], [-119.55793, 35.6229], [-119.55797, 35.61939], [-119.5624, 35.61941]]], [[[-119.57117, 35.63011], [-119.57116, 35.63193], [-119.56895, 35.63193], [-119.56894, 35.63284], [-119.56673, 35.63284], [-119.56673, 35.63193], [-119.56894, 35.63193], [-119.56895, 35.63011], [-119.57117, 35.63011]]], [[[-119.57999, 35.64466], [-119.57999, 35.64522], [-119.57705, 35.64523], [-119.57707, 35.64466], [-119.57999, 35.64466]]], [[[-119.59769, 35.67028], [-119.59764, 35.6761], [-119.59324, 35.67614], [-119.59324, 35.67793], [-119.59762, 35.67791], [-119.59761, 35.67928], [-119.59321, 35.67928], [-119.59317, 35.68115], [-119.58869, 35.68114], [-119.58877, 35.67389], [-119.57999, 35.67388], [-119.58005, 35.67027], [-119.59769, 35.67028]]], [[[-119.61603, 35.6738], [-119.61597, 35.67618], [-119.61571, 35.67622], [-119.61129, 35.67624], [-119.61128, 35.67386], [-119.60655, 35.67391], [-119.60663, 35.65931], [-119.59776, 35.65928], [-119.59771, 35.66659], [-119.58004, 35.66658], [-119.58008, 35.66298], [-119.58008, 35.65926], [-119.58018, 35.65192], [-119.58019, 35.64466], [-119.58437, 35.64466], [-119.58439, 35.64373], [-119.58552, 35.64323], [-119.58552, 35.64466], [-119.58937, 35.64466], [-119.58938, 35.64299], [-119.58883, 35.64298], [-119.58884, 35.64179], [-119.59048, 35.64108], [-119.5978, 35.64104], [-119.60681, 35.64109], [-119.60691, 35.64469], [-119.6067, 35.6447], [-119.60664, 35.6593], [-119.61136, 35.65928], [-119.61129, 35.67386], [-119.61603, 35.6738]], [[-119.59342, 35.64829], [-119.59341, 35.64828], [-119.58895, 35.64829], [-119.58892, 35.65193], [-119.59339, 35.65195], [-119.59342, 35.64829]]], [[[-119.58551, 35.64111], [-119.58551, 35.64274], [-119.58439, 35.64323], [-119.5844, 35.64111], [-119.58551, 35.64111]]]]}	Restricted Access 2	1663	Semitropic Ridge Preserve	25298	3014	Center for Natural Lands Management 91	Non Profit 6	Non Profit - Land Trust 10	http://cnlm.org/	Non Governmental Organization 10	3014	Center for Natural Lands Management 89	Non Profit 6	Non Profit - Land Trust 10	Kern 36	3174.028	Semitropic Ridge Preserve	Private Conservation 16	2
488	488	487	{"type": "Polygon", "coordinates": [[[-119.21476, 35.98254], [-119.21472, 35.98615], [-119.21039, 35.98615], [-119.21036, 35.98257], [-119.21476, 35.98254]]]}	Restricted Access 2	1685	Pixley Preserve	23759	3014	Center for Natural Lands Management 91	Non Profit 6	Non Profit - Land Trust 10	http://cnlm.org/	Non Governmental Organization 10	3014	Center for Natural Lands Management 89	Non Profit 6	Non Profit - Land Trust 10	Tulare 29	38.802	Pixley Preserve	Private Conservation 16	2
4060	4060	4059	{"type": "Polygon", "coordinates": [[[-121.31247, 37.79887], [-121.31231, 37.79887], [-121.31215, 37.79792], [-121.31163, 37.79777], [-121.31063, 37.79718], [-121.31108, 37.79717], [-121.30868, 37.79559], [-121.30905, 37.79558], [-121.30926, 37.79592], [-121.30941, 37.79594], [-121.30956, 37.79593], [-121.30979, 37.79587], [-121.31003, 37.79577], [-121.31022, 37.79562], [-121.31042, 37.79539], [-121.31047, 37.79537], [-121.31063, 37.79537], [-121.31077, 37.79531], [-121.31085, 37.79526], [-121.3109, 37.79519], [-121.31157, 37.79363], [-121.31164, 37.79355], [-121.31181, 37.79339], [-121.31193, 37.7933], [-121.31219, 37.79319], [-121.31255, 37.79301], [-121.31276, 37.79296], [-121.31294, 37.79296], [-121.31319, 37.79301], [-121.3134, 37.79309], [-121.31373, 37.79337], [-121.31399, 37.79372], [-121.31408, 37.79387], [-121.31412, 37.79404], [-121.31414, 37.7945], [-121.31408, 37.79469], [-121.31368, 37.79534], [-121.31292, 37.79634], [-121.31259, 37.7968], [-121.31243, 37.79719], [-121.31229, 37.79719], [-121.31225, 37.79788], [-121.31232, 37.79845], [-121.31247, 37.79887]]]}	Restricted Access 2	44401	Oxbow Preserve	23279	3014	Center for Natural Lands Management 91	Non Profit 6	Non Profit - Land Trust 10	http://cnlm.org/	Non Governmental Organization 10	3014	Center for Natural Lands Management 89	Non Profit 6	Non Profit - Land Trust 10	San Joaquin 39	29.0	Oxbow Preserve	Private Conservation 16	2
5743	5743	5742	{"type": "Polygon", "coordinates": [[[-118.80468, 35.30073], [-118.80465, 35.30104], [-118.80378, 35.30167], [-118.80361, 35.30255], [-118.80293, 35.30324], [-118.80213, 35.30536], [-118.79828, 35.30539], [-118.79834, 35.31117], [-118.79623, 35.3112], [-118.78942, 35.31125], [-118.78932, 35.30933], [-118.79132, 35.30932], [-118.79813, 35.29826], [-118.79809, 35.29664], [-118.80437, 35.29658], [-118.80435, 35.297], [-118.80368, 35.29757], [-118.80336, 35.29974], [-118.8039, 35.29995], [-118.80468, 35.30073]]]}	Restricted Access 2	1675	Sand Ridge Preserve	25013	3014	Center for Natural Lands Management 91	Non Profit 6	Non Profit - Land Trust 10	http://cnlm.org/	Non Governmental Organization 10	3014	Center for Natural Lands Management 89	Non Profit 6	Non Profit - Land Trust 10	Kern 36	255.651	Sand Ridge Preserve	Private Conservation 16	2
6345	6345	6344	{"type": "MultiPolygon", "coordinates": [[[[-119.50967, 35.34708], [-119.50965, 35.35427], [-119.50514, 35.35429], [-119.5051, 35.34707], [-119.50967, 35.34708]]], [[[-119.57165, 35.35414], [-119.57156, 35.35781], [-119.56817, 35.3578], [-119.56827, 35.35413], [-119.57165, 35.35414]]], [[[-119.49189, 35.35619], [-119.49188, 35.35711], [-119.48967, 35.35711], [-119.48965, 35.35803], [-119.48748, 35.35803], [-119.4875, 35.35437], [-119.49082, 35.35436], [-119.49079, 35.35619], [-119.49189, 35.35619]]], [[[-119.59567, 35.35428], [-119.59351, 35.3565], [-119.58936, 35.35885], [-119.58936, 35.35428], [-119.59567, 35.35428]]], [[[-119.53633, 35.36145], [-119.53181, 35.36147], [-119.53183, 35.36513], [-119.52072, 35.3651], [-119.51961, 35.36511], [-119.51848, 35.36509], [-119.51846, 35.36553], [-119.51846, 35.36686], [-119.51668, 35.36667], [-119.515, 35.36637], [-119.51439, 35.36616], [-119.51384, 35.36592], [-119.51292, 35.36541], [-119.51257, 35.36517], [-119.51847, 35.36508], [-119.51852, 35.35423], [-119.53624, 35.35415], [-119.53633, 35.36145]]], [[[-119.60711, 35.36877], [-119.60276, 35.36876], [-119.60268, 35.36154], [-119.59821, 35.36155], [-119.59819, 35.35977], [-119.58937, 35.35979], [-119.58937, 35.35905], [-119.59366, 35.35662], [-119.59594, 35.35427], [-119.60699, 35.35427], [-119.60711, 35.36877]]], [[[-119.56274, 35.36412], [-119.55397, 35.36418], [-119.55395, 35.36875], [-119.5494, 35.36876], [-119.54944, 35.36331], [-119.54509, 35.36331], [-119.54502, 35.36876], [-119.54066, 35.36875], [-119.5407, 35.36144], [-119.54509, 35.36146], [-119.55396, 35.36153], [-119.56273, 35.36148], [-119.56274, 35.36412]]], [[[-119.57256, 35.36887], [-119.57221, 35.36974], [-119.57208, 35.37013], [-119.57211, 35.36899], [-119.57228, 35.36887], [-119.57256, 35.36887]]], [[[-119.51846, 35.36878], [-119.50969, 35.36883], [-119.50968, 35.3724], [-119.51407, 35.37243], [-119.51408, 35.37603], [-119.50516, 35.37603], [-119.50515, 35.37304], [-119.50294, 35.37303], [-119.50293, 35.37243], [-119.50076, 35.37243], [-119.50077, 35.36536], [-119.50733, 35.36525], [-119.51004, 35.36526], [-119.51188, 35.36653], [-119.51296, 35.36712], [-119.51364, 35.36742], [-119.51438, 35.36768], [-119.51529, 35.36792], [-119.51846, 35.36843], [-119.51846, 35.36878]]], [[[-119.55394, 35.37244], [-119.54503, 35.37244], [-119.545, 35.37604], [-119.54946, 35.37604], [-119.54948, 35.3779], [-119.5539, 35.37789], [-119.55389, 35.37971], [-119.54944, 35.37973], [-119.54946, 35.3779], [-119.54499, 35.37787], [-119.54499, 35.37604], [-119.53611, 35.376], [-119.53626, 35.37242], [-119.52954, 35.37244], [-119.52959, 35.36876], [-119.53641, 35.36874], [-119.53627, 35.37241], [-119.54502, 35.37244], [-119.54503, 35.37055], [-119.55394, 35.37058], [-119.55394, 35.37244]]], [[[-119.57229, 35.37264], [-119.57233, 35.37208], [-119.57244, 35.37133], [-119.57249, 35.37116], [-119.57252, 35.37098], [-119.57266, 35.37044], [-119.5729, 35.36972], [-119.57324, 35.36886], [-119.5807, 35.36879], [-119.58941, 35.36879], [-119.5894, 35.3725], [-119.58935, 35.37785], [-119.58935, 35.38148], [-119.58496, 35.38148], [-119.58502, 35.37611], [-119.57219, 35.37619], [-119.57229, 35.37301], [-119.57229, 35.37264]]], [[[-119.58062, 35.37792], [-119.58058, 35.37969], [-119.57834, 35.37972], [-119.57835, 35.38056], [-119.58057, 35.38055], [-119.58054, 35.38327], [-119.57616, 35.38326], [-119.57619, 35.37972], [-119.57623, 35.37796], [-119.58062, 35.37792]]], [[[-119.53577, 35.38325], [-119.53031, 35.38325], [-119.52734, 35.38328], [-119.51848, 35.38331], [-119.51847, 35.37247], [-119.5252, 35.37248], [-119.52541, 35.37288], [-119.52568, 35.37325], [-119.52593, 35.37349], [-119.52676, 35.37417], [-119.52731, 35.37451], [-119.52733, 35.37974], [-119.53296, 35.37971], [-119.53302, 35.37981], [-119.53577, 35.38325]]], [[[-119.55428, 35.38327], [-119.55388, 35.38361], [-119.55388, 35.38361], [-119.55388, 35.38328], [-119.55428, 35.38327]]], [[[-119.56718, 35.38508], [-119.56718, 35.38689], [-119.5661, 35.38689], [-119.56607, 35.38601], [-119.56499, 35.38601], [-119.56499, 35.38508], [-119.56718, 35.38508]]], [[[-119.53609, 35.39051], [-119.53295, 35.39056], [-119.53196, 35.39055], [-119.53198, 35.38692], [-119.53609, 35.3869], [-119.53609, 35.39051]]], [[[-119.6381, 35.39059], [-119.63807, 35.39419], [-119.63369, 35.39419], [-119.63367, 35.39061], [-119.6381, 35.39059]]], [[[-119.5985, 35.39054], [-119.59823, 35.39768], [-119.58936, 35.39771], [-119.58932, 35.39048], [-119.5985, 35.39054]]], [[[-119.57164, 35.39769], [-119.56994, 35.39769], [-119.56897, 35.39776], [-119.5695, 35.39763], [-119.56972, 35.39755], [-119.57003, 35.39742], [-119.5705, 35.39717], [-119.57082, 35.39695], [-119.57101, 35.39679], [-119.57139, 35.39641], [-119.57159, 35.39613], [-119.57164, 35.39769]]], [[[-119.57133, 35.3887], [-119.57138, 35.39408], [-119.57136, 35.39443], [-119.57128, 35.39483], [-119.57114, 35.39521], [-119.57102, 35.39548], [-119.57071, 35.39592], [-119.57064, 35.39599], [-119.57048, 35.39617], [-119.57034, 35.3963], [-119.56996, 35.3966], [-119.56978, 35.39672], [-119.5697, 35.39675], [-119.56947, 35.39688], [-119.5693, 35.39696], [-119.56899, 35.39709], [-119.5683, 35.39726], [-119.56789, 35.39733], [-119.5627, 35.39778], [-119.56203, 35.39703], [-119.5579, 35.39312], [-119.55731, 35.39261], [-119.55642, 35.39224], [-119.55558, 35.39205], [-119.5539, 35.39204], [-119.55388, 35.38384], [-119.55458, 35.38326], [-119.56272, 35.38327], [-119.56265, 35.38691], [-119.56262, 35.39038], [-119.56609, 35.39039], [-119.56609, 35.38962], [-119.56497, 35.38963], [-119.56498, 35.3887], [-119.56718, 35.3887], [-119.56718, 35.39039], [-119.56938, 35.3904], [-119.56939, 35.39039], [-119.56936, 35.38327], [-119.57125, 35.38328], [-119.57126, 35.38417], [-119.57044, 35.38417], [-119.57044, 35.38506], [-119.57128, 35.38507], [-119.57133, 35.3887]]], [[[-119.54502, 35.39777], [-119.54283, 35.39776], [-119.54283, 35.39519], [-119.545, 35.39518], [-119.54502, 35.39777]]], [[[-119.53612, 35.39776], [-119.52771, 35.39779], [-119.52592, 35.39664], [-119.52407, 35.39429], [-119.52748, 35.39429], [-119.52749, 35.3933], [-119.52971, 35.39331], [-119.52971, 35.39428], [-119.53502, 35.39432], [-119.53503, 35.39431], [-119.53503, 35.39333], [-119.53611, 35.39333], [-119.53612, 35.39776]]], [[[-119.56049, 35.39784], [-119.55849, 35.39783], [-119.55848, 35.39816], [-119.55806, 35.39819], [-119.55805, 35.39782], [-119.5539, 35.39779], [-119.5539, 35.39354], [-119.55573, 35.39362], [-119.55661, 35.39402], [-119.55745, 35.39494], [-119.56049, 35.39784]]], [[[-119.58935, 35.4015], [-119.58714, 35.4015], [-119.58713, 35.3988], [-119.58493, 35.39879], [-119.58492, 35.39967], [-119.58268, 35.39967], [-119.58268, 35.39878], [-119.58383, 35.39878], [-119.58384, 35.39793], [-119.58934, 35.39793], [-119.58935, 35.4015]]], [[[-119.58942, 35.40913], [-119.5868, 35.40761], [-119.58583, 35.40724], [-119.5844, 35.40681], [-119.58109, 35.40572], [-119.57432, 35.40365], [-119.57165, 35.4027], [-119.57163, 35.39792], [-119.58049, 35.39792], [-119.58048, 35.40149], [-119.58044, 35.40509], [-119.5827, 35.4051], [-119.5827, 35.40332], [-119.58493, 35.40331], [-119.58496, 35.40509], [-119.58939, 35.40507], [-119.58942, 35.40913]]], [[[-119.58944, 35.41233], [-119.57169, 35.41234], [-119.57166, 35.40422], [-119.58149, 35.4072], [-119.58643, 35.40904], [-119.58943, 35.41094], [-119.58944, 35.41233]]], [[[-119.59383, 35.43607], [-119.58944, 35.43607], [-119.58942, 35.43418], [-119.58083, 35.43422], [-119.58066, 35.42683], [-119.58939, 35.42672], [-119.58943, 35.43417], [-119.59382, 35.43415], [-119.59383, 35.43607]]]]}	Restricted Access 2	1667	Lokern Preserve	21402	3014	Center for Natural Lands Management 91	Non Profit 6	Non Profit - Land Trust 10	http://cnlm.org/	Non Governmental Organization 10	3014	Center for Natural Lands Management 89	Non Profit 6	Non Profit - Land Trust 10	Kern 36	3878.379	Lokern Preserve	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]);