Standard Jet DBnb` Ugr@?~1y0̝cßFNb7ݜ(1/`v {6߱UmC63y[,|*|>f_Љ$g'DeFx -bT4.0 YS  Y   Y Y  Y Y  Y  Y  Y  r Y s Y E Y a Y d Y 2Y  Y   Y  jY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypenid""d"dd"YYIdParentIdName        OY\SY Y Y  Y 2ACMFInheritableObjectIdSID YObjectId Y#S#Y  Y Y Y  Y  Y gY  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -YSY Y Y  Y  Y g Y s# Y " Y dccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship"d"d" d""d"d" d""d"d" d"YYYszObject$szReferencedObjectszRelationshipL } 8 i $ U  7 h e+R > `" @ x@p ?BEIP@`4  "! B!"!D B !@@[ `# ^޻g^xZ @+kh+MkfQMYQk+L\f+kh+MJhoJmYM+mWiQJmk+JbO+kdoiMQk+kh+MkfQMYQk+kh+MkfQMYQk+JbO+MdbkQiqJmYdb+mJiUQmkkoLSdi`WJLYmJmkkfQMYQk^YkmMom'\UYMJmdikoLSdi`QMdLJkYbfiduY`YmYQkkoLSdi`UoY^O+JbO+WJLYmJm+^omkoLSdi`UoY^OkWJLYmJm+QbmivYbOYMJmdikoLSdi`\Qv+SJMmdikoLSdi``dbYmdiYbUiQfdimkQ^QMmYdbkfQMYQk kfQMYQk+JbO+UoY^OkkoLSdi`!kfQMYQk+JbO+WJLYmJmkkoLSdi`"kfQMYQk+JbO+`JbJUQ`Qbm+koLSdi`#kfQMYQk+L\f$kmioMmoiQ+koLSdi`%JhoJmYM&LYiO'`okkQ^(kQ`YJhoJmYM)mQiiQkmiYJ^*mQiiQkmiYJ^WJLYmJmiQfdim+JO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MMdbkQiqJmYdb+JMmYdbk+kh+M`dbYmdiYbU+MJmQUdiv+kh+MMdbkQiqJmYdb+mJiUQm+Lo+kh+M\Qv+SJMmdikoLSdi`+kh+MMdbkQiqJmYdb+mJiUQm+Q`fmv+kh+M\Qv+SJMmdikoLSdi`+kh+MMdbkQiqJmYdb+mJiUQm+kh+M\Qv+SJMmdikoLSdi`+kh+MUdJ^+kh+MMd`Ld8B+kh+MUdJ^+kh+MUdJ^koLSdi`+kh+MUoY^O+JbO+WJLYmJm+^omkoLSdi`+kh+MWJLYmJm+kh+MUoY^O+JbO+WJLYmJm+^omkoLSdi`+kh+MsQYUWm+kh+MUoY^Ok+kh+MUoY^O+JbO+WJLYmJm+^omkoLSdi` +kh+MWJLYmJm+Qbmiv+kh+M\Qv+SJMmdikoLSdi` +kh+MWJLYmJm+Qbmiv+kh+MkmioMmoiQ+koLSdi` +kh+M\Qv+SJMmdikoLSdi`+kh+MYbOYMJmdikoLSdi` +kh+MiQfdimkQ^QMmYdb+kh+MM`LiQfdim +kh+MkfQMYQk+L\f+kh+MJhoJmYM+WJLYmJm+koLSdi`+kh+MkfQMYQk+L\f+kh+MJhoJmYM+mWiQJmk+JbO+kdoiMQk+kh+MkfQMYQk+L\f+kh+MMWY^OD:+kh+MkfQMYQk+L\f+kh+MQMdLJkYb+kh+MkfQMYQk+L\f+kh+MkfQMYQk+JbO+MdbkQiqJmYdb+mJiUQmkkoLSdi`+kh+MkfQMYQk+L\f+kh+MkfQMYQk+JbO+UoY^OkkoLSdi`+kh+MkfQMYQk+kh+MJbd`J^YQkJbOfJiJkYmQkfJmWdUQbk+kh+MkfQMYQk+kh+MJhoJmYM+WJLYmJm+koLSdi`+kh+MkfQMYQk+kh+MJhoJmYM+mWiQJmk+JbO+kdoiMQk+kh+MkfQMYQk+kh+MMWJbbQ^kmJLY^Ymv+kh+MkfQMYQk+kh+MMWJbbQ^YxJmYdb+kh+MkfQMYQk+kh+MMWY^OD:+kh+MkfQMYQk+kh+MMWY^OD>>+kh+MkfQMYQk+kh+MMWY^OD>D+kh+MkfQMYQk+kh+MMo^qQimkJbOkmiQJ`MidkkYbUk+kh+MkfQMYQk+kh+MOJ`k+kh+MkfQMYQk+kh+MOQhOJmJfdYbmOYkkd^qQOduvUQb+kh+MkfQMYQk+kh+MOQhOJmJfdYbm`QmJ^k+kh+MkfQMYQk+kh+MOQhOJmJfdYbmbomiYQbmk+kh+MkfQMYQk+kh+MOQhOJmJfdYbmdiUJbYMk+kh+MkfQMYQk+kh+MOQhOJmJfdYbmfW+kh+MkfQMYQk+kh+MOQhOJmJfdYbmmQ`fQiJmoiQ+kh+MkfQMYQk+kh+MOQhOJmJfdYbmmoiLYOYmvmOkmkk+kh+MkfQMYQk+kh+MOiQOUYbU+kh+MkfQMYQk+kh+MQMdLJkYb +kh+MkfQMYQk+kh+MQMdLJkYbfiduY`YmYQkkoLSdi` +kh+MkfQMYQk+kh+MUidobOsJmQisYmWOiJsJ^ +kh+MkfQMYQk+kh+MWJiqQkmmJ\Q +kh+MkfQMYQk+kh+MYbqJkYqQkfQMYQk +kh+MkfQMYQk+kh+M`dbYmdiYbU:+kh+MkfQMYQk+kh+MbdbfdYbmkdoiMQW+kh+MkfQMYQk+kh+MdmWQiiJb\`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @           !"#$%&' (!)"*#+$%&'()*+,- . / 0 1 23456789:;<=>?@ABCDEFGHIJ K L M N OPQRSTUVWXYZ[\]^_`abcdefghi j k l m nopqrstuvwx"y$z%{\|\}\~\\ \ \\\\\\\\\\\\ \#\%\&yyyyyyyyy y y yyy:CI +? C!P#W&Z\b\h\\5\_\ w\ z\ \\\\\\\\!\"T\$l\'p\(wyyy y y L    $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKLMNOP      !" # $ %!&!'!(")"*"+#,#-#.$/$0$1&2&3&4'5'6'7(8(9(:);)<)=*>*?*@+A+B+C,D,E,F-G-H-I.J..///00011 1 2 2 2 3334445556667778889 9!9":#:$:%;&;';(<)<*<+=,=-=.>/>0>1?2?3?4@5@6@7A8A9A:B;B<B=C>C?C@DADBDCEDEEEFFGFHFIGJGGHHHIIIJJ J K K K LLLMMMNNNOOOPPPQQQR R!R"S#S$S%T&T'T(U)U*U+V,V-V.W/W0W1X2X3X4Y5Y6Y7Z8Z9Z:[;[<[=\>\?\@]A]B]C^D^E^F_G_H_I`J``aaabbbcc c d d d eeefffggghhhiiijjjk k!k"l#l$l%m&m'm(n)n*n+o,o-o.p/p0p1q8q9q:r;r<r=sAsBsCtDtEtFuGuHuIvJvvww w xxxy y!y"z#z$z%{2{3{4|5|6|7}8}9}:~>~?~@DE:2:3:4C5C6C7I>I?I@      +++???CCCPPPW&W'W(Z)Z*Z+b,b-b.h/h0h1;<=5A5B5C  !"#  @N!b1d !g"4$j ( )l+1-u~ }~[>&iD} (((((()))))***** *+!+#+$+%+ &+",',),*,(-+---.-/-0-,.1.3.4.5.6.2/7/9/:/;/1C1E1F1G1 H1D2I2K2L2M2N2J3O3Q3R3S3T3P4U4W4X4Y44V55555566 6 6 6 67 777778888999999::: :!:":;#;%;&;$<'<)<*<(=+=-=.=/=0=,>1>3>4>5>6>2?7?9?:?;?AAACADABBEBGBHBFCICKCLCJDMDODPDNEQESETERFUFWFFVGGGGHHHHI I I I J JJJJJKKKKKKLLLLMMM MN!Q @+ MBD:O>J@DO8Q>6@J6SM6Q>F+ +;K[+ OSFO:8S>:O:6>HFLHM:J>DQ:JO:FHD:H+ +;K[kfQMYQkmvfQ^omkfQMYQk @kfQMYQkkfQMYQk+JbO+WJLYmJmkkfQMYQk+JbO+WJLYmJmk @WJLYmJmkfQMYQkkfQMYQkmvfQ^om,d _ Z g  ~K S _  "HZ~D1'YUBHh#Y@Y@Terrestrial Habitat Reportrr@bbbVVVVVVVT @"+A@+A@Terrestrialr@DDD88888886 @! l@ l@Semi-Aquaticr@FFF:::::::8 @ C(u@C(u@MusselrJ@:::......., @dr@dr@Birdr@666*******( @yz$̐@z$̐@Structure_Subformr&.UPPPDDDDDDDB @_"@@_"@@Species_BKPr @DDD88888886 @]Y@]Y@Species_And_Management_subformr @jjj^^^^^^^\ @er@er@Species_and_Habitats subformr@fffZZZZZZZX @\@\@Species_and_Guilds subformr@bbbVVVVVVVT @y7`_@7`_@Report Selectionr @NNNBBBBBBB@ @|m@|m@MonitoringrL@BBB66666664 @ͷ@ͷ@Key_Factor Subformrl@RRRFFFFFFFD @+Zͷ@+Zͷ@Indicator Subformr@PPPDDDDDDDB @xkͷ@xkͷ@Habitat_Entryr@HHH<<<<<<<: @ fЌ@ fЌ@Guildsr@:::......., @dAԌ@dAԌ@Guild_and_Habitat_LUT subformr@hhh\\\\\\\Z @=%"@=%"@EcoBasin Proximities Subformr& @fffZZZZZZZX @yjFhx"@jFhx"@Ecobasin Indicator Data Entryr@hhh\\\\\\\Z @ TN@TN@EcoBasinrr@>>>22222220 @ Ñ@Ñ@Data_Gapsr@@@@44444442 @ As@As@Conservation_Actionsr&@VVVJJJJJJJH @ h>@h>@Aquatic_Threats_And_Sourcesrv@dddXXXXXXXV @ o@o@Aquatic_HabitatrT@LLL@@@@@@@> @ pZr@pZr@UserDefinedrA@DDD88888886 @ pZr@pZr@SummaryInfor@DDD88888886 @yXZr@XZr@SysRelr.........., XZr@XZr@Scriptsr0000000000. pZr@pZr@Reportsr0000000000. XZr@XZr@Modulesr0000000000. pZr@pZr@Formsr,,,,,,,,,,* XZr@XZr@DataAccessPagesr@@@@@@@@@@> 0Zr@0Zr@MSysRelationshipssDDDDDDDDDDB 0Zr@0Zr@MSysQueriess88888888886 0Zr@0Zr@MSysACEss22222222220 0Zr@0Zr@MSysObjectss88888888886 0Zr@>ڪ"@MSysDbr@:::......., @0Zr@0Zr@Relationshipss<<<<<<<<<<: 0Zr@0Zr@Databasess44444444442 0Zr@0Zr@Tabless.........., O[xtN L 6 2Ka IG7~zFC$gcB@@@W@@W؄R$@W؄R$@~sq_cSpecies~sq_cCulverts and Stream Crossings||||||||||| ?["@["@~sq_cSpecies~sq_cChild747r4MR2KeepLocal TTTTTTTTR @>["@["@~sq_cSpecies~sq_cChild744r4MR2KeepLocal TTTTTTTTR @<["@["@~sq_cSpecies~sq_cChannelizationr4MR2KeepLocal T```````^ @;["@["@~sq_cSpecies~sq_cChannel Stabilityr4MR2KeepLocal Tfffffffd @9["@["@~sq_cSpecies~sq_cAquatic_Habitat_Subformr4MR2KeepLocal Trrrrrrrp @8'["@'["@~sq_cSpecies~sq_cAnomalies and Parasites-Pathogensr4MR2KeepLocal T @7&Om@m@~sq_cSpecies_BKP~sq_cSpecies_and_Guilds subformr4MR2KeepLocal T~ @y5m@m@~sq_cSpecies_BKP~sq_cEcoBasinr4MR2KeepLocal T\\\\\\\Z @4m@m@~sq_cSpecies_BKP~sq_cChild72r4MR2KeepLocal TZZZZZZZX @y2m@m@~sq_cSpecies_BKP~sq_cAquatic_Habitat_Subformr4MR2KeepLocal Tzzzzzzzx @1e8@=@~sq_cReport Selection~sq_ccmbReportr4MR2KeepLocal Thhhhhhhf @y/\PT@#PT@~sq_cHabitat_Entry~sq_cStructure_Subformr4MR2KeepLocal Trrrrrrrp @.}@}@~sq_cHabitat_Entry~sq_cKey_Factor subformr4MR2KeepLocal Ttttttttr @y,K@K@~sq_cGuild_and_Habitat_LUT subform~sq_cweightr4MR2KeepLocal T|||||||z @+K@K@~sq_cGuild_and_Habitat_LUT subform~sq_cHabitatr4MR2KeepLocal T~~~~~~~| @y)7s@7s@~sq_cGoal~sq_cCombo16r4MR2KeepLocal TLLLLLLLJ @(QX@QX@~sq_cConservation_Target~sq_cKey_Factor subformr4MR2KeepLocal T~ @y&;у@{<у@~sq_cConservation_Target_BU~sq_cKey_Factor subformr4MR2KeepLocal T @%0Zr@0Zr@~sq_cConservation_Actions~sq_cMonitoring_Categorys yZjL.jL. d F (  j L .  h B $ v J  x Z "  l-i?!u4IUepRkE'4Species_and_ManagementSpecies_BKPSS= 4  G4__id O4 4 G3([__ID] = Species_ID)4 '3Aquatic_Threats_And_SourcesSpecies_BKP]]G 3  G3__ID O3 3 G2([__ID] = Species_ID)4 '2Aquatic_HabitatSpecies_BKPEE/ 2  G2__ID O2 2 G1 1 '1[ReportLUT].[ReportType]7 g1[ReportLUT].[ReportName]7 g1ReportLUT### 1 1 G0([__ID] = Key_Factor_ID)7 '0Key_Factor subformSELECT * FROM [Indicator]; ^5 70  G0__ID O0 0 G/([__ID] = Habitat_ID)4 '/StructureHabitat_Entry==# /  G/__ID O/ / G.B@  '.Habitat_Entry@ 7+ 7.  G.__ID O. . G-([__ID] = Guild_ID)2 '-Guilds@) 7-  G-__ID O- - G,Guild_Weights+++ ,  G, , G+ 1 '+[id]# g+[habitat_name]- g+Habitat + + G*B@ '*GoalSELECT * FROM Goal; ; 7*  G*__ID O* * G)V@ g)Indicator_Selector555 ) G) ) G(B@ '(Conservation_Target@C7 7(  G(__ID O( ( G'B@ ''Conservation_Target_EmptyR@OC 7'  G'__ID O' ' G&B@ '&Conservation_Target_BUR@I= 7&  G&__ID O& & G%CA_Category_LUT/// %  G% % GLVALl . @X>d 8.S_Rank_LUT.S_Rank=All_Species_Query.S_RankG_Rank_LUT.G_Rank=All_Species_Query.G_RankAll_Species_Query.Mississippi_Valley_Loess_PlainsAll_Species_Query.Mississippi_Alluvial_PlainsAll_Species_Query.South_Central_PlainsAll_Species_Query.Arkansas_ValleyAll_Species_Query.Boston_MountainsAll_Species_Query.Population_TrendAll_Species_Query.[Terrestrial or Aquatic]All_Species_Query.Scientific_Name((g_rank_lut.score_value+s_rank_lut.score_value)*[Trend_Multiplier])/0.2625Key_Factor.Key_Factor_DescriptionKey_Factor.Conservation_Target_ID[Guild_and_Habitat_LUT].[Habitat_ID][Guild_and_Habitat_LUT].[Guild_ID]SELECT Population.Population_Name, Population.Frank, Population.Number_of_EORs, Population.Rationale, Population.Species_ID FROM Population; ([__ID] = Conservation_Target_ID)SELECT [Key_Factor].[Conservation_Target_ID], [Key_Factor].[Key_Factor_Name], [Key_Factor].[Key_Factor_Description], [Key_Factor].[Key_Factor_Source], [Key_Factor].[Category], [Key_Factor].[ID], [kf_weight] FROM Key_Factor; SELECT [Guild_and_Habitat_LUT].[Guild_ID], [Guild_and_Habitat_LUT].[Habitat_ID], [weight] FROM Guild_and_Habitat_LUT; ([__ID] = Conservation_Target_ID)Indicator_Selector.Conservation_Target_Name([__ID] = Conservation_Target_ID)SELECT Key_Factor.Conservation_Target_ID, Key_Factor.Key_Factor_Name, Key_Factor.Key_Factor_Description, Key_Factor.Key_Factor_Source, Key_Factor.Category, Key_Factor.ID, Key_Factor.HUC_Importance, Key_Factor.HUC_Ownership, Key_Factor.HUC_Where_SP FROM Key_Factor; ([__ID] = Conservation_Target_ID)SELECT Key_Factor.Conservation_Target_ID, Key_Factor.Key_Factor_Name, Key_Factor.Key_Factor_Description, Key_Factor.Key_Factor_Source, [category], [ID] FROM Key_Factor; ([__ID] = Conservation_Target_ID)SELECT Key_Factor.Conservation_Target_ID, Key_Factor.Key_Factor_Name, Key_Factor.Key_Factor_Description, Key_Factor.Key_Factor_Source, [category], [ID] FROM Key_Factor; )X]?~X:  a ;  f H * z \  o Q r T  ^@"E' q0r1kM/9sU7A#F  GF F GESensitivities Weight LUTAAA E  GE E GDSensitivities Weight LUTAAA D  GD D GCSensitivities Weight LUTAAA C  GC C GBSensitivities Weight LUTAAA B  GB B GASensitivities Weight LUTAAA A  GA A G@Sensitivities Weight LUTAAA @  G@ @ G?([__ID] = Species_ID)4 '?Data_GapsSpecies11# ?  G?__ID O? ? G>([__ID] = Species_ID)4 '>Conservation_ActionsSpeciesGG9 >  G>__ID O> > G=([__id] = species_id)4 '=Species_and_ManagementSpeciesKK= =  G=__id O= = G<Sensitivities Weight LUTAAA <  G< < G;Sensitivities Weight LUTAAA ;  G; ; G:([__ID] = Species_ID)4 ':Aquatic_Threats_And_SourcesSpeciesUUG :  G:__ID O: : G9([__ID] = Species_ID)4 '9Aquatic_HabitatSpecies==/ 9  G9__ID O9 9 G8Sensitivities Weight LUTAAA 8  G8 8 G7([__ID] = Species_ID)4 '7Species_and_GuildsSpecies_BKPKK5 7  G7__ID O7 7 G6([__ID] = Species_ID)4 '6Species_and_HabitatsSpecies_BKPOO9 6  G6__ID O6 6 G5([__ID] = Species_ID)4 '5EcoBasinSpecies_BKP77! 5  G5__ID O5 5 G4([__id] = species_id)4 'ORNN L " KE AJ  HWSGEC GCBAA__لR$@لR$@~sq_لR$@لR$@~sq_fSpecies_And_Management_subformfffffffffff ^~["@~["@~sq_fSpeciesr4MR2KeepLocal Tzzz:::::::8 @ \#PT@#PT@~sq_fHabitat_Entryr4MR2KeepLocal TFFFFFFFD @ ZI.@I.@~sq_fGuild_and_Habitat_LUT subformr4MR2KeepLocal Tfffffffd @Yېx"@ېx"@~sq_fEcobasin Indicator Data Entryr4MR2KeepLocal Tfffffffd @ Wf["@f["@~sq_cSpecies~sq_cSpecies_and_Guilds subformr4MR2KeepLocal Txxxxxxxv @V["@g["@~sq_cSpecies~sq_cSpecies_and_Conservation_Targets subformr4MR2KeepLocal T @ Tr["@r["@~sq_cSpecies~sq_cRecreational Activities, Access Proximityr4MR2KeepLocal T @SĢS@ĢS@~sq_cSpecies~sq_cPopulation subformr4MR2KeepLocal Thhhhhhhf @ Qg["@g["@~sq_cSpecies~sq_cOther Rankr4MR2KeepLocal TXXXXXXXV @O["@["@~sq_cSpecies~sq_cMonitoring2r4MR2KeepLocal TZZZZZZZX @N'["@["@~sq_cSpecies~sq_cInvasive Speciesr4MR2KeepLocal Tdddddddb @Mr["@r["@~sq_cSpecies~sq_cHarvest/Taker4MR2KeepLocal T\\\\\\\Z @Kf["@f["@~sq_cSpecies~sq_cEcoBasin Proximities Subformr4MR2KeepLocal T|||||||z @I["@["@~sq_cSpecies~sq_cDredgingr4MR2KeepLocal TTTTTTTTR @H'["@'["@~sq_cSpecies~sq_cDEQ Data Point Turbidity, TDS, TSSr4MR2KeepLocal T @F'["@'["@~sq_cSpecies~sq_cDEQ Data Point pHr4MR2KeepLocal Tfffffffd @Er["@r["@~sq_cSpecies~sq_cDEQ Data Point Organicsr4MR2KeepLocal Trrrrrrrp @Cr["@r["@~sq_cSpecies~sq_cDEQ Data Point Metalsr4MR2KeepLocal Tnnnnnnnl @B'["@'["@~sq_cSpecies~sq_cDEQ Data Point Dissolved Oxygenr4MR2KeepLocal T @([vX bD& ~ X : [ =  f  p R 4  f H  mwY;mO|.hJ$qS5`B$|^( Z Z GYEcoBasin_LUT))) Y  GY Y GXSensitivities Weight LUTAAA X  GX X GW([__ID] = Species_ID)4 'WSpecies_and_GuildsSpeciesCC5 W  GW__ID OW W GV([__ID] = Species_ID)4 'VSpecies_and_HabitatsSpeciesGG9 V  GV__ID OV V GUSensitivities Weight LUTAAA U  GU U GTSensitivities Weight LUTAAA T  GT T GS([__ID] = Species_ID)4 'SSpecies@ + 7S  GS__ID OS S GRSensitivities Weight LUTAAA R  GR R GQSensitivities Weight LUTAAA Q  GQ Q GPSensitivities Weight LUTAAA P  GP P GO([__ID] = Species_ID)4 'OMonitoringSpecies33% O  GO__ID OO O GNSensitivities Weight LUTAAA N  GN N GMSensitivities Weight LUTAAA M  GM M GLSensitivities Weight LUTAAA L  GL L GK([__ID] = Species_ID)4 'KEcoBasinSpecies//! K  GK__ID OK K GJ([__ID] = Species_ID)4 'JEcoBasinSpecies//! J  GJ__ID OJ J GISensitivities Weight LUTAAA I  GI I GHSensitivities Weight LUTAAA H  GH H GGSensitivities Weight LUTAAA G  GG G GFSensitivities Weight LUTAAA  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @%%%%&&&&& &' ' ' ''' (((((()))))***** *+!+#+$+%+ &+",',),*,(-+---.-/-0-,.1.3.4.5.6.2/7/9/:/;/1C1E1F1G1 H1D2I2K2L2M2N2J3O3Q3R3S3T3P4U4W4X4Y44V55555566 6 6 6 67 777778888999999::: :!:":;#;%;&;$<'<)<*<(=+=-=.=/=0=,>1>3>4>5>6>2?7?9?:?;?AAACADABBEBGBHBFCICKCLCJDMDODPDNEQESETERFUFWFFVGGGGHHHHI I I I J JJJJJKKKKKKLLLLMMM MN!Q! @ @ @ @ @ @ @ @ @ @ @ @ @ @N#N$N"O%O'O(O)O*O&P+P-P.P,Q/Q1Q2Q0R3R5R6R4S7S9S:S;SUAUCUDUBVEVGVHVIVJVFWKWMWNWOWPWLXQXSXTXRYUYWYXYVZYZZZZZZ[[[[\\ \ \  \ ] ]]]]]]]]]^^^^____``!`"` a#a%a&a'a(a$b)b+b,b-b.b/b0b1b2b3b4b5b6b 7b 8b 9b :b ;bb?b@bAbBb Cb Db Eb Fb Gb Hb Ib Jb  Kb  Lb  Mb  b  b b b b b b b b*c c c c cccccccccccc c c c c ccc c!c"c#c$c%c&c'c(c)c*c+c,c-c.c/c0c1c2c d3d5d6d7d8d9d:d;dd?d@d Ad Bd Cd Dd Ed d d d d d d d4    @ @ @@  JhoJmYM+WJLYmJmJhoJmYM+mWiQJmk+JbO+kdoiMQkMdbkQiqJmYdb+JMmYdbkOJmJ+UJfkQMdLJkYbQMdLJkYbYbOYMJmdiOJmJQbmivQMdLJkYbYbOYMJmdikoLSdi`QMdLJkYbfiduY`YmYQkkoLSdi`UoY^O+JbO+WJLYmJm+^omkoLSdi`UoY^OkWJLYmJm+QbmivYbOYMJmdikoLSdi`\Qv+SJMmdikoLSdi``dbYmdiYbUiQfdimkQ^QMmYdbkfQMYQk kfQMYQk+JbO+UoY^OkkoLSdi`!kfQMYQk+JbO+WJLYmJmkkoLSdi`"kfQMYQk+JbO+`JbJUQ`Qbm+koLSdi`#kfQMYQk+L\f$kmioMmoiQ+koLSdi`%JhoJmYM&LYiO'`okkQ^(kQ`YJhoJmYM)mQiiQkmiYJ^*mQiiQkmiYJ^WJLYmJmiQfdim+JO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MMdbkQiqJmYdb+JMmYdbk+kh+M`dbYmdiYbU+MJmQUdiv+kh+MMdbkQiqJmYdb+mJiUQm+Lo+kh+M\Qv+SJMmdikoLSdi`+kh+MMdbkQiqJmYdb+mJiUQm+Q`fmv+kh+M\Qv+SJMmdikoLSdi`+kh+MMdbkQiqJmYdb+mJiUQm+kh+M\Qv+SJMmdikoLSdi`+kh+MUdJ^+kh+MMd`Ld8B+kh+MUdJ^+kh+MUdJ^koLSdi`+kh+MUoY^O+JbO+WJLYmJm+^omkoLSdi`+kh+MWJLYmJm+kh+MUoY^O+JbO+WJLYmJm+^omkoLSdi`+kh+MsQYUWm+kh+MUoY^Ok+kh+MUoY^O+JbO+WJLYmJm+^omkoLSdi` +kh+MWJLYmJm+Qbmiv+kh+M\Qv+SJMmdikoLSdi` +kh+MWJLYmJm+Qbmiv+kh+MkmioMmoiQ+koLSdi` +kh+M\Qv+SJMmdikoLSdi`+kh+MYbOYMJmdikoLSdi` +kh+MiQfdimkQ^QMmYdb+kh+MM`LiQfdim +kh+MkfQMYQk+L\f+kh+MJhoJmYM+WJLYmJm+koLSdi`+kh+MkfQMYQk+L\f+kh+MJhoJmYM+mWiQJmk+JbO+kdoiMQk+kh+MkfQMYQk+L\f+kh+MMWY^OD:+kh+MkfQMYQk+L\f+kh+MQMdLJkYb+kh+MkfQMYQk+L\f+kh+MkfQMYQk+JbO+MdbkQiqJmYdb+mJiUQmkkoLSdi`+kh+MkfQMYQk+L\f+kh+MkfQMYQk+JbO+UoY^OkkoLSdi`+kh+MkfQMYQk+kh+MJbd`J^YQkJbOfJiJkYmQkfJmWdUQbk+kh+MkfQMYQk+kh+MJhoJmYM+WJLYmJm+koLSdi`+kh+MkfQMYQk+kh+MJhoJmYM+mWiQJmk+JbO+kdoiMQk+kh+MkfQMYQk+kh+MMWJbbQ^kmJLY^Ymv+kh+MkfQMYQk+kh+MMWJbbQ^YxJmYdb+kh+MkfQMYQk+kh+MMWY^OD:+kh+MkfQMYQk+kh+MMWY^OD>>+kh+MkfQMYQk+kh+MMWY^OD>D+kh+MkfQMYQk+kh+MMo^qQimkJbOkmiQJ`MidkkYbUk+kh+MkfQMYQk+kh+MOJ`k+kh+MkfQMYQk+kh+MOQhOJmJfdYbmOYkkd^qQOduvUQb+kh+MkfQMYQk+kh+MOQhOJmJfdYbm`QmJ^k+kh+MkfQMYQk+kh+MOQhOJmJfdYbmbomiYQbmk+kh+MkfQMYQk+kh+MOQhOJmJfdYbmdiUJbYMk+kh+MkfQMYQk+kh+MOQhOJmJfdYbmfW+kh+MkfQMYQk+kh+MOQhOJmJfdYbmmQ`fQiJmoiQ+kh+MkfQMYQk+kh+MOQhOJmJfdYbmmoiLYOYmvmOkmkk+kh+MkfQMYQk+kh+MOiQOUYbU+kh+MkfQMYQk+kh+MQMdLJkYb +kh+MkfQMYQk+kh+MQMdLJkYbfiduY`YmYQkkoLSdi` +kh+MkfQMYQk+kh+MUidobOsJmQisYmWOiJsJ^ +kh+MkfQMYQk+kh+MWJiqQkmmJ\Q +kh+MkfQMYQk+kh+MYbqJkYqQkfQMYQk +kh+MkfQMYQk+kh+M`dbYmdiYbU:+kh+MkfQMYQk+kh+MbdbfdYbmkdoiMQW+kh+MkfQMYQk+kh+MdmWQiiJb\`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOU @@@ +kh+MkfQMYQk+L\f+kh+MMWY^OD:+kh+MkfQMYQk+L\f+kh+MQMdLJkYb+kh+MkfQMYQk+L\f+kh+MkfQMYQk+JbO+MdbkQiqJmYdb+mJiUQmkkoLSdi`+kh+MkfQMYQk+L\f+kh+MkfQMYQk+JbO+UoY^OkkoLSdi`+kh+MkfQMYQk+kh+MJbd`J^YQkJbOfJiJkYmQkfJmWdUQbk+kh+MkfQMYQk+kh+MJhoJmYM+WJLYmJm+koLSdi`+kh+MkfQMYQk+kh+MJhoJmYM+mWiQJmk+JbO+kdoiMQk+kh+MkfQMYQk+kh+MMWJbbQ^kmJLY^Ymv+kh+MkfQMYQk+kh+MMWJbbQ^YxJmYdb+kh+MkfQMYQk+kh+MMWY^OD:+kh+MkfQMYQk+kh+MMWY^OD>>+kh+MkfQMYQk+kh+MMWY^OD>D+kh+MkfQMYQk+kh+MMo^qQimkJbOkmiQJ`MidkkYbUk+kh+MkfQMYQk+kh+MOJ`k+kh+MkfQMYQk+kh+MOQhOJmJfdYbmOYkkd^qQOduvUQb+kh+MkfQMYQk+kh+MOQhOJmJfdYbm`QmJ^k+kh+MkfQMYQk+kh+MOQhOJmJfdYbmbomiYQbmk+kh+MkfQMYQk+kh+MOQhOJmJfdYbmdiUJbYMk+kh+MkfQMYQk+kh+MOQhOJmJfdYbmfW+kh+MkfQMYQk+kh+MOQhOJmJfdYbmmQ`fQiJmoiQ+kh+MkfQMYQk+kh+MOQhOJmJfdYbmmoiLYOYmvmOkmkk+kh+MkfQMYQk+kh+MOiQOUYbU+kh+MkfQMYQk+kh+MQMdLJkYb +kh+MkfQMYQk+kh+MQMdLJkYbfiduY`YmYQkkoLSdi` +kh+MkfQMYQk+kh+MUidobOsJmQisYmWOiJsJ^ +kh+MkfQMYQk+kh+MWJiqQkmmJ\Q +kh+MkfQMYQk+kh+MYbqJkYqQkfQMYQk +kh+MkfQMYQk+kh+M`dbYmdiYbU:+kh+MkfQMYQk+kh+MbdbfdYbmkdoiMQW+kh+MkfQMYQk+kh+MdmWQiiJb\+kh+MkfQMYQk+kh+MfdYbmkdoiMQ+kh+MkfQMYQk+kh+Mfdfo^JmYdbkoLSdi`+kh+MkfQMYQk+kh+MiQMiQJmYdbJ^JMmYqYmYQkJMMQkkfiduY`Ymv+kh+MkfQMYQk+kh+MkQOY`Qbm+kh+MkfQMYQk+kh+MkfQMYQk+JbO+MdbkQiqJmYdb+mJiUQmkkoLSdi`+kh+MkfQMYQk+kh+MkfQMYQk+JbO+UoY^OkkoLSdi`+kh+MkfQMYQk+kh+MmWQi`J^iQUY`Q+kh+SQMdLJkYbYbOYMJmdiOJmJQbmiv+kh+SUoY^O+JbO+WJLYmJm+^omkoLSdi`+kh+SUoY^Ok+kh+SWJLYmJm+Qbmiv+kh+S\Qv+SJMmdikoLSdi`+kh+SkfQMYQk+kh+SkfQMYQk+JbO+`JbJUQ`Qbm+koLSdi`+kh+SkfQMYQk+L\fJ^^+kfQMYQk+hoQivJ^^+kfQMYQk+iJb\QOJhoJmYMJ`fWYLYJbiQfdimJhoJmYMMiJvSYkWiQfdimJhoJmYMSYkWiQfdimJhoJmYMYbqQimQLiJmQiQfdimJhoJmYMkfQMYQkQMdLJkYbkGJhoJmYMmQiiQkmiYJ^J`fWYLYJbiQfdimJhoJmYMmQiiQkmiYJ^MiJvSYkWiQfdim JhoJmYMmQiiQkmiYJ^SYkWiQfdim JhoJmYMmQiiQkmiYJ^YbkQMmiQfdim JhoJmYMmQiiQkmiYJ^YbqQimQLiJmQiQfdim JhoJmYMmQiiQkmiYJ^iQfmY^QiQfdim JhoJmYM+J`fWYLYJb+hoQivJhoJmYM+MiJvSYkW+hoQivJhoJmYM+SYkW+hoQivJhoJmYM+WJLYmJmJhoJmYM+WJLYmJm+^omJhoJmYM+WJLYmJm+miJbk^JmQOJhoJmYM+YbqQimQLiJmQ+hoQivJhoJmYM+mWiQJmk+JbO+kdoiMQkLYiOiQfdimJO;LYiOiQfdimQd;LYiOiQfdimfx;LYiO+hoQivMJ+MJmQUdiv+^omMYmJmYdbkMdbkQiqJmYdbJMmYdbkMdiQkMdbkQiqJmYdb+JMmYdbkOJmJ+UJfkQMdLJkYbQMdLJkYbMidkksJ^\ QMdLJkYbYbOYMJmdi!QMdLJkYbkMdiQk"QMdLJkYb+^om#`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQONd0pR& ~ T  ] $ g I + i =   I + y9~<$j@{7w|:Fb D@ gb D@ gb S_Rank_LUT.Description5 gb G_Rank_LUT.Description5 gb All_Species_Query.G_Rank7 gb All_Species_Query.S_Rank7 gb T@ gb All_Species_Query.Taxa5 gb B@ gb All_Species_Query.Common_Name< gb @ gbTrend_LUTAll_Species_Queryn@QE# bS_Rank_LUTAll_Species_QueryT@SG% bG_Rank_LUTAll_Species_QueryT@SG% bAll_Species_Query.Ozarks7 gbb@ gbZ@ gbL@ gb All_Species_Query.Ouachitas: gb B@ gb D@ gb D@ gb S_Rank_DescriptionS_Rank_LUT.DescriptionY55 obG_Rank_DescriptionG_Rank_LUT.DescriptionY55 obAll_Species_Query.G_Rank7 gbAll_Species_Query.S_Rank7 gbT@ gbAll_Species_Query.Taxa5 gbB@ gbAll_Species_Query.Common_Name< gbViability_Score@;// obAll_Species_Query333 bG_Rank_LUT%%% bS_Rank_LUT%%% bTrend_LUT### b b GaX7YZ_____2<@1% 7aX7YZ_____1ܨU1% 7a Ga  Ga a G`Species `  G` ` G_Species_and_Management=== _  G_ _ G^Species ^  G^ ^ G] [kf_weight]* g]Key_Factor.ID, g]Key_Factor.Category2 g]Key_Factor.Key_Factor_Source; g]B@ g]Key_Factor.Key_Factor_Name9 g]B@ g]Key_Factor%%% ] ] G\ [habitat_name]- '\Habitat \ G\ \ G[Guilds [  G[ [ GZ [weight]' gZH@  gZD@  gZGuild_and_Habitat_LUT;;; _'O Mk ? K ` @ @C% "@11 "@Ecobasin IndicatorrtMURRRFFFFFFFD @+]-@r=%"@EcoBasinrO1MU>>>22222220 @ a1@Inu@Data_Gapsri@@@@44444442 @G o@M@Conservation_Actionsr@VVVJJJJJJJH @wZ,@WƔP@Conservation Action Scoresr@`@nbbVVVVVVVT @^@N@CA_Category_LUTr@LLL@@@@@@@> @v@6e@Bird_Queryr@`@NBB66666664 @u3B*S@@Bird Report P-Zr @@XLL@@@@@@@> @tH3S@E@Bird Report E-Or< @@XLL@@@@@@@> @s5@me@Bird Report A-Dr @@XLL@@@@@@@> @r7YHu@] 5@Aquatic_Invertebrate_Queryr!MU`@nbbVVVVVVVT @qwxXU@~@Aquatic_Habitat_Translatedr@@nbbVVVVVVVT @C֡#@,ͺ@Aquatic_Habitat_LUTr@TTTHHHHHHHF @:Y@XU@Aquatic_Habitatr@LLL@@@@@@@> @pzXU@)@Aquatic_Fish_Queryr!MU`@^RRFFFFFFFD @n0u@J@Aquatic_Amphibian_Queryr@`@h\\PPPPPPPN @mgct@t{&@Aquatic/Terrestrial Reptile ReportrMU@~rrfffffffd @lƔ5W@7cu@Aquatic/Terrestrial Invertebrate Reportr @@||pppppppn @k!J)W@O4%@Aquatic/Terrestrial Insect Reportr>U@|ppdddddddb @iV@$@Aquatic/Terrestrial Crayfish Reportr>U@tthhhhhhhf @hCGt@2,@Aquatic/Terrestrial Amphibian Reportr>U@vvjjjjjjjh @gK~@SU@Aquatic Species - EcobasinsrY@@pddXXXXXXXV @fh-@:@Aquatic Invertebrate Reportr@@pddXXXXXXXV @dNڷ@.@Aquatic Crayfish Reportry>U@h\\PPPPPPPN @c0@S@Aquatic Amphibian Reportr @@j^^RRRRRRRP @b%^m@S@All_Species_Rankedr>U@^RRFFFFFFFD @a(i@SS@All_Species_QueryrY@`@\PPDDDDDDDB @LVALܨUSELECT Species.Common_Name, Species.Scientific_Name, Species.Taxa, Species.[Terrestrial or Aquatic], Species.S_Rank, Species.G_Rank, Species.Comments, Species.Boston_Mountains, Species.Arkansas_Valley, Species.Ouachitas, Species.South_Central_Plains, Species.Mississippi_Alluvial_Plains, Species.Mississippi_Valley_Loess_Plains, Species.Ozarks, Species.Federal_Status, Species.Class, [Species].[Order], Species.Family, Species.Residence, "Habitats" as Element_Name, Species_and_Habitats_Weights_Translated.Habitat as Element, "" as Category, Species_and_Habitats_Weights_Translated.Description as Weight, Population_Trend FROM Species INNER JOIN Species_and_Habitats_Weights_Translated ON Species.ID = Species_and_Habitats_Weights_Translated.Species_ID UNION ALL SELECT Species.Common_Name, Species.Scientific_Name, Species.Taxa, Species.[Terrestrial or Aquatic], Species.S_Rank, Species.G_Rank, Species.Comments, Species.Boston_Mountains, Species.Arkansas_Valley, Species.Ouachitas, Species.South_Central_Plains, Species.Mississippi_Alluvial_Plains, Species.Mississippi_Valley_Loess_Plains, Species.Ozarks, Species.Federal_Status, Species.Class, [Species].[Order], Species.Family, Species.Residence, "Problems Faced" as Element_Name, Threat_text as Element, "Threat: " & Aquatic_Threats_And_Sources.Threat & " Source: " & Aquatic_Threats_And_Sources.Source as Category, "" as Weight, Population_Trend FROM Species INNER JOIN Aquatic_Threats_And_Sources ON Species.ID = Aquatic_Threats_And_Sources.Species_ID UNION ALL SELECT Species.Common_Name, Species.Scientific_Name, Species.Taxa, Species.[Terrestrial or Aquatic], Species.S_Rank, Species.G_Rank, Species.Comments, Species.Boston_Mountains, Species.Arkansas_Valley, Species.Ouachitas, Species.South_Central_Plains, Species.Mississippi_Alluvial_Plains, Species.Mississippi_Valley_Loess_Plains, Species.Ozarks, Species.Federal_Status, Species.Class, [Species].[Order], Species.Family, Species.Residence, "Data Gaps/Research Needs" as Element_Name, Data_Gaps.Data_Gaps as Elem" LVAL2 ent, "" as Category, "" as Weight, Population_Trend FROM Species INNER JOIN Data_Gaps ON Species.ID = Data_Gaps.Species_ID UNION ALL SELECT Species.Common_Name, Species.Scientific_Name, Species.Taxa, Species.[Terrestrial or Aquatic], Species.S_Rank, Species.G_Rank, Species.Comments, Species.Boston_Mountains, Species.Arkansas_Valley, Species.Ouachitas, Species.South_Central_Plains, Species.Mississippi_Alluvial_Plains, Species.Mississippi_Valley_Loess_Plains, Species.Ozarks, Species.Federal_Status, Species.Class, [Species].[Order], Species.Family, Species.Residence, "Conservation Actions" as Element_Name, Conservation_Actions.Conservation_Actions as Element, Conservation_Actions.CA_Category as Category, Conservation_Actions.Importance as Weight, Population_Trend FROM Species INNER JOIN Conservation_Actions on Species.ID = Conservation_Actions.Species_ID LVAL V ~ * `X|.~00v4FPS_Rank_LUT.S_Rank = Aquatic_Amphibian_Query.S_RankG_Rank_LUT.G_Rank = Aquatic_Amphibian_Query.G_RankAquatic_Amphibian_Query.PageOrderAquatic_Amphibian_Query.Population_Trend(([g_rank_lut].[score_value]+[s_rank_lut].[score_value])*[Trend_Multiplier])/0.2625Aquatic_Amphibian_Query.Element_NameAquatic_Amphibian_Query.ResidenceAquatic_Amphibian_Query.Federal_StatusAquatic_Amphibian_Query.Mississippi_Valley_Loess_PlainsAquatic_Amphibian_Query.Mississippi_Alluvial_PlainsAquatic_Amphibian_Query.South_Central_PlainsAquatic_Amphibian_Query.OuachitasAquatic_Amphibian_Query.Arkansas_ValleyAquatic_Amphibian_Query.Boston_MountainsAquatic_Amphibian_Query.[Terrestrial or Aquatic]Aquatic_Amphibian_Query.Scientific_NameAquatic_Amphibian_Query.Common_Name((g_rank_lut.score_value+s_rank_lut.score_value)*[Trend_Multiplier])/0.2625All_Species_Query.Mississippi_Valley_Loess_PlainsAll_Species_Query.Mississippi_Alluvial_PlainsAll_Species_Query.South_Central_PlainsAll_Species_Query.Arkansas_ValleyAll_Species_Query.Boston_MountainsAll_Species_Query.Population_TrendAll_Species_Query.[Terrestrial or Aquatic]All_Species_Query.Scientific_Name((g_rank_lut.score_value+s_rank_lut.score_value)*[Trend_Multiplier])/0.2625Trend_LUT.Trend_Text=All_Species_Query.Population_TrendSELECT Species.Common_Name, Species.Scientific_Name, Species.Taxa, Species.[Terrestrial or Aquatic], Species.S_Rank, Species.G_Rank, Species.Comments, Species.Boston_Mountains, Species.Arkansas_Valley, Species.Ouachitas, Species.South_Central_Plains, Species.Mississippi_Alluvial_Plains, Species.Mississippi_Valley_Loess_Plains, Species.Ozarks, Species.Federal_Status, Species.Class, [Species].[Order], Species.Family, Species.Residence, "Monitoring Strategies" as Element_Name, Monitoring.Monitoring_Strategy as Element, Monitoring.Monitoring_Category as Category, "" as Weight, Population_Trend FROM Species INNER JOIN Monitoring ON Species.ID = Monitoring.Species_IDFe;I u C  q ) k  w M # f  48x">f^,CqGd t@  gd l@  gd ^@  gd H@  gd T@ gdV@ gdF@ gdB@ gdB@ gdb@ gd![Aquatic_Crayfish_Query].[Taxa]> gdT@ gdL@ gdAquatic_Crayfish_Query=== dG_Rank_LUT%%% dS_Rank_LUT%%% dTrend_LUT### d d GcTrend_LUTAquatic_Amphibian_Query~@]Q# cS_Rank_LUTAquatic_Amphibian_Queryd@_S% cG_Rank_LUTAquatic_Amphibian_Queryd@_S% cAquatic_Amphibian_Query.team; gcB@ gcP@ gcViability_Score@;// ocS_Rank_LUTS_Rank_LUT.Score_ValueI%% ocS_Rank_DescriptionS_Rank_LUT.DescriptionY55 ocG_Rank_ValueG_Rank_LUT.Score_ValueM)) ocG_Rank_DescriptionG_Rank_LUT.DescriptionY55 oc Aquatic_Amphibian_Query.Weight= gc"Aquatic_Amphibian_Query.Category? gc!Aquatic_Amphibian_Query.Element> gcH@ gcB@ gc Aquatic_Amphibian_Query.Family= gcAquatic_Amphibian_Query.Order< gcAquatic_Amphibian_Query.Class< gcL@ gc Aquatic_Amphibian_Query.Ozarks= gc n@ gc f@ gc X@ gc B@ gc N@ gcP@ gc"Aquatic_Amphibian_Query.Comments? gc Aquatic_Amphibian_Query.G_Rank= gc Aquatic_Amphibian_Query.S_Rank= gc`@ gcAquatic_Amphibian_Query.Taxa; gcN@  gcF@  gcAquatic_Amphibian_Query??? cG_Rank_LUT%%% cS_Rank_LUT%%% cTrend_LUT### c Gc Gc c Gb d@  /b S_Rank_LUT.Score_Value5 gb G_Rank_LUT.Score_Value5 gb All_Species_Query.Ozarks7 gb b@  gb Z@  gb L@ gb All_Species_Query.Ouachitas: gb B@ gLVAL+6> ` f D h  N R .b 4t2Fh [Aquatic_Invertebrate_Query].[Scientific_Name][Aquatic_Invertebrate_Query].[Common_Name](((Aquatic_Fish_Query.Common_Name)="Paddlefish"))Trend_LUT.Trend_Text = Aquatic_Fish_Query.Population_TrendS_Rank_LUT.S_Rank = Aquatic_Fish_Query.S_RankG_Rank_LUT.G_Rank = Aquatic_Fish_Query.G_RankAquatic_Fish_Query.Population_Trend(([g_rank_lut].[score_value]+[s_rank_lut].[score_value])*[Trend_Multiplier])/0.2625Aquatic_Fish_Query.Federal_StatusAquatic_Fish_Query.Mississippi_Valley_Loess_PlainsAquatic_Fish_Query.Mississippi_Alluvial_PlainsAquatic_Fish_Query.South_Central_PlainsAquatic_Fish_Query.Arkansas_ValleyAquatic_Fish_Query.Boston_MountainsAquatic_Fish_Query.[Terrestrial or Aquatic]Aquatic_Fish_Query.Scientific_Name[Trend_LUT].[Trend_Text]=[Aquatic_Crayfish_Query].[Population_Trend][S_Rank_LUT].[S_Rank]=[Aquatic_Crayfish_Query].[S_Rank][G_Rank_LUT].[G_Rank]=[Aquatic_Crayfish_Query].[G_Rank][Aquatic_Crayfish_Query].[PageOrder][Aquatic_Crayfish_Query].[Population_Trend](([g_rank_lut].[score_value]+[s_rank_lut].[score_value])*[Trend_Multiplier])/0.2625[Aquatic_Crayfish_Query].[Weight][Aquatic_Crayfish_Query].[Category][Aquatic_Crayfish_Query].[Element][Aquatic_Crayfish_Query].[Element_Name][Aquatic_Crayfish_Query].[Residence][Aquatic_Crayfish_Query].[Family][Aquatic_Crayfish_Query].[Federal_Status][Aquatic_Crayfish_Query].[Ozarks][Aquatic_Crayfish_Query].[Mississippi_Valley_Loess_Plains][Aquatic_Crayfish_Query].[Mississippi_Alluvial_Plains][Aquatic_Crayfish_Query].[South_Central_Plains][Aquatic_Crayfish_Query].[Ouachitas][Aquatic_Crayfish_Query].[Arkansas_Valley][Aquatic_Crayfish_Query].[Boston_Mountains][Aquatic_Crayfish_Query].[Comments][Aquatic_Crayfish_Query].[G_Rank][Aquatic_Crayfish_Query].[S_Rank][Aquatic_Crayfish_Query].[Terrestrial or Aquatic][Aquatic_Cra