calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES_TP = 1228 and MNG_AG

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

1 row where ACCESS_TYP = 1, DES_TP = 1228 and MNG_AG_LEV = 2

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
14435	14435	14434	{"type": "MultiPolygon", "coordinates": [[[[-124.1973, 40.7518], [-124.19679, 40.75236], [-124.19548, 40.75386], [-124.19503, 40.75446], [-124.19459, 40.75524], [-124.19445, 40.75557], [-124.19401, 40.75551], [-124.19334, 40.75549], [-124.19253, 40.7555], [-124.19192, 40.75555], [-124.19156, 40.75555], [-124.19079, 40.7553], [-124.19232, 40.75271], [-124.19232, 40.7527], [-124.19199, 40.75259], [-124.19246, 40.75181], [-124.1973, 40.7518]]], [[[-124.15849, 40.77502], [-124.15848, 40.77531], [-124.15783, 40.77531], [-124.15782, 40.77599], [-124.15741, 40.77599], [-124.15741, 40.7755], [-124.15693, 40.77549], [-124.15694, 40.7745], [-124.15794, 40.77451], [-124.15794, 40.77501], [-124.15849, 40.77502]]], [[[-124.15451, 40.7763], [-124.1545, 40.77681], [-124.15399, 40.77681], [-124.15399, 40.7763], [-124.15451, 40.7763]]], [[[-124.21288, 40.77334], [-124.2122, 40.77425], [-124.21149, 40.77491], [-124.21094, 40.77545], [-124.21067, 40.77574], [-124.21008, 40.77642], [-124.20918, 40.77753], [-124.20884, 40.77789], [-124.20804, 40.77693], [-124.20741, 40.77621], [-124.2104, 40.7738], [-124.21103, 40.77333], [-124.21288, 40.77334]]], [[[-124.14579, 40.7812], [-124.14578, 40.78148], [-124.14452, 40.78148], [-124.14452, 40.78119], [-124.14579, 40.7812]]], [[[-124.14578, 40.78154], [-124.14578, 40.78183], [-124.14451, 40.78182], [-124.14452, 40.78153], [-124.14578, 40.78154]]], [[[-124.14497, 40.78319], [-124.14497, 40.7835], [-124.14449, 40.7835], [-124.14449, 40.78319], [-124.14497, 40.78319]]], [[[-124.20775, 40.7795], [-124.20722, 40.7802], [-124.20695, 40.78089], [-124.2068, 40.78135], [-124.20671, 40.78257], [-124.20674, 40.78433], [-124.20466, 40.78318], [-124.20211, 40.78175], [-124.20255, 40.78135], [-124.20305, 40.78094], [-124.20392, 40.77996], [-124.20775, 40.7795]]], [[[-124.1581, 40.79379], [-124.15784, 40.79407], [-124.15796, 40.79456], [-124.15693, 40.79469], [-124.15694, 40.79379], [-124.1581, 40.79379]]], [[[-124.15358, 40.79601], [-124.15242, 40.79617], [-124.15229, 40.79563], [-124.15267, 40.79557], [-124.1526, 40.79527], [-124.15339, 40.79525], [-124.15358, 40.79601]]], [[[-124.14428, 40.79756], [-124.14359, 40.79746], [-124.14359, 40.7971], [-124.14427, 40.7971], [-124.14428, 40.79756]]], [[[-124.14353, 40.79792], [-124.1434, 40.79821], [-124.1432, 40.79815], [-124.14334, 40.79788], [-124.14353, 40.79792]]], [[[-124.1799, 40.8067], [-124.17989, 40.80674], [-124.1778, 40.8108], [-124.17778, 40.81089], [-124.17719, 40.81233], [-124.17519, 40.81604], [-124.17514, 40.81616], [-124.17439, 40.81729], [-124.174, 40.81776], [-124.17364, 40.81818], [-124.17309, 40.81862], [-124.17308, 40.81696], [-124.17307, 40.81695], [-124.17053, 40.81814], [-124.16522, 40.8184], [-124.16265, 40.81903], [-124.16037, 40.81971], [-124.15993, 40.81961], [-124.15981, 40.81955], [-124.15713, 40.81783], [-124.15708, 40.81767], [-124.15699, 40.81692], [-124.15698, 40.81691], [-124.15691, 40.81696], [-124.15677, 40.81695], [-124.15686, 40.81663], [-124.15691, 40.81652], [-124.15778, 40.81544], [-124.15807, 40.81589], [-124.15871, 40.81564], [-124.15835, 40.81506], [-124.15885, 40.81461], [-124.15887, 40.81466], [-124.16315, 40.81338], [-124.16434, 40.81287], [-124.16812, 40.81059], [-124.16895, 40.8114], [-124.17001, 40.81072], [-124.17035, 40.81053], [-124.17034, 40.8105], [-124.17051, 40.8104], [-124.17054, 40.81042], [-124.17082, 40.81027], [-124.1708, 40.81023], [-124.17205, 40.80951], [-124.17141, 40.80871], [-124.17298, 40.80825], [-124.17504, 40.80781], [-124.17776, 40.8073], [-124.1799, 40.8067]]], [[[-124.1582, 40.81297], [-124.15771, 40.81311], [-124.15733, 40.81325], [-124.15584, 40.81382], [-124.15354, 40.81505], [-124.15353, 40.81569], [-124.1513, 40.81657], [-124.15005, 40.81698], [-124.14952, 40.81698], [-124.14627, 40.81831], [-124.14508, 40.81878], [-124.13504, 40.82307], [-124.12323, 40.82815], [-124.11992, 40.82962], [-124.11235, 40.83247], [-124.09979, 40.82178], [-124.09956, 40.81884], [-124.09962, 40.8185], [-124.09977, 40.81802], [-124.09974, 40.8179], [-124.10017, 40.81769], [-124.10276, 40.8163], [-124.10399, 40.81586], [-124.10442, 40.81579], [-124.10493, 40.81588], [-124.10508, 40.81561], [-124.10559, 40.81538], [-124.10683, 40.81511], [-124.10725, 40.81492], [-124.10809, 40.81412], [-124.10854, 40.81398], [-124.11008, 40.81393], [-124.1136, 40.81409], [-124.11459, 40.81382], [-124.11586, 40.8127], [-124.11779, 40.81116], [-124.11835, 40.81045], [-124.1193, 40.80974], [-124.11956, 40.80923], [-124.11935, 40.80905], [-124.11967, 40.80897], [-124.11968, 40.80895], [-124.11959, 40.80869], [-124.11949, 40.80852], [-124.1193, 40.80839], [-124.11909, 40.80831], [-124.11885, 40.80826], [-124.11881, 40.80814], [-124.11941, 40.8081], [-124.11952, 40.80813], [-124.11977, 40.80825], [-124.12011, 40.80853], [-124.12046, 40.80917], [-124.12062, 40.8092], [-124.12069, 40.80927], [-124.12081, 40.80931], [-124.12098, 40.80935], [-124.12122, 40.80931], [-124.12183, 40.80914], [-124.12197, 40.80908], [-124.12206, 40.80897], [-124.12213, 40.80883], [-124.12213, 40.8087], [-124.12178, 40.80847], [-124.12131, 40.80836], [-124.12098, 40.80825], [-124.12077, 40.80814], [-124.12082, 40.80759], [-124.12101, 40.80769], [-124.12111, 40.80778], [-124.12119, 40.80794], [-124.12123, 40.80797], [-124.12131, 40.80797], [-124.12136, 40.80802], [-124.12152, 40.80807], [-124.12163, 40.80814], [-124.12165, 40.80817], [-124.1217, 40.80818], [-124.12178, 40.80823], [-124.12199, 40.80824], [-124.12208, 40.80823], [-124.12235, 40.80797], [-124.12235, 40.80785], [-124.12238, 40.8078], [-124.12239, 40.80776], [-124.12234, 40.8077], [-124.12233, 40.80757], [-124.1222, 40.80738], [-124.1222, 40.80728], [-124.12223, 40.80722], [-124.12222, 40.80706], [-124.12225, 40.80698], [-124.12228, 40.80693], [-124.12247, 40.80682], [-124.12266, 40.80659], [-124.12283, 40.80642], [-124.12303, 40.80634], [-124.12317, 40.80622], [-124.12326, 40.80619], [-124.12344, 40.80607], [-124.1239, 40.80595], [-124.12416, 40.80597], [-124.12441, 40.80596], [-124.12442, 40.80587], [-124.12447, 40.80579], [-124.12458, 40.80569], [-124.1247, 40.80569], [-124.12482, 40.80572], [-124.12496, 40.8058], [-124.12532, 40.80588], [-124.12553, 40.80602], [-124.12579, 40.80606], [-124.12598, 40.80626], [-124.12617, 40.80633], [-124.12618, 40.80636], [-124.12645, 40.80651], [-124.12685, 40.80656], [-124.1272, 40.80651], [-124.12749, 40.80642], [-124.1278, 40.80629], [-124.12902, 40.80597], [-124.12949, 40.80582], [-124.1297, 40.80572], [-124.13013, 40.80561], [-124.1305, 40.80559], [-124.13092, 40.80564], [-124.1312, 40.80563], [-124.13135, 40.80565], [-124.13216, 40.80562], [-124.13223, 40.80563], [-124.13247, 40.80571], [-124.13272, 40.80583], [-124.13277, 40.80583], [-124.13315, 40.806], [-124.13324, 40.80621], [-124.1336, 40.80645], [-124.13384, 40.80658], [-124.13412, 40.80666], [-124.13424, 40.80676], [-124.13431, 40.80686], [-124.1344, 40.80693], [-124.13446, 40.807], [-124.13459, 40.80708], [-124.1348, 40.80713], [-124.13492, 40.8072], [-124.13514, 40.80726], [-124.13526, 40.80731], [-124.13536, 40.80733], [-124.13544, 40.80738], [-124.13552, 40.80738], [-124.13558, 40.80741], [-124.13579, 40.80744], [-124.13586, 40.80747], [-124.13605, 40.80749], [-124.13628, 40.80755], [-124.13641, 40.80755], [-124.13681, 40.80765], [-124.13706, 40.80766], [-124.13725, 40.80773], [-124.13738, 40.80784], [-124.13755, 40.8079], [-124.13764, 40.80798], [-124.13778, 40.80804], [-124.13783, 40.80809], [-124.13791, 40.80811], [-124.138, 40.80819], [-124.13814, 40.80825], [-124.13826, 40.80827], [-124.13867, 40.80844], [-124.13899, 40.80854], [-124.1392, 40.80869], [-124.13933, 40.80874], [-124.14008, 40.80913], [-124.1415, 40.8099], [-124.14258, 40.81039], [-124.14323, 40.81104], [-124.14437, 40.81118], [-124.14459, 40.81122], [-124.14484, 40.81123], [-124.14505, 40.81129], [-124.14527, 40.8113], [-124.14549, 40.81127], [-124.14565, 40.81121], [-124.14596, 40.81115], [-124.14604, 40.81108], [-124.14604, 40.81107], [-124.14623, 40.81101], [-124.14954, 40.81097], [-124.14983, 40.81089], [-124.15471, 40.80934], [-124.15574, 40.8103], [-124.15608, 40.81091], [-124.15624, 40.81109], [-124.15623, 40.81114], [-124.15632, 40.81139], [-124.15675, 40.81254], [-124.15745, 40.81259], [-124.15765, 40.81249], [-124.15808, 40.81289], [-124.1582, 40.81297]]]]}	Open Access 1	47016	City of Eureka lot	30652	1419	Eureka, City of 715	City 2	City Agency 2	http://www.ci.eureka.ca.gov/depts/pnr/default.asp	City 2	1419	Eureka, City of 698	City 2	City Agency 2		Humboldt 45	2216.865	City of Eureka lot	0	None 1228

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]);